Licencje, ach te licencje… Temat licencjonowania rozwiązań w chmurze publicznej może nie jest specjalnie złożony, ale na pewno można go długo analizować. Na początku roku napisałem nawet kilka artykułów na sql4You.info, które dość głęboko traktują temat – przy okazji zachęcam do lektury, warto zacząć od wprowadzenia: ASK ME ANYTHING – Licencjonowanie rozwiązań w chmurze Celem…
Tag: sql server
SQL Server Tools default Location
SQL Server Tools default Location SQL Server工具預設位置 Tools SQL Server versions Location sqlcmd.exe, bcp.exe SQL 2008 R2 C:Program FilesMicrosoft SQL Server100ToolsBinn SQL 2012 C:Program FilesMicrosoft SQL Server110ToolsBinn SQL 2014 C:Program FilesMicrosoft SQL ServerClient SDKODBC110ToolsBinn SQL 2016 C:Program FilesMicrosoft SQL ServerClient SDKODBC110ToolsBinn Integration Services component dtexec.exe SQL 2008 R2 C:Program FilesMicrosoft SQL Server100 DTSBinn C:Program…
SQL Updates Newsletter – May 2017
Recent Releases and Announcements SQL Server 2017 CTP 2.1 now available The primary enhancement to SQL Server 2017 in this release is the ability to configure SQL Server configuration settings through environment variables passed in as parameters to Docker run. This enables many of the SQL Server configuration scenarios in Docker containers such as setting…
SQL SERVER Transactional and Merge Replication internal and work flow explained
Recently Sravani and I delivered session on SQL SERVER Transactional and Merge Replication and covered following topics: Different types of Replication in SQL Server Transaction replication work flow and troubleshooting latency – tips Merge replication workflow and troubleshooting agent failures Understanding Merge replication metadata Replication with SQL Server Availability groups Demos for replication issues You can…
SQL Server 2017 In-Database Python を使ってみた
4月19日の Data Amp で SQL Server 2017 の Python Integration が正式に発表されました。これは SQL Server 2016 で機能追加された SQL Server 2016 R Services を SQL Server 2017 Machine Learning Services に拡張し、R に加えて Python による Advanced Analytics を利用可能にするという内容です。 そこで今回は Python を T-SQL を用いて実行する In-Database Python を試してみようと思います。
How to reset forgotten sa password
How to reset forgotten sa password 如何重設sa密碼 或 忘記sa密碼的情況下加入一個SQL管理員帳戶 如果忘記sa密碼，有2個方法解決 方法一 不需要重啟SQL Server服務，但Login裡面必須要原本就有NT AUTHORITYSYSTEM帳戶，且此帳戶要有sysadmin Role 1.下載Sysinternals的psexec.exe工具 https://technet.microsoft.com/en-us/sysinternals/bb897553.aspx 2.啟動命令提示字元，用psexec.exe來啟動SSMS，就可以用NT SERVICESYSTEM身分Windows驗證登入 PsExec.exe -s -i “C:Program Files (x86)Microsoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe” SQL Server Managment Studio default locations 方法二 處理過程會有downtime，因為需重新啟動SQL Server服務。 1.停止SQL Server服務 2.啟動第1個命令提示字元，以Single user mode啟動SQL Server Start the SQL Server instance using single user mode (or minimal configuration which…
SQL Server Integration Services ( SSIS ) Scale Out
Microsoft Japan Data Platform Tech Sales Team 中川 SQL Server の ETL ツールとして提供してきました SQL Server Integration Services (以降 SSIS と称す) ですが、SQL Server 2017 にて Scale Out という機能拡張が行われました。今回はその Scale Out という機能についてご紹介します。
It’s never too late for Partitioning your Tables
Only a few developers design their tables for partitioning from ground up, simply because they do not envision that a table once might become so big that partitioning would become a real advantage. And even if they do, the fact that partitioning is an Enterprise-only feature (at least until SQL 2016 SP1) keeps them away…
Troubleshooting SQL Queries Generated by Dynamics NAV
The documentation on Optimizing SQL Server Performance with Microsoft Dynamics NAV has been updated with information about: Troubleshooting long running SQL queries involving FlowFields by disabling SmartSQL. Using SQL Server 2016 Query Store to monitor query performance in Dynamics NAV. Read more at https://msdn.microsoft.com/en-us/dynamics-nav/optimizing-sql-server-performance-with-microsoft-dynamics-nav Please get back to us if you miss documentation around…
Parallel Processing in SAP
New generations of CPUs do not provide any significant single-thread performance improvements. Instead, the number of logical CPU cores is increasing with each new CPU generation. You can significantly reduce the runtime of a task by running sub-tasks in parallel on many CPU cores. However, splitting a task into sub-tasks consumes additional resources (CPU and…