SQL Server

SQL Server Community

SQL Server Blogs

Mike Walsh
Follow /29 Sep 2014 at 12:57pm / SQL Server

DBA Reminders from an FAA Fire

Last Friday a long time employee set fire to the FAA’s Chicago Control Center. You can read about the fire and the 2,000+ flight cancellations that resulted   here  and  here . Keeping with the spirit of ripping lessons from headlines like I did...
33 0 /
Kenneth Fisher
Follow /29 Sep 2014 at 12:00pm / SQL Server

Database default locations

One of the options you had when installing your instance was setting some default file locations. Defaut data file location Default log file location Default backup file location If you are new to installing SQL Server (and even if you aren’t...
34 0 /
Rohit Garg
Follow /29 Sep 2014 at 9:44am / SQL Server

SQL Server 2008 R2 Service Pack 3 Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008 R2 Service Pack 3 contains all the hotfixes released since the initial release...
35 0 /
Rohit Garg
Follow /29 Sep 2014 at 9:38am / SQL Server

SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be

Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I perform to resolve the issue, Seems to be a WMI error :- 1) If using Window Server 2008 &...
29 0 /
Chris Webb
Follow /29 Sep 2014 at 8:30am / SQL Server

Advanced Options For Loading Data From SQL Server With Power Query

Loading data from SQL Server using Power Query is fairly straightforward, and the basics are well-documented (see here for example). However there are a few advanced options, not all of which are currently shown in the online help although they are in...
39 0 /
Jen Stirrup
Follow /28 Sep 2014 at 11:08pm / SQL Server

Jen's Diary: Figuring it out - Virtual Chapter Pathways

Ok. Here goes. Disclaimer: I don't speak on behalf of PASS, only the Exec Committee can do that. I want to thank everyone, just from myself, for all their patience and support for the past week. You know who you all are, and I wanted to say thank...
30 0 /
Mike Walsh
Follow /27 Sep 2014 at 3:03am / SQL Server

Slow Down and Communicate!

Earlier this week I ripped a headline for blog post inspiration. Looks like the week will end that way, too. Before you ask – this isn’t about the PASS organizational struggles – though I think it applies there – and looking...
46 0 /
Jason Strate
Follow /26 Sep 2014 at 5:00pm / SQL Server

Reblog: September 19 to September 25

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...
44 0 /
Tracy McKibben
Follow /26 Sep 2014 at 1:00pm / SQL Server

Friday Followup For September 26, 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 Don’t Get Slimed By Bad Parameter Sniffing...
137 0 /
David Dye
Follow /26 Sep 2014 at 4:30am / SQL Server

Using SSIS To Get Data From a Web Service

The sample package outlined can be downloaded here . SSIS has a web service control flow task that allows you to call a web service and store the results.  This can be very useful if you need to call data from a web service that will be stored in an...
45 0 /
Ryan Adams
Follow /25 Sep 2014 at 3:41pm / SQL Server

A Bad Day with Backups

I learned a hard lesson when I first started as a DBA.  Although to be honest, it’s not a lesson I should have had to learn (I’ll keep you in suspense).  I work for a large Fortune 100 company and as with many companies our size, there are...
85 0 /
Arthur Olcot
Follow /25 Sep 2014 at 2:37pm / SQL Server

Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR

Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to their latitude/longitude locations so I could use that data within some Tableau dashboards that I’m working on. I had a look around to see what I...
70 0 /
Tracy McKibben
Follow /25 Sep 2014 at 1:00pm / SQL Server

Presto Chango

About six months ago, I wrote a post reviewing a book titled The Phoenix Project . In that post, I compared the events in the book to my experiences in my role as a production DBA. I also shared some ideas that I gained from the book to help improve the...
58 0 /
David Dye
Follow /25 Sep 2014 at 5:00am / SQL Server

All About SSIS Variables Part 3 Variable Assignment

The sample package outlined in this post can be downloaded here . While my last post discussed SSIS object variables this post will look at variable value assignment.  There are several ways that a variable can be assigned a value within an SSIS package...
61 0 /
Jen Stirrup
Follow /24 Sep 2014 at 11:40pm / SQL Server

PASS Elections 2014: my personal thoughts

Disclaimer I am not endorsing any particular candidate I will not endorse any particular candidate I've written this out in the order of the NomCom ranking I wasn't asked by anyone to write anything I don't represent PASS by writing this blog...
48 0 /