Cumulative Update – 11 for SQL Server 2008 R2 Service Pack 1 Is Now Available !
The 11thcumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the Microsoft...
2013-02-19
1,005 reads
Calculate Bitmasks In PowerShell
Have you ever had to calculate bitmasks on the fly? I have and still do. In this post, I’m going to show...
2013-02-19
1,690 reads
Using Team Foundation Service
Team Foundation Service (TFS) is the “cloud” version of Team Foundation Server 2012. Up to 5 users are free, plus for a...
2013-02-19
1,291 reads
A Month of PowerShell – Day 19 (Databases: Scalar Functions)
Welcome to Day 19 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-19
699 reads
Keep VMware snapshot growth from wrecking your day
VM snapshots are the best individualization feature since sliced vBread (yeah, I’m a geek). But…have you ever had a VMware snapshot grow...
2013-02-19
1,071 reads
Multitasking A Ridiculous Workload – How I Do It
I don’t! There’s no such thing as multitasking. At least, not how most of us think about it……
Being successful as...
2013-02-19
964 reads
The Performance Impact to Prefix Stored Procedures with sp_
Last week I ran across a blog post by Axel Achten (B|T) that outlined a few reasons why you should...
2013-02-19
1,468 reads
SQL Server – Finding out Database creation time
Finding database creation time is simple if database has not been detached from server. You can find database creation time...
2013-02-19
777 reads
SQL Saturday #198, Vancouver, BC Session Files
This past weekend was SQL Saturday #198 in Vancouver, B.C. It started off with a leisurely drive up to Vancouver...
2013-02-19
1,255 reads
Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works
Ever have your SQL Server slow down for reasons that you can’t explain? Or did you spend all night tuning...
2013-02-18
578 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers