Monitor Query Statistics

One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task....

Exam Prep 70-463: SSIS Expressions

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

How to do DevOps as a SQL Server DBA

You recognize that you need to provide a pipeline for database deployments, that you need to automate as much support...

Dynamic Data Masking

Dynamic Data Masking
FEBRUARY 26, 2015

Have you ever wanted to only show parts of a field to certain sets of users such as credit card numbers, telephone numbers or last...

Dynamic Data Masking

Dynamic Data MaskingFEBRUARY 26, 2015

Have you ever wanted to only show parts of a field to certain sets of users...

Parsing SQL Saturday Data – Getting Titles from the XML document

I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database....

Using sp_DBPermissions and sp_SrvPermissions v6.0

It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting....

Solving a slow running query issue with UNION

That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!
I recently encountered...

PWDCOMPARE–a hidden function of SQL SERVER TIP #88

 
I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to...

How to Encrypt password in SQL Server ? TIP #87

Security is always a concern for every database developer. How to secure valuable information is one of the major and...