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.
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.