Slide Deck for Introduction to Statistics
Here is the slide from the presentation today for the PASS Performance Tuning Virtual Chapter. Thanks to all those that...
2010-09-07
498 reads
Blog Posts
Tagxedo
I found this while looking for a quick way to throw some words into a slide, was thinking something along...
2010-09-07
599 reads
Unique and non-unique non-clustered indexes on a non-unique clustered index
In the last weblog post I have talked about the differences in unique and non-unique
non-clustered indexes on a unique clustered...
2010-09-07
4,117 reads
Upcoming Engagements
I haven’t been speaking a lot lately as I’ve been busy working, planning SQLSaturday #49 – Orlando, and planning PASS SQLRally,...
2010-09-07
482 reads
Virtual Labs - A Great Resource for SQL Server
I had someone send me a note recently asking some questions about how to get set up to work with...
2010-09-07
1,063 reads
What is Normalization in SQL ?
=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...
2010-09-07
303,381 reads
24 Hours of PASS coming over the next two days
Hey folks,
The 24 hours of PASS is coming very quickly.http://www.sqlpass.org/24hours/fall2010/. There are so many great sessions that I don’t know...
2010-09-06
519 reads
An impossible case
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
556 reads
Awards for SQL Heroism
Motivational time again!
Have you ever worked on a project where someone was seeking their moment in the sun for an...
2010-09-06
242 reads
Building your 1st Performance Point Dashboard in Sharepoint 2010
Hey there gang
The PASS BI Virtual Chapter is presenting some great stuff this fall. September 14th I’m doing a new session on...
2010-09-06
387 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
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