Great News! SSMS Tools Pack 1.9 is Coming Out!
Mladen Prajdic recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Continue reading ?
2010-08-20
17 reads
Great News! SSMS Tools Pack 1.9 is Coming Out!
Mladen Prajdic (Blog|Twitter) recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Why...
2010-08-20
540 reads
A Lesson from My Air Force Days
Yup, you guessed it, another post about the nominations for the PASS Board of Directors. If you're tired of reading...
2010-08-19
1,009 reads
Hunting down those expensive SPs
A query to find out which Stored Procedures are taking the longest to run ( in this example – the Top 10).
I’m sure there are...
2010-08-19
696 reads
Undocumented Stored Procedures
Just a quick list of undocumented SPs, many of which are deprecated.
Note, use caution using some of these ! But others...
2010-08-19
2,156 reads
Neat script to monitor activity
Scouring the web this week, I stumbled across SQL Server MVP Adam Mechanics and his script :-
Who is Active?
Its basically a...
2010-08-19
528 reads
It’s the Process
Unless you’ve spent the last two days hiding under a rock, you’ve heard the uproar around this week’s development in...
2010-08-19
791 reads
Thoughts On The 2010 PASS BoD Elections Candidate List
Yesterday PASS published the list of candidates on the ballot for the 2010 Board of Directors election. Much to my...
2010-08-19
613 reads
Making Presentations With My iPad
I recently gave a couple of talks at devLINK 2010 at the David Lipscomb University campus in Nashville.
One of the...
2010-08-19
1,900 reads
Unique/Non-Unique Clustered Indexes
In the last blog post I have talked about unique/non-unique clustered indexes on a heap
table. A table without a clustered...
2010-08-19
8,219 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