The PASS Summit is HERE!
Watching the twitter sphere it is apparent that many of the SQL Nation are in route to Seattle WA today....
2011-10-10
471 reads
PASS 2011 Countdown – Starting Now
Seriously, the clock is ticking and you should be in your car or a plane for PASS Summit by now. ...
2011-10-09
739 reads
An Informal Compendium of SSAS Errors, Part 4: SSAS Object Design
This is the third in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-08
2,214 reads
DBCC checktable
Instead of using DBCC CHECKDB , which checks on consistency and allocation across the whole database, an alternative is DBCC CHECKTABLE...
2011-10-08
2,715 reads
#SQLGive Update - New Dropoff Locations
Since announcing #SQLGive earlier this week I'm happy to report that two additional vendors have agreed to host dropoff boxes...
2011-10-07
856 reads
Lyrics for “SQL and I Know It”
I hadn’t planned to post the lyrics for yesterday’s song, but Mark Vaillancourt (Blog | @markvsql) thought that I should. Since he’s...
2011-10-07
589 reads
My PASS Summit 2011 Schedule
The annual PASS Summit is upon us once again! Here's where I'll be next week:
Monday
Arriving in Seattle mid-afternoonMonday Night Networking...
2011-10-07
684 reads
Denormalizing dimension tables
When building a SSAS cube, you typically have a star schema containing dimension tables and fact tables. For dimension tables,...
2011-10-07
2,254 reads
The Khan Academy
It’s completely unrelated to work, though there is a computer science section.
I can’t take credit for this, that goes to...
2011-10-07
2,225 reads
SQL Server – SQL Server 2008 Service Pack 3 RTM Released
Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server...
2011-10-07
882 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