Guest Appearance in DBA in Space
Win a trip into space!
The DBA in Space competition continues today with the third question. This time I get to...
2011-10-17
1,450 reads
PASS Summit 2011: Wrap-Up
Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the...
2011-10-17
1,444 reads
Scaling SQL Server
On Friday, October 14, 2011, I had the pleasure of delivering my new Scaling SQL Server presentation at the PASS...
2011-10-17
807 reads
Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,144 reads
SQL PASS Summit 2011: Session Files
SQL PASS Summit 2011: Session Files
PASS Summit 2011
This past week was the SQL PASS Summit 2011 in Seattle, WA. I...
2011-10-17
1,429 reads
Self Service BI and PowerPivot
Marco Russo and Alberto Ferrari have written a book called Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I finally...
2011-10-17
1,240 reads
Extended Events Data
I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...
2011-10-17
1,883 reads
SQL University Lesson 3 Page Compression
Lesson 2: Internal Structures, Vardecimal, & Row Compression
Welcome to Lesson 3 on Compression and welcome back Dear Reader. I want...
2011-10-17
1,101 reads
Understanding Kerberos, Part I
A get a lot of questions where I work about Kerberos and how it works for SQL Server, whether we're...
2011-10-17
4,376 reads
Simple XML exist performance enhancement
I came across this really simple best practice from BOL for the xml method exist which when used will give...
2011-10-17
1,986 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