It’s not usual for development projects to undergo an architecture review, but too many times these reviews consist only of...
2015-03-13 (first published: 2015-03-09)
5,652 reads
I was testing something the other day and realized this was a security area I didn’t completely understand. I decided...
2015-03-12
1,235 reads
A short piece, as I ran into the need recently to alter a column to NOT NULL status. I’ve rarely...
2015-03-12
793 reads
One of the beloved feature of SQL server standard edition for HA is database mirroring, since you only have 2-node...
2015-03-12
494 reads
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
Most companies required to keep their database backup offsite (on tape) for many years due to audit requirement. This normally...
2015-03-12
971 reads
In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion. You can read about that here. I recommend reading...
2015-03-11
13 reads
In last post TIP #91 we talked about What is Data compression ? What are the features ? Now in this tip...
2015-03-11
630 reads
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
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions,...
2015-03-11
1,237 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers