ExpressProfiler - new build published
Just published new signed build of ExpressProfiler - few nice improvements like advanced search, stay on top window, transparency - just to make...
2015-02-09
615 reads
Powershell to Robocopy files (say, to back up your computer to protect against CryptoWall trojan)
We were having a good time on DBAs@Midnight, when Sean got a weird pop up message that said all his...
2015-02-07
1,130 reads
Enough Is Enough! Why Do We Have To Be At Risk?
Reading Time: 2 minutes
When Do We Say Enough Is Enough?
Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information...
2015-02-17 (first published: 2015-02-07)
7,933 reads
Timed SQL Server tracing
Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...
2015-02-07
255 reads
2015-02-06
206 reads
On Failure: Getting Up
In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...
2015-02-16 (first published: 2015-02-06)
5,959 reads
Friday Followup For February 6, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-02-06
419 reads
2015 - the year of upgrade
2015 should be a very busy year for most DBAs, due to the end of support of SQL server 2005...
2015-02-06
325 reads
SQL Server – Endpoint Authentication Error in AlwaysOn Availability Group Setup
According to MSDN: If the SQL Server service is running as a built-in account, such as Local System, Local Service,...
2015-02-06
640 reads
Enable SSDT and DacFx logging
**Update** I have noticed that these cmd files are missing from recent ssdt builds, to enable logging see Kevin's comment:
http://blogs.msdn.com/b/ssdt/archive/2014/07/15/sql-server-data-tools-ju…
**/update I was helping someone get a deployment filter working...
2015-02-05
18 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