SQL Server

SQL Server Community

SQL Server Blogs

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...
6 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...
34 0 /
WaterOx
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...
25 0 /
Richard_RP
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...
31 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...
36 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...
47 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...
41 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...
44 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 &...
36 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...
52 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...
40 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...
51 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...
47 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...
142 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...
65 0 /