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,648 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,074 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
681 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,235 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers