Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-24
1,670 reads
It's the Procedure...
After going through all the materials provided to the NomCom for the PASS Board of Directors, I think I can...
2010-08-24
1,427 reads
Twitter: The Next Best Thing To Being There
Why do DBAs want to go to PASS, TechEd, or SQLConnections? If asked, I suppose that many would point to...
2010-08-24
741 reads
Use ReadOnlyVariables and ReadWriteVariables properties in Scripts
For those of you just starting out with SQL Server Integration Services, you'll find a LOT of information out there...
2010-08-24
6,652 reads
Audio Proofreading & Writing Quality
Funny how if take time for longer conversations, ones that ramble, you often learn interesting things that you just wouldn’t...
2010-08-24
1,075 reads
SQL Server 2008 R2 Diagnostic Queries from SQL Saturday #51 Nashville
Here are the diagnostic queries that I ran during my presentation at SQL Saturday #51 in Nashville on August 21,...
2010-08-24
1,207 reads
DMV Emergency Queries From SQL Saturday #51 in Nashville
I wanted to post the first T-SQL script from my DMV Emergency Room presentation on August 21 in Nashville. This...
2010-08-23
1,723 reads
Estimating Data Compression Savings in SQL Server 2008 and 2008 R2
Since I finished upgrading the last of my Production environment to SQL Server 2008 R2 running on Windows Server 2008...
2010-08-23
3,123 reads
SQL Server Trivia
Think you know SQL Server past and present? Here are the next-to-impossible questions I asked at the SQLSaturday #51 Stump...
2010-08-23
682 reads
N Things Worth Knowing About SELECT
SELECT is this kind of Swiss Army Knife
SELECT is our bedrock, our foundation, our now-and-forever T-SQL multitasker…and it’s one of the...
2010-08-23
1,237 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers