SQLSaturdays
Can you believe that I have never attended a SQLSaturday (http://www.sqlsaturday.com)? Well, that is changing very soon. You will see me at...
2010-09-08
841 reads
Blog Posts
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to...
2010-09-08
1,738 reads
Tuning Tip: Identifying Overlapping Statistics
Statistics are used by SQL Server's query optimizer to help determine the most efficient execution plan for a query. When...
2010-09-08
2,105 reads
At The End of the IO Road With C#
Previously I’ve written about doing fun IO stuff in C#. I found out that some of my old tricks still...
2010-09-07
1,883 reads
Auto Close – SQL Server
I ran into an issue recently where I had a third party supplied database set to auto close. I couldn't...
2010-09-07
3,001 reads
Book Review: Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the United States
Another choice brought about by wandering the local library, Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the...
2010-09-07
596 reads
Links From Twitter
Normally, I try to stick to posting technical info or community stuff on the blog, but there were a couple...
2010-09-07
573 reads
More Notes on Live Meeting Presentations
Yesterday I did another presentation via Live Meeting, some thoughts from that effort:
Perf VC team did a great job making...
2010-09-07
435 reads
Please don’t Tweet this, but…
This is reprinted from my editorial in Database Weekly.
During some recent conversations, I’ve noticed an increasing tendency for people to...
2010-09-07
556 reads
Reminder: Introduction to Statistics Presentation Today at Noon
I’ll be doing a presentation titled Introduction to Statistics in SQL Server today (Sep 7, 2010) at noon for the...
2010-09-07
226 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
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...
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