SQL Server 2008 and R2 Diagnostic Information Queries
It has been a couple of months since I have posted an update to my “SQL Server 2008 and R2...
2010-08-16
1,705 reads
Forgetful Fred and SQL Server Management Studio
Scott Gleason just posted a blog yesterday that showed an awesome new tool that people can create little animated videos....
2010-08-15
380 reads
Summer Update
I haven’t posted on my SQL Server blog for a few weeks, I missed the August T-SQL Tuesday which I’m...
2010-08-14
527 reads
Free SQL Server Training for the Week of August 16, 2010
Have you registered for the 24 Hours of PASS (September 15-16) yet?
Tuesday
SQL Lunch - Policy Based Management in a Nushell - Jorge...
2010-08-14
840 reads
Saved By a Spare
I started traveling with two laptops after I had a laptop fail during a trip in 2009 the day of...
2010-08-14
755 reads
SQL Server 2008 SP1 Too Old for Replication?
SQL Server 2008 SP1 To Old for Replication?
We are in the middle of a platform upgrade project at work, and...
2010-08-13
1,809 reads
SCSUG PowerShell ETL Presentation
My thanks to everyone at the Space Coast SQL Server User Group for inviting me to speak. Feel free to post questions...
2010-08-13
776 reads
The Value of Blogging – Today on SQLServerCentral
I wrote the value of blogging hoping to highlight the less often discussed value of practicing writing. Too often we...
2010-08-13
583 reads
Transferring Logins to a Database Mirror
Transferring Logins to a Database Mirror
I recently discovered that my book (Pro SQL Server 2008 Mirroring) has an older version...
2010-08-13
3,838 reads
Tip: Change Multiple Field Formats in SSRS
One of the things about SSRS that irritates me is that in the graphical editor, you have to set the...
2010-08-13
1,995 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