Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2012

AdventureWorks in SQL Server 2012 RC0

The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version here for AdventureWorks. This download gives you an mdf, and that’s it. You can’t directly attach that in SSMS, but you can use T-SQL to do it.

CREATE DATABASE… Read more

1 comments, 928 reads

Posted in The Voice of the DBA on 29 February 2012

Statistics Enhancements in SQL Server 2012

Today I want to talk about Statistics Enhancements in SQL Server 2012. As you already know SQL Server uses Statistic Objects in a database to estimate the cardinality of queries. The cardinality estimation is the input for the generation of the physical Execution Plan of a given T-SQL query. Data… Read more

0 comments, 2,120 reads

Posted in Klaus Aschenbrenner on 29 February 2012

Download free eBook for SQL Server 2012

Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second draft of this book. SQL Server MVP Ross Mistry and Stacia Misner has covered Administration and BI part, there are 10 chapters in total divided in two part, they…

Read more

PASS SQLRally Dallas 2012 Pre-Con: How to Perform a SQL Server Health Check

If you are attending the PASS SQLRally this May in Dallas, I will be presenting a one day preconference session called “How to Perform a SQL Server Health Check”. Here’s the abstract for the session:

Are all the SQL Server instances you manage healthy, running optimally, and providing the high…

Read more

0 comments, 1,264 reads

Posted in SQL Aloha on 29 February 2012

Azure is Down

I saw a note about an outage on Windows Azure, apparently one that’s been going on for seven hours. Once again it seems that February 29 has struck again with a computer issue, and it makes me worry that if we mess with daylight savings time, we might have… Read more

0 comments, 758 reads

Posted in The Voice of the DBA on 29 February 2012

SQL Server 2012 (“Denali”): Extended Events

Extended Events is a general event-handling system for performance monitoring that was introduced in SQL Server 2008.  It has a highly scalable and highly configurable architecture that allows users to collect as much or as little information as is necessary to troubleshoot or identify a performance problem.

While there are… Read more

0 comments, 1,369 reads

Posted in James Serra's Blog on 29 February 2012

A Script A Day - Day 27 - Missing Database Backups

Today’s script is one I have used many times in the past to check for missing backups.  The script will return the database name and the last full backup date of all databases that are in the FULL recovery model and have not had a FULL database backup in the…

Read more

0 comments, 946 reads

Posted in SQL Server 365 on 29 February 2012

A Script A Day - Day 26 - RESTART a Database Restore

Today’s script is another one based on database restores.  There is a little known clause of the RESTORE DATABASE command called RESTART.  The name of this clause is deceptive, it does not RESTART anything and should actually be called RESUME or CONTINUE.  What it allows you to do is to…

Read more

0 comments, 1,024 reads

Posted in SQL Server 365 on 29 February 2012

Script SQL Server Agent Jobs Using PowerShell

It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is hosted by Wayne Sheffield (blog|twitter).

If you don’t know what T-SQL Tuesday is, you’re either new to the SQL community or have had your head buried… Read more

15 comments, 1,735 reads

Posted in John Sansom - SQL Server DBA in the UK on 29 February 2012

A Script A Day - Day 25 - Performance Counters

Today’s script is based on performance counters and in particular the sys.dm_performance_counters DMV.  There are many ways in which to view and collect performance counters the most common of which is to use perfmon.  Powershell is another method, I am currently working on a project where I will be collecting…

Read more

0 comments, 1,083 reads

Posted in SQL Server 365 on 29 February 2012

Write a Variable To a File Using SSIS

Problem

I’ve a SSIS package. When it fails execution, I want to write a custom message including the package name and error description to a text file.

Solution

One way to accomplish this is to declare a variable, populate it with the message you want, and write it’s value to… Read more

1 comments, 2,090 reads

Posted in Sam Vanga on 29 February 2012

What I Want For My Birthday

Dell has teased us with some images of their upcoming 12th Generation servers (that will support the Intel Sandy Bridge-EP processor). The PowerEdge R720xd is shown below. I want one of these…

Some more detailed information about these new servers is listed here.


Filed under: Computer Hardware,…

Read more

0 comments, 923 reads

Posted in Glenn Berry's SQL Server Performance on 29 February 2012

Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong

                Doing things by the book isn’t necessarily the only way to learn a new skill. Sometimes, experiencing everything that can possibly go wrong when you don’t follow the book can leave a more lasting impression.
I had that misfortune in December, when I tried to port some of my SQL…

Read more

2 comments, 1,571 reads

Posted in Multidimensional Mayhem on 28 February 2012

How’s Microsoft doing with community involvement? (updated)

Update: Jen Lussier has blogged a summary of the talks she had at the MVP summit last week. Take a look!

I’m at the Microsoft MVP Summit in Bellevue, WA this week (and having a simply lovely time, thanks for asking!)  MS Community Program Manager Jen Lussier tweeted:

Looking 4…

Read more

1 comments, 660 reads

Posted in SQL Awesomesauce on 28 February 2012

A Script A Day - Day 24 - Object Qualification

Today’s script is one I use as an example to explain that there is method behind my standards that some people initially see as madness.  I’m sure some people think I am trying to make their job harder and that I get a kick out of telling them to “go…

Read more

0 comments, 652 reads

Posted in SQL Server 365 on 28 February 2012

SQL Server 2008/2008 R2 Diagnostic Queries for March 2012

Since it is nearly March, I will go ahead and jump the gun by a few days and post an updated version of my SQL Server 2008/2008 R2 Diagnostic Queries for March 2012.

For this version, I have added information about the latest SQL Server 2008 R2 Cumulative Updates Read more

7 comments, 932 reads

Posted in Glenn Berry's SQL Server Performance on 28 February 2012

Monday Morning Mistakes: Not Setting Memory Limits

Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite often with clients and is an important topic to know about as a database administrator. Without further ado, let’s get to our issue

Issue

You have SQL Server database engine… Read more

10 comments, 13,380 reads

Posted in SQL Chicken on 28 February 2012

Converting SQL SERVER DateTime? Test it thoroughly….

Today one of my user complained that a report was missing one particular ticket from the output. The report in question is very simple, it accepts start date & end date and filters on the ticket creation date time column to get the list of tickets.

The report query was… Read more

10 comments, 2,632 reads

Posted in What I Learnt @ Work on 28 February 2012

Presenting at SQL Saturday #110

On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL Saturday #110 in Tampa, FL. Come out and join me in this code filled session, where we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel… Read more

0 comments, 623 reads

Posted in A Discussion of SQL Server-Related Topics on 28 February 2012

SQL Server Agent Job Steps

To list a SQL Server Agent Job Steps use the T-SQL example below.

This example displays the step id, SQL Server Agent Job name, Step name.

The code has 1 input parameter - @job_name

 

DECLARE @job_name VARCHAR(128)
SET @job_name = 'My SQL Server Agent Job'
SELECT js.step_id ,j.name,js.step_name FROM…

Read more

0 comments, 822 reads

Posted in SQLServer-DBA on 28 February 2012

Older posts