The Blocked Process Report
A few days ago, one of my customers asked if there is a possibility to get a notification
from SQL Server...
2011-12-01
5,605 reads
SQL Saturday 99 – Digineer Interview
Welcome to the second of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-01
774 reads
PASS Update #67
It’s been a slow few weeks since my last update. This week I did a call with Karla and Wes...
2011-12-01
433 reads
SQL Server 2012 – Bug in sys.fn_xe_file_target_read_file?
So I finally managed to get my hands on a VM with Windows 2008 R2 SP1 so I could install...
2011-12-01
1,149 reads
PASS Update #67 (Election)
Today the slate of candidates for the 2012-2013 term was announced;
Adam Jorgensen, Denise McInerney, Geoff Hiten, Kendal Van Dyke,...
2011-12-01
644 reads
DBA in Space: Behind the Scenes—Question 9
This is a continuation of my DBA in Space journal.
Episode nine was filmed in the “Mars” exhibit. In this scene,...
2011-12-01
631 reads
December Question: When reflecting on this year, what has gone well, and what would you do differently?
December is the last month of the year, and is often a good time to reflect on the past year...
2011-12-01
1,180 reads
Speaking in Colorado Springs
I’m probably going to have to put together a new SQL video, because I’ve been accepted to speak at SQL...
2011-12-01
566 reads
SQL Table variable and temporary table
Table variables and Temporary tables are used interchangeably – but they were designed for different purposes.
Temporary tables were designed for storage...
2011-12-01
1,761 reads
The process could not read file due to OS error 3
When configuring a subscription to a publication in SQL Server, on initialization it is common to encounter the error:
The process...
2011-11-30
43,315 reads
Blogs
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...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
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