SQL Server

SQL Server Community

SQL Server Blogs

Follow /1 Oct 2014 at 6:14pm / SQL Server

Service Pack – SQL Server 2008 SP4

Despite the fact that end of mainstream support ended for SQL Server 2008 earlier this year, Microsoft have released SQL Server 2008 Service Pack 4.  This arrives a few days after Service Pack 3 for SQL Server 2008 R2 , but three years since the last...
17 0 /
Jen McCown
Follow /1 Oct 2014 at 4:14pm / SQL Server

Why don’t they make the optimizer faster? (An essay on nested views)

We got a question recently that basically boiled down to this: Nested views shouldn’t be such a performance suck. Why doesn’t Microsoft make the optimizer deal with nested views better? We’ve looked into this a good deal – nested views are...
20 0 /
Chris Yates
Follow /1 Oct 2014 at 2:00pm / SQL Server

C-R-U-D The Basics

C-R-U-D The Basics What is CRUD? Well, there are a lot of things I can think of when I use the term CRUD; however within the wonderful world of technology CRUD is an acronym that surprisingly enough, when I polled, didn’t really give a straight...
31 0 /
Mike Walsh
Follow /1 Oct 2014 at 1:03pm / SQL Server

Hey DBAs, Don’t Be Like the Secret Service!

Last week, I ripped a story from the headlines to draw lessons for Technologists from – it was about the Secret Service lapses that allowed a fence jumper to get into the threshold of the White House residence. That was bad. This week, though, we’ve...
27 0 /
Follow /1 Oct 2014 at 12:05pm / SQL Server

Identifying large queries using Extended Events

Following on from my last blog post I now want to run through how to identify large queries using Extended Events. Extended Events were introduced in SQL Server 2008 and allow monitoring to be run against a server with a lower performance impact than...
24 0 /
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...
25 0 /
Derik Hammer
Follow /1 Oct 2014 at 12:00pm / SQL Server

Query Object Dependencies

SQL Server Management Studio has a decent interface for viewing object dependencies, check out TechNet for those procedures. But, we all know the value of being able to run queries for the information that we need. There are two methods that we’re...
25 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...
27 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...
33 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...
50 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...
39 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...
41 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...
49 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...
54 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...
49 0 /