SQL Server 2012 Diagnostic Information Queries (Jan 2013)
Here is the January 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-01-12
908 reads
SQL Server Consulting: Weekly Round-up
The first full week in 2013 has been a a busy week for me with lots of SQL Server consulting...
2013-01-12
1,004 reads
Day 11 of 31 Days of Disaster: Converting LSN Formats
31 Days of Disaster Recovery
Welcome back to my series 31 Days of Disaster Recovery. Today is day 11, and...
2013-01-12
4,003 reads
Scaling out SQLLunch UK
As you may be aware, I have been running a lunch time user group ‘SQLLunch UK’ having stolen drawn inspiration...
2013-01-11
667 reads
Six Degrees of SQL Saturday Fargo
Do you know anyone that lives in or around the great white north that is Fargo, North Dakota? If so,...
2013-01-11
682 reads
Reblog: January 5 to January 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-11
5,269 reads
SQL Server 2012 with SP1 Installation Step by Step Guide - Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O' Misery
Since the last guide was quite popular (over 4k distinct views for SQL Server 2008 R2), I've uploaded to SkyDrive...
2013-01-11
19,282 reads
Under which user your SQL Agent Job run : SQL Agent Service Account or SQL Agent Job Owner ?
Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account...
2013-01-11
4,200 reads
#SQLSaturdayExeter–Superb SQL Server Event
#SQLSaturday194 is coming to Exeter on the 8th – 9th March.
What is SQL Saturday? The brain child of Steve Jones,...
2013-01-11
762 reads
Rename the SQL Server Management Studio shortcut
Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...
2013-01-11
7,799 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