Notes from the Field #087: why you should disable CPU power saving on your SQL Server, and how this one setting can quietly slow queries.
SQL SERVER – Getting Started and Creating JSON Using SQL Server 2016 – JavaScript Object Notation
SQL Server 2016 adds JSON support. Here is a quick look at what JSON (JavaScript Object Notation) is and how to create your first JSON document with a query.
Interview Question of the Week #026 – 64 Bit Vs 32 Bit Confusion
Resolve 64 bit vs 32 bit questions for SQL Server, separate engine and client architecture, and inspect the actual Windows host.
SQL Server – 2016 – New Feature: Dynamic Data Masking
Would you want your credit card number shown in clear text? Dynamic Data Masking, new in SQL Server 2016, hides sensitive data right in the database.
SQL SERVER – How Do We Find Deadlocks? – Notes from the Field #086
To Find Deadlocks, I collect the graph of competing sessions and resources. The cycle distinguishes a deadlock from ordinary blocking.
SQL SERVER – PowerShell to Count Number of VLFs in SQL Server
Too many VLFs can hurt performance. Here is a simple PowerShell script that counts the VLFs in every database on one or many SQL Server instances.
SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085
Clients sometimes send files made with Results To File in SSMS. Kevin shows how to convert standard SSMS file results to delimited data you can load.