Code Snippet Cove on the #SQLPrompt Treasure Map

I’ve been away a bit in the last week with personal and family commitments. As a result, I feel a...

GDPR, Database Backups, and the Right to be Forgotten

I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...

Azure SQL Database and Columnstore Indexes

I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...

# Not the GDPR News -t minus 10 days

# Not the GDPR News -t minus 10 days

There is ten days to go and there are still some seats left for...

What’s in a Name?: Inside the Wacky World of T-SQL Identifiers

(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...

How to Check SQL Server View Utilization

If you are working on SQL Server optimization delicately, you may get often queries that how to find if any...

Checking Availability Groups with dbachecks

It’s been 45 days since we released dbachecks
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQpic.twitter.com/N8W01KaKo9
— Rob Sewell (@sqldbawithbeard) February...

Brief Description about SQL Server Encryption

Encryption is a good technique using which a particular data is obfuscated with a key or password. This makes the data useless until any decryption key or password is...

Brief Description about SQL Server Encryption

Encryption is a good technique using which a particular data is obfuscated with a key or password. This makes the...

Hide and Abstract the physical layer

How to build an abstraction layer between physical and logical layers in the database code