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
895 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,449 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,345 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,287 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,275 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
11 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,528 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,141 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
888 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,519 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers