Give Your Valentine Some Discounted Indexing
Looking for that special gift for Valentine’s day and wanting to really change things up? How about getting your loved...
2013-02-13
566 reads
SQL Server Naming Standards
Want to start a fight between a bunch of DBAs or database developers? Ask them where the comma should be...
2013-02-18 (first published: 2013-02-13)
3,560 reads
A Month of PowerShell – Day 13 (Databases: Adding Schemas, Tables and Indexes)
Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-20 (first published: 2013-02-13)
2,964 reads
Become an expert in SQL Server Performance Tuning & Troubleshooting!
Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server...
2013-02-13
818 reads
Become an expert in SQL Server Performance Tuning & Troubleshooting!
Since September 2012 I'm a Microsoft Certified Master SQL Server 2008,
which is the highest technical certification for SQL Server that...
2013-02-13
1,047 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides
Thanks to everyone who attended my presentation “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group...
2013-02-13
1,906 reads
Speaking at PASS Virtualization Virtual Chapter on Wednesday
This Wednesday I will be presenting for the PASS Virtualization Virtual Chapter at 11AM CST on one of my favorite...
2013-02-13
675 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 7: Clustering
by Steve Bolton
In last week’s installment of this amateur series of self-tutorials on SQL Server Data Mining (SSDM), we...
2013-02-19 (first published: 2013-02-12)
3,303 reads
T-SQL Tuesday #39 - Use PowerShell To Copy A Database To Another Instance
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-02-12
2,039 reads
#CISPA’s Coming Back: Time to Pay Attention Again
Update: The President’s cybersecurity Executive Order was signed and released today (see the Wired article). “Although the order comes after...
2013-02-12
864 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