Day 15 of 31 Days of Disaster Recovery: Running DBCC CheckTable in Parallel Jobs
Welcome back to my 31 Days of Disaster Recovery series. Today is day 15, and I want to answer a...
2013-01-17
1,423 reads
MDX #24 – Leave out a dimension member using Except() Function
Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression
Many of the MDX functions, such as NonEmpty(),...
2013-01-17
17,103 reads
New Year Ambitions – Brent Ozar – Consulting
You are of course someone who needs little introduction in the SQL Server community. A prolific blogger, tweeter, speaker, Microsoft...
2013-01-16
1,885 reads
SSIS Top 10 Best Practices Basics
Best Practice is a difficult one... It generally depends on many factors. In my opinion SSIS Best practice is a...
2013-01-16
1,819 reads
You Can Say “No”
I heard about this new law that was passed to prevent employers from asking for your social media passwords. After...
2013-01-16
977 reads
SQL Server Auto grow
I had a great response to my blog post and poll last week about how DBAs use auto grow. In...
2013-01-16
1,037 reads
Chad Churchwell: Protect Your Replication Environment with AlwaysOn Availability Groups
Heads up everyone. Next Tuesday January 22nd, 2013 Chad Churchwell (blog | twitter) will be presenting a webinar on behalf of...
2013-01-16
1,113 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 3: Decision Trees
by Steve Bolton
This series of self-tutorials is an elementary-level introduction to SQL Server Data Mining (SSDM), not the product...
2013-01-16
2,950 reads
Day 14 of 31 Days of Disaster Recovery: Fixing a Corrupt Tempdb
Welcome to day 14 of my 31 Days of Disaster Recovery series. I’ve previously discussed handling corruption for nonclustered indexes...
2013-01-16
2,239 reads
Join me at SQLBits for a day of SSIS
I’m happy to announce that I’ve been selected to deliver a full day of training at the upcoming SQLBits conference...
2013-01-15
745 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