Creating SQL Server 2008 Databases with T-SQL
Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file...
2010-03-24
1,403 reads
PASS Update #27
I’m just back from the March 2010 Board meeting and it went better than usual (for any meeting). Most of...
2010-03-24
595 reads
Getting Stubborn Chief Executive Officers to Listen: Speak Their Language
After consecrating several posts on workplace bullying, and hearing our great Steve Jones rant about Toshiba’s lack of action regarding...
2010-03-24
1,966 reads
Avoiding Plagiarism
Having gone to an academic magnet school, I have quite a few friends who are teaching at the university level...
2010-03-24
1,918 reads
Adding a Column to Every Table
I am Script. I will update your database.
Despite the best laid plans, sometimes circumstances or project scope change and the...
2010-03-24
672 reads
A Personal Story about Networking
This is not a technical or SQL Server post, but it does illustrate the power of networking.
We recently took my...
2010-03-24
514 reads
SQL Server 2008 R2 - The list of the supported features
The MSDN - Microsoft, has collected too much info about features supported by the SQL Server 2008 R2, for all editions...
2010-03-24
1,244 reads
Why I Don’t Run for the PASS Board
It’s getting close to that time of year when you can apply to run for the PASS Board of Directors....
2010-03-24
1,650 reads
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-23
1,335 reads
SQL Saturday #39 New York
New York, New York, it’s a hell of a town. The Bronx is up and the Battery’s down. The people...
2010-03-23
554 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