SQL Server

SQL Server Community

SQL Server Blogs

Colleen Morrow
Follow /20 Nov 2014 at 3:00pm / SQL Server

Exam Prep 70-463: More about Dimensions

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Today we’re...
23 0 /
Chris Webb
Follow /20 Nov 2014 at 12:51pm / SQL Server

Combining Data From Multiple Excel Workbooks With Power Query–The Easy Way!

If there’s one feature of Power Query that’s guaranteed to get Excel users very, very excited indeed it’s the ability to combine data from multiple workbooks into a single table. The bad news is that this is something that Power Query can’t do through...
46 0 /
James Serra
Follow /19 Nov 2014 at 3:00pm / SQL Server

Fast Track Data Warehouse Reference Architecture for SQL Server 2014

I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see  Microsoft SQL Server Reference Architecture and Appliances ).  That was version 3.0 of the reference configuration that was for...
86 0 /
Derik Hammer
Follow /19 Nov 2014 at 2:00pm / SQL Server

How to change the schema of a table

The other day I set out to performance tune a database deployment. The company was getting ready to implement almost a year’s worth of database schema drift where major restructuring had occurred. One of the first things that I noticed was that...
89 0 /
Kenneth Fisher
Follow /19 Nov 2014 at 1:00pm / SQL Server

You don’t really need ORDER BY do you?

You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject. You all know I love examples so without further ado here we go: Using data from...
36 0 /
Dinesh Asanka
Follow /19 Nov 2014 at 10:48am / SQL Server

Improved Online Operations in SQL Server 2014

Online indexing rebuilding was a major breakthrough from SQL Server to support users re-indexing while the clustered index (or table) and other indexes are available during the index rebuild operation. However, in real world there are multiple issues...
47 0 /
Chris Webb
Follow /19 Nov 2014 at 10:47am / SQL Server

Returning Error Messages As Well As Results In Power Query

Back in September I wrote a post on handling situations where the data source for your Power Query query was unavailable. The great thing about that technique is that instead of seeing an error message when you refresh your query, instead you get an empty...
34 0 /
Follow /18 Nov 2014 at 6:50pm / SQL Server

Changing Delay Between Responses for SQL Alerts with Powershell

So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received the Blitz Result: No SQL Server Agent Alerts Configured and like a good and conscientious DBA you...
54 0 /
Kendal Van Dyke
Follow /17 Nov 2014 at 7:06pm / SQL Server

2014 PASS Summit 2014 Board Q&A Notes

As has occurred in previous years at the PASS Summit the PASS Board of Directors held an open Q&A session on the final day. I was able to attend most of the session but had to leave a few minutes early for my scheduled presentation. I didn't count...
2537 0 /
Tracy McKibben
Follow /17 Nov 2014 at 6:44pm / SQL Server

Vital Statistics and Health Checks

This post has nothing, absolutely nothing, to do with SQL Server. It does, however, relate to your career as a deskbound, stressed-out IT professional. With that disclaimer out of the way, you may continue reading if you’d like. A couple of things...
50 0 /
Jason Strate
Follow /17 Nov 2014 at 4:00pm / SQL Server

Last Weeks Top “Reading” Links #109

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” ( so exciting ), follow me on  twitter  ( @StrateSQL ).  And see these throughout the day as I tweet out links of things I find interesting...
22 0 /
Colleen Morrow
Follow /17 Nov 2014 at 3:00pm / SQL Server

Exam Prep 70-463: Tables and Schemas

Well, the PASS Summit has come and gone and it was *awesome*.  What a difference from my first Summit experience, when I went to every session I could and then went back to the hotel.  This time around there was something going on every evening and I...
162 0 /
Bob Pusateri
Follow /17 Nov 2014 at 1:51pm / SQL Server

What Are You Thankful For?

It’s almost Thanksgiving time here in the United States – that wonderful holiday where families and friends gather to share a meal and give thanks for all our many immaterial blessings. (And then for maximum irony, we head out the following...
93 0 /
Kenneth Fisher
Follow /17 Nov 2014 at 1:00pm / SQL Server

Using T-SQL to populate a CMS

We have been using a CMS at my office for the last few years. Even beyond the uses for managing multiple servers (PBM etc) we use it primarily as a shared list of registered servers. Given that our current list is a bit over 150 instances we have found...
51 0 /
Chris Webb
Follow /17 Nov 2014 at 12:06pm / SQL Server

Timing Power Query Queries

If you’re interested in performance-tuning a Power Query query, you’re going to need a reliable way of telling how long your query takes to run. It’s not as easy as it seems to adapt your query to do this though, and that’s because of the way the M formula...
46 0 /