Let’s Talk About Joins
T-SQL Tuesday #37 This month please join us in the TSQL blog party that happens on the second tuesday of the month. It is hosted this month by Sebastian Meine (@sqlity)....
2012-12-11
11 reads
Jason Brimhall
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few...
2012-12-04 (first published: 2012-11-30)
2,520 reads
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few flaws if trying to run it on a SQL...
2012-11-30
26 reads
Differential Restore Fail
We have all heard that backup is not complete until you test it by restoring it. We also know that part of a DR plan involves the testing of...
2012-11-28
12 reads
Differential Restore Fail
We have all heard that backup is not complete until you test it by restoring it. We also know that...
2012-11-28
1,530 reads
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012 Mickey Stuewe (sqlmickey) Neil Hambly (neil_hambly) Bob Hovious Gail Shaw (sqlinthewild) Ed Watson (SQLGator) ...
2012-11-21
11 reads
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012
Mickey Stuewe (sqlmickey)
Neil Hambly (neil_hambly)
Bob Hovious
Gail Shaw (sqlinthewild)
Ed Watson...
2012-11-21
1,443 reads
Last Known Good CheckDB
Diligent DBAs like to check their databases for a little thing called corruption. Some of those DBAs are masterful at keeping records and logging that the database was checked...
2012-11-20
18 reads
Last Known Good CheckDB
Diligent DBAs like to check their databases for a little thing called corruption. Some of those DBAs are masterful at...
2012-11-20
2,780 reads
T-SQL Tuesday #36 SQL Community
Community – What is it? Community is something that is improperly defined with words alone. Community is best defined through first person experience. Community is a feeling and a...
2012-11-13
13 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