SQL Server

SQL Server Community

SQL Server Blogs

Follow /24 Nov 2014 at 1:00pm / SQL Server

How Do I combine results from more than one table?

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide  Getting Started Using SQL Server . What are the ways I can combine...
7 0 /
Kenneth Fisher
Follow /24 Nov 2014 at 1:00pm / SQL Server

Putting sp_ at the beginning of your stored procedure.

Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So what does that do and why should we care? The primary effect is that if you put a stored procedure starting with sp_ in master you can call it...
8 0 /
Follow /24 Nov 2014 at 10:43am / SQL Server

A look at the SQL Assessment Intelligence Pack in Operational Insights

Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data in one place. It can collect data from all of your machines either via SCOM or by using an agent...
17 0 /
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...
91 0 /
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...
111 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...
122 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...
65 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...
152 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...
129 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...
116 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...
58 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...
91 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...
54 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...
75 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...
5628 0 /