Upcoming Events Where We Can Chat
I get around quite a bit.
Next week I’ll be visiting three cities in Germany talking to user groups in Frankfurt,...
2015-03-09
665 reads
Blog Posts
Why You Shouldn’t Skip the Infrastructure/Security Architecture Review
It’s not usual for development projects to undergo an architecture review, but too many times these reviews consist only of...
2015-03-09
268 reads
Data Compression– a unique feature of SQL Server TIP #91
A part from performance many times we faced challenges related to space of our database. Sometimes our database is actually...
2015-03-08
655 reads
SQLBits, Incremental Statistics and Demo Fail
So another great SQLBits is done and dusted, many thanks to the team, helpers and sponsors for putting on such...
2015-03-08
491 reads
In-Memory OLTP & Deadlocking – my SQLBits sessions
After speaking at the SQLRally conference in Copenhagen earlier this week, my next stop was at the SQLBits conference in...
2015-03-07
595 reads
DevOps, the DBA, and the word “No”
Check out this DevOps Reactions animated GIF and caption.
It’s funny on multiple levels, but it also makes me both mad...
2015-03-06 (first published: 2015-02-24)
6,820 reads
Friday Followup For March 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-03-06
380 reads
Fun-fun-fun in the London sun (and Cardiff, and Exeter!)
We’re in London right now for SQLBits, which has been ABSOLUTELY LOVELY so far. If you happen to’ve seen our...
2015-03-06
447 reads
SQLRally and SQLBits Slides and Demos
It’s been a great a busy week.
On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally...
2015-03-06
607 reads
T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases
There are many different ways to accomplish this tasks.
Download Link https://gallery.technet.microsoft.com/T-SQL-How-to-Search-String-a1704fc6
The below examples uses undocumented sp’s to loop through all the...
2015-03-06 (first published: 2015-02-24)
6,999 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