SQL Server

SQL Server Community

SQL Server Blogs

Jason Strate
Follow /21 Nov 2014 at 4:00pm / SQL Server

Reblog: November 14 to November 20

Photo credit – JStove Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no...
54 0 /
WaterOx
Follow /21 Nov 2014 at 3:00pm / SQL Server

Have We Devalued SQL Server Consulting?

Have we given too much away? SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s. Has the value of SQL Server Consulting Diminished...
65 0 /
Tracy McKibben
Follow /21 Nov 2014 at 1:00pm / SQL Server

Friday Followup For November 21, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Using Encryption To Protect Your Data From Alien...
94 0 /
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...
46 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...
135 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...
98 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...
101 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...
44 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...
72 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...
39 0 /
SQLDBAWithABeard
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...
61 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...
3708 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...
56 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...
28 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...
171 0 /