Seeing Yourself as Others Do
As life skills go one of the hardest is to see yourself as others do – they apply all kinds of...
2011-10-25
868 reads
Blog Posts
SQL Server XQuery Against Execution Plans
One of the greatest things about all the DMOs is how you can combine the information they present to you...
2011-10-25
2,047 reads
The Basics of Joins – Skill #4
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-10-25
1,314 reads
Troubleshooting THREADPOOL Waits
Today I want to talk about a specified wait type that can be sometimes very hard to
troubleshoot: the THREADPOOL wait...
2011-10-25
12,614 reads
Tuesday Hardware Tidbits
There have been a few interesting developments on the hardware front over the past week that I want to cover...
2011-10-25
1,068 reads
ALTER SCHEMA
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server...
2011-10-24
1,873 reads
Brad or Spot?
Today we have another guest post from Steve Jones.
I’m no expert on animals, but I have a little experience out...
2011-10-24
620 reads
Deploying SSIS Packages with BIxPress
Same functionality but obvious differences
If you’ve worked with SSIS for any amount of time, you may quickly come to find...
2011-10-24
1,449 reads
GiveCamp Tampa 2011
This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by...
2011-10-24
1,030 reads
I Can’t Go To Space
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I...
2011-10-24
1,465 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