Pro SQL Server 2012 Practices
Hello Dear Reader. Every now and then professionally you get to be a part of something really cool. Back in...
2013-01-15
816 reads
SSAS: One giant cube or many small ones?
When using SQL Server Analysis Services (SSAS) to build a cube, you may start out with one fact table, but...
2013-01-15
7,714 reads
New Year Aspirations – Chris Webb – SQLBits
SQLBits holds a special place for me as it was the first technical conference that I had ever been to....
2013-01-15
941 reads
Regression Testing before CUs and Service Packs
Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it...
2013-01-15
1,518 reads
Want to see me break SSIS this Thursday?
OK, I’m not really going to break it. I’m just going to beat it up a little bit.
This Thursday evening,...
2013-01-15
888 reads
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you’re infected; Database best practices protect your databases from...
2013-01-15
511 reads
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you're infected; Database best practices protect your databases from...
2013-01-15
566 reads
Exam 70-432 - SQL Server 2008 Implementation and Maintenance
For years, actually more like a decade, I've been saying that I'm going to get certified in SQL Server. Well...
2013-01-15
905 reads
Top 10 Free SQL Server Tools
What better way to kick off a new year than with a look back at some of the top free...
2013-01-15
12,995 reads
T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces and with some regulars. In total, we had 22...
2013-01-15
12 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