My Favourite SSMS productivity tips
It’s a well known fact that any sitcom that runs for a certain length of time will release a clip...
2014-01-13
1,693 reads
What Tables Are Wasted?
Wasted space still seems to be on everyone's mind to some extent. I've wondered what tables do we use? We...
2014-01-13
549 reads
SQLSaturday #272 Nashville
SQLSaturday #272 Nashville here I come! Looking forward to having an opportunity to speak and network in Nashville. I am...
2014-01-11
362 reads
Question of the Week - 11/1/2014
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record...
2014-01-11
787 reads
Answer - Objective Question (In which database temporary tables are created in SQL Server)
Question :- In which database temporary tables are created in SQL Server?
1) User database (where temporary table are defined)
2) Master...
2014-01-11
1,683 reads
Who Owns SQL Backups?
I was asked by Idera to take a look at the things that could cost a DBA their job. This...
2014-01-10
1,066 reads
Applied SQL: Find and replace using regular expressions in SSMS
Regular expressions are searches on steroids, the wildcats of the wildcard world*. Even if you never ever write CLR, regex...
2014-01-10
1,249 reads
T-SQL – Monitoring DiskSpace of Multiple Servers
This post talks about step by step approach to capture the disk space using T-SQL. This is a request from...
2014-01-10
765 reads
The DBA That Practices Database Restores
We are often told that we need to practice our restores. And it might not be obvious, but the reason...
2014-01-10
433 reads
Reblog: January 3 to January 9
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-01-10
366 reads
Blogs
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 ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
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