T-SQL Tuesday #101–Tools

This month’s T-SQL Tuesday is brought to you by Jens Vestergaard. The invitation for #101 is for essential SQL Server...

Using Elastic Query to Support SQL Spatial in Azure SQL DW

[read this post on Mr. Fox SQL blog]
Recently we had a requirement to perform SQL Spatial functions on data that...

Using Elastic Query to Support SQL Spatial in Azure SQL DW

[read this post on Mr. Fox SQL blog] Recently we had a requirement to perform SQL Spatial functions on data that was stored in Azure SQL DW.  Seems simple...

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

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

Encrypting SQL Server Database Backups

We all go to great lengths to make sure that our databases are secure (or at least I really hope...

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

Why didn't my Azure ARM deploy work?

I have been using Octopus to deploy ARM templates for a while now and the default task that comes with...

Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?

(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:

SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...

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