Operational Data Store (ODS) Defined
I see a lot of confusion on what exactly is an Operational Data Store (ODS). While it can mean different...
2015-03-12 (first published: 2015-02-26)
9,624 reads
Monitor Query Statistics
One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task....
2015-03-10 (first published: 2015-02-26)
8,437 reads
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...
2015-03-17 (first published: 2015-02-26)
8,672 reads
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...
2015-02-26
1,460 reads
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...
2015-02-26
10 reads
Dynamic Data Masking
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2015-03-11 (first published: 2015-02-26)
8,904 reads
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....
2015-02-25
1,442 reads
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....
2015-02-25
1,297 reads
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...
2015-03-09 (first published: 2015-02-25)
8,826 reads
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...
2015-02-25
949 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers