Reblog: November 23 to November 29
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-11-30
1,488 reads
Power View for Multidimensional Models – Preview Available
Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View can only consume data...
2012-11-30
2,387 reads
Sharing the Love
Just a few blog posts that you ought to go and read.
First up, Tom LaRock maintains a listing of SQL...
2012-11-30
1,689 reads
Rules of Holes #7: Some Will Look Down on You.
I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and...
2012-11-30
1,534 reads
Tables without a Primary Key
As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script...
2012-12-06 (first published: 2012-11-30)
5,224 reads
SQL Saturday in Washington D.C. December 8, 2012
This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near...
2012-11-30
1,222 reads
New Book: Knight’s SSIS 2012 24-Hour Trainer
I’m very excited to announce that you can now purchase my latest release book:Knight’s Microsoft SQL Server 2012 Integration Services...
2012-11-30
3,331 reads
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few flaws if trying to run it on a SQL...
2012-11-30
26 reads
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few...
2012-12-04 (first published: 2012-11-30)
2,520 reads
Lost in Translation – Deprecated System Tables – sysservers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-29
2,447 reads
Blogs
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...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
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