Diagnose low disk pressure in tempdb before moving files, inspect transaction and allocation usage, and plan a verified Windows restart.
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.
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 – 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.
Interview Question of the Week #025 – How to Implement Paging in SQL Server?
Implement paging with deterministic OFFSET FETCH, correct ROW_NUMBER boundaries, and keyset navigation for deeper SQL Server pages.
SQL SERVER – Using PowerShell and Native Client to run queries in SQL Server
A friend wanted PowerShell and Native Client, not SQL PowerShell, to run queries against SQL Server. Here is the small sample script I wrote for it.
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.