SQL Server

SQL Server Community

SQL Server Blogs

Follow /2 Mar 2015 at 11:51pm / SQL Server

Why do We Have to Be at Risk? Enough is Enough!

When Do We Say Enough Is Enough? Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information of up to 80 million customer was stolen. It wasn’t anything about medical history taken, just all their customer’s...
66 0 /
Kevin Kline
Follow /2 Mar 2015 at 3:05pm / SQL Server

ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance

Don’t miss these great articles on SQLPerformance.com from the industry’s top experts: A Look At DBCC CHECKCONSTRAINTS and I/O Erin Stellato ( b | t ) of SQLskills takes a deep look into the SQL Server performance impact, especially I/O, of...
68 0 /
Richard Douglas
Follow /2 Mar 2015 at 2:57pm / SQL Server

SQLBits XIV – Welcome to the UK

A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was something just for people from the UK has been transforming into something much larger, more multicultural and more engaging as the community...
71 0 /
Kenneth Fisher
Follow /2 Mar 2015 at 1:00pm / SQL Server

SQL Judo’s Monthly Challenge – March 2014 – Powershell something

Every month SQL Judo (Russ Thomas) ( b / t ) challenges us to do his Monthly DBA Challenge . I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For example...
83 0 /
Melissa Coates
Follow /1 Mar 2015 at 5:11pm / SQL Server

What You Need to Set Up the SSAS Connector in the Power BI Preview

Welcome to part 2 of a 3-part series on using the SSAS Connector with the new Power BI Preview. This information is as of early March 2015 and is subject to change as the Power BI Preview evolves. Part I: Overview of Using Analysis Services Data in the...
89 0 /
Ed Elliott
Follow /1 Mar 2015 at 12:07am / SQL Server

Introducing MergeUI

What is it? MergeUi is a addin (VSPackage) for Visual Studio / Sql Server Data Tools projects. It is a ui to create and edit T-Sql merge statements in pre and post deployment scripts. In this screen shot you can see the merg statement that is generated...
38 0 /
Chris Yates
Follow /27 Feb 2015 at 6:28pm / SQL Server

Impact Series – Part 2

It’s that time again to add another impact player to the roster; this time for the month of February. This month the nod goes to none other than Jason Strate ( Blog | Twitter ). A few years back I sat in on one of Jason’s sessions at PASS Summit...
55 0 /
Tracy McKibben
Follow /27 Feb 2015 at 1:00pm / SQL Server

Friday Followup For February 27, 2015

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 Building (for FREE) a Virtual Server for SQL Demos...
112 0 /
Follow /26 Feb 2015 at 9:15pm / SQL Server

Gimme A Break! Taking Mental Health Days

Reading Time: 3 minutes Do you feel like this when you get to work?   Burnout! You have been stressing over the big project you have to get done. You get in early Monday morning, pour yourself a mug of coffee and stumble to your desk. You start...
54 0 /
Larry Leonard
Follow /26 Feb 2015 at 9:15pm / SQL Server

Adding a User to Multiple Databases

Everyone seems to have their own version. Mine is as simple as I could make it. Make sure you create the LOGIN first, and set the @User variable in the code below. Assumes you have already created a login named @User . set nocount on declare @User sysname...
71 0 /
James Serra
Follow /26 Feb 2015 at 4:19pm / SQL Server

Operational Data Store (ODS) Defined

I see a lot of confusion on what exactly is an Operational Data Store (ODS).  While it can mean different things to different people, I’ll explain what I see as the most common definition.  First let me mention that an ODS is not a data warehouse...
174 0 /
Michael J. Swart
Follow /26 Feb 2015 at 3:06pm / SQL Server

When Parameter Sniffing Caused Deadlocks

Last week I was asked to troubleshoot some deadlocks in production. I was surprised to find out that parameter sniffing was one of the causes. I describe the investigation below. Parameter Sniffing SQL Server does this neat trick when you give it...
121 0 /
Colleen Morrow
Follow /26 Feb 2015 at 3:00pm / SQL Server

Exam Prep 70-463: SSIS Expressions

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 Dimensions and Slowly...
75 0 /
Bob Pusateri
Follow /26 Feb 2015 at 2:09pm / SQL Server

Signed Integer Ranges: Why and How

Whether you are working in T-SQL , Oracle , MySQL , C# , or Java , the range of possible values for a signed  (positive or negative) 32-bit integer is from or (-2,147,483,648) to or (2,147,483,647). The fact that it’s so consistent across so many...
47 0 /
Chris Webb
Follow /26 Feb 2015 at 12:37pm / SQL Server

Handling Added Or Missing Columns In Power Query

A recent conversation in the comments of this blog post brought up the subject of how to handle columns that have either been removed from or added to a data source in Power Query. Anyone who has worked with csv files knows that they have a nasty habit...
60 0 /