SQL Server

SQL Server Community

SQL Server Blogs

Kenneth Fisher
Follow /1 Oct 2014 at 12:00pm / SQL Server

Intro to Auditing in SQL Server on SQL Shack

I had an article published yesterday on http://www.SQLShack.com . Intro to Auditing in SQL Server. It’s worth reading if I do say so myself. In it I go through several different methods for generating data that might be required by an auditor...
1 0 /
Ashish Banga
Follow /1 Oct 2014 at 10:43am / SQL Server

Error while enabling NetFx3 feature || Alternate source path error

Hello Friends, Life Is a struggle with Lot of If and buts. It’s being a many month I was out of touch with my blogging hunger. But there were lot of question which I was getting from time to time on my mails/blogs , which I will try to answer in couple...
5 0 /
Ryan Adams
Follow /30 Sep 2014 at 9:03pm / SQL Server

PASS 24HOP AlwaysOn Questions Answered

I presented a session titled “SQL Server AlwaysOn Quickstart” on September 10th for the 24 Hours of PASS event.  You can view the session recording HERE if you missed it.  The session was a preview of the full session I will be presenting...
26 0 /
James Serra
Follow /30 Sep 2014 at 3:00pm / SQL Server

IaaS, PaaS, and SaaS explained

You might be reading a lot about Cloud computing and see three acronyms frequently: IaaS, PaaS , Saas .  Cloud providers offer their services according to these three fundamental models: Infrastructure-as-a-service (IaaS) This is the most basic model...
44 0 /
Follow /30 Sep 2014 at 2:00pm / SQL Server

Video: Walk & Talk #003 – RPO

What is the RPO? And why does it matter? Join me as I walk through Jefferson Patterson Park’s Indian village and discuss the Recovery Point Objective and what it means is respect to SQL Server. Location: Jefferson Patterson Park More info...
34 0 /
Follow /30 Sep 2014 at 10:04am / SQL Server

Service Pack – SQL Server 2008 R2 SP3

Despite the fact that end of mainstream support ended for SQl Server 2008 R2 earlier this year, Microsoft have released SQL Server 2008 R2 Service Pack 3. SQL Server 2008 R2 SP3 is available for download at the SQL Server 2008 R2 SP3 download page...
38 0 /
Jen Stirrup
Follow /30 Sep 2014 at 6:59am / SQL Server

Data Analysts Toolkit Deck 1: Overview of Data Visualisation and Power BI

My slides from my Preconference training at SQLBits and SQLServerDays. In this module, we will look at an overview of theory and scientific evidence about data visualisation. Understanding the ‘why’ can help to make us better at the ‘how’, regardless...
47 0 /
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...
52 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...
44 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...
48 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 &...
40 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...
55 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...
44 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...
54 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...
50 0 /