SQL Server Encryption, What’s The Key Hierarchy All About?

 
I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...

SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)?

(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...

Two Posts About PASS

I’m a little late getting to this, but I think both of these are worth reading:
https://www.linkedin.com/pulse/open-letter-pass-group-leaders-sql-saturday-steve-rezhener-mba/https://medium.com/@SteffLocke/sqlsaturdays-shouldnt-give-up-pass-money-a478a97ee0c7Suggest you post any thoughts...

Why I Love Extended Events, Reason 394: Customize Live Data

There are so many reasons to love Extended Events that it can really be overwhelming, but, one more reason that...

Azure Every Day, Azure Data Week, and More Azure

As you likely know, I am a Principal Consultant at Pragmatic Works. This year we have been doing some great...

Bringing DevOps to #SQLSat Oslo

As my kids get older and I spend less time with them, I look forward to visiting new countries. While...

Experimenting SysTools SQL Database Repair Tool by SQL MVP Shashank

Author Bio: Shashank is a TechNet Wiki Ninja who loves to work on SQL Server. He lives in Mumbai and...

Identifying records with special characters (Unicode)

Occasionally Data analyst may fall in a situation, where they need to identify records holding special characters or only the...

Leveraging on SQL Server metadata

I’m working on a project where I need to convert Firebird SQL code into T-SQL code.

No schema, just the modules....

Warning: Expect Delays

Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper,...