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 – Tips working with Files inside SQL Server
Placing data and log files on different drives is not the whole story. Here are my tips for working with files inside SQL Server as a DBA.
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 – FIX – Export Error – ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
Importing an Excel file with the SSMS Import Wizard failed because the Microsoft.ACE.OLEDB.12.0 provider is not registered. Here is how I fixed it.
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 – Evaluation Period Has Expired – How to Activate SQL Server?
Chose Evaluation Edition in a hurry and now the evaluation period has expired? Here is how to activate SQL Server by moving to a licensed edition.