HDInsight: First Pass
I installed HDInsight with no errors. The install is so brain-dead, I couldn’t see how there could be errors. But,...
2012-11-28
897 reads
The Last DBCC CHECKDB Date and Restores
I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For...
2012-11-28
3,451 reads
Lost in Translation – Deprecated System Tables – sysreferences
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-28
1,347 reads
New Toy: The Brydge iPad Keyboard – Updated
Finally a REAL keyboard for my iPad!
I can’t tell you how long I’ve wanted a real keyboard that my iPad...
2012-11-28
1,288 reads
WIT Wednesday
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-11-28
1,276 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
A Rickety Stairway to SQL Server Data Mining, Part 0.1: Data In, Data Out
In the first of a series of amateur tutorials on SQL Server Data Mining (SSDM), I promised to pull off...
2012-11-28
7,145 reads
should I use clustering on a VM?
ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
If you want prescriptive...
2012-11-28
890 reads
One Interview question. Many Answers
Conducting technical interview is an art.
Most likely I would start a discussion with simple questions like "What is your favourite topic in SQL...
2012-11-27
3,525 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