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

Syspolicy Phantom Health Records

SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is...

Syspolicy Phantom Health Records

SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system...

Query tuning: Apply yourself

It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to...

When was my last backup / CheckDB / index maintenance?

Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean...

SQL Server 2017 on Linux in the Azure portal

SQL Server 2017 now is considered as a hybrid database enterprise solution as it expands its market and is ported to...

Friday Reading 2018-04-06

Feels like an age since I posted some links. So busy these days!
I’m really excited today as tomorrow I head...

Did you know…you can’t do arithmetic operations with datetime2 like with datetime?

I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I...

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2

(last updated: 2018-04-28)

Recap
In Part 1 of this 2 part series, I started with the loose definition in Microsoft’s documentation for...