SQL Server

SQL Server Community

SQL Server Blogs

Tom LaRock
Follow /26 Aug 2014 at 9:18pm / SQL Server

The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)

Just a quick post today to tell you about a webinar I am doing on the 27th of August, 2014. The title is “The Real SQL Server 2014 Power Feature (It May Not Be Hekaton)”, and it is me talking about the new cardinality estimator (CE) in SQL...
33 0 /
David Dye
Follow /26 Aug 2014 at 2:12pm / SQL Server

SSIS Advanced Techniques Workshop

I recently completed a set of videos for SSWUG that covers some advanced techniques for SQL Server Integration Services. 1. SSIS – Creating dynamic packages 2. SSIS – Error handling and troubleshooting 3. SSIS – Deployment models 4...
22 0 /
Arthur Olcot
Follow /26 Aug 2014 at 11:31am / SQL Server

Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server. As it stands the documentation clearly states...
26 0 /
Rohit Garg
Follow /26 Aug 2014 at 10:26am / SQL Server

Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !

The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe...
28 0 /
Follow /26 Aug 2014 at 2:22am / SQL Server

Interview with Boris Hristov of borishristov.com

Recently I had the opportunity to conduct a short interview with Boris Hristov.   I think you find this interview interesting as Boris reveals how he became a DBA and ultimately awarded a MVP designation. 1.  Many of my readers are just beginning...
39 0 /
David Dye
Follow /25 Aug 2014 at 6:32pm / SQL Server

Orlando Live 360 November 17-21!!

SQL 360 Live Countdown to Live 360!! Live 360 will be held Novemeber 17-21 at Universal Studios Royal Pacific Resort. Registration is open and you can register here to receive a $600 discount code. I hope to see you all there!
36 0 /
David Dye
Follow /25 Aug 2014 at 4:36pm / SQL Server

Automate Database Restore

On several occasions I have been required to restore a database from production to development or test. The requirements are that I must restore 1. The most recent full back up 2. The most recent differential backup 3. All transaction logs...
43 0 /
Rohit Garg
Follow /25 Aug 2014 at 2:23pm / SQL Server

How to kill a negative SPID (like SPID -2 or -3) in SQL Server?

Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all the user sessions & stop the application but still we are facing this issue. Further going...
38 0 /
Kenneth Fisher
Follow /25 Aug 2014 at 1:00pm / SQL Server

The amazing never shrinking heap

This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However until recently I could never duplicate it on purpose. (You can read that as I’ve had a production problem bite me in the …...
42 0 /
Tracy McKibben
Follow /25 Aug 2014 at 1:00pm / SQL Server

Automated Source Control: A Librarian For Your Database Objects, Part 2

I assume that by now you’ve tried the script from Part 1 , and have seen how easy it is to script out your database objects using Powershell.  The resulting scripts are the standard DDL scripts that you can generate from Management Studio, and for...
35 0 /
Chris Webb
Follow /24 Aug 2014 at 10:09pm / SQL Server

Power Query Functions That Return Functions

You’re probably aware that, in Power Query, a query can return a function. So for example here’s a very simple query (so simple that no let statement is needed) called MultiplyTwoNumbers with the following definition: (x as number, y as...
51 0 /
Melissa Coates
Follow /24 Aug 2014 at 4:06pm / SQL Server

Resolving Errors from Deployment of Database to Azure SQL DB

This week our team at BlueGranite decided that the sample relational database called ContosoRetailDW would be best located for our demo & training purposes in Azure as a SQL Database. Below are the steps taken to get this sample database in a state...
58 0 /
Mike Walsh
Follow /22 Aug 2014 at 8:13pm / SQL Server

DBA Tunnel Vision

One of the things hammered into you in Firefighting training, Law Enforcement training, defensive gun use training and many other forms of training is “ Do not develop tunnel vision .” There is a reason they emphasize this concept so much...
74 0 /
Jason Strate
Follow /22 Aug 2014 at 5:00pm / SQL Server

Reblog: August 15 to August 21

Photo credit – Mike Lynch A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time...
59 0 /
Pradeep Adiga
Follow /22 Aug 2014 at 2:35pm / SQL Server

How to extract the contents of .MSP files

I had encountered an issue while installing a SQL Server service pack. The resolution for it was to replace the existing SQL Server binaries from that of a Service Pack. To extract the contents of a Service Pack executable we need to just type “ServicePackExeName...
63 0 /