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

Archives: March 2013

SQL Server: Purging msdb History Tables to Control msdb Database Growth

From time to time, I see the following question posted on various SQL Server forums by different users asking why the msdb database on their SQL Server instance is too big. As we all know, msdb is a system database that supports SQL Server Agent service, and stores all the… Read more

0 comments, 607 reads

Posted in Basit's SQL Server Tips on 26 March 2013

XML Support and SQL Server (Part 5)

Checkout the fifth part of my XML support and SQL Server article series here.

In this article, I discussed the basic XML query methods for XML data manipulation. I also gave an brief introduction to the XQuery language, and demonstrated how to use the query(), value(), exist(), nodes(), and… Read more

0 comments, 314 reads

Posted in Basit's SQL Server Tips on 26 March 2013

A Rickety Stairway to SQL Server Data Mining, Part 10.2: DMX DML

by Steve Bolton

                The three introductory posts in this series of self-tutorials on SQL Server Data Mining (SSDM) and the separate articles on the nine algorithms Microsoft ships with it covered the most complex and essential elements of of the most under-utilized and underestimated component of the product. Most of… Read more

2 comments, 902 reads

Posted in Multidimensional Mayhem on 26 March 2013

Policy Based Management On Change: Prevent not available

Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE to get more information.  Today I want to talk about the “On Change: Prevent” mode and why you don’t always see it as an option.

The options you see available… Read more

10 comments, 449 reads

Posted in Ryan Adams on 26 March 2013

PASS Business Analytics presents MVP Jessica Moss: Putting the Business Into Business Analytics

I saw Jessica Moss presenting at the PASS Summit a couple of years ago on Reporting Services. She has been an author to many books and has a good series on SQLServerCentral.com’s Stairway series for Reporting Services.

Please join the PASS Business Analytics virtual chapter on April 4th at… Read more

0 comments, 265 reads

Posted in The Smiling DBA on 26 March 2013

Office Space–Not The Movie

I’ve worked in a lot of different offices and office layouts over the years. Looking back I’ve been lucky (or not as you prefer) to not spend much time in a cube, almost always having my own workspace or sharing it with one other person. I’ve helped assemble furniture, move… Read more

0 comments, 369 reads

Posted in SQLAndy on 26 March 2013

Chicago SQL Saturday (#SQLSat211) Coming Up


We’re less than three weeks away from the Chicago SQL Saturday.  This will be my fourth time heading to Chicago for their SQL Saturday and I’m looking forward to that and a stop at Portillo’s (which I probably shouldn’t mention since Sarah isn’t able to come along).  The… Read more

0 comments, 270 reads

Posted in StrateSQL on 26 March 2013

TFS vs SSIS project versioning

I had someone ask me the other day if they are using SSIS 2012 Project Versions, is there any benefit to using TFS?  The answer is Yes!  While Project Versions is a new feature that keeps prior versions of SSIS projects as they are deployed to the server… Read more

0 comments, 1,383 reads

Posted in James Serra's Blog on 26 March 2013

SQL Saturday #187–Richmond Recap

I’m late writing this, and I did mean to get to it earlier, but life got in the way.

TL;DR: It was a great event, lots of fun, and I’d love to do it again.

When I first heard of a SQL Saturday coming back to Richmond (from Carlos Chacon Read more

2 comments, 326 reads

Posted in The Voice of the DBA on 26 March 2013

Use Powershell to Pick Up what Database Mirroring Leaves Behind

Database mirroring has been around since SQL Server 2005, and it's turned out to be an excellent step up from log shipping.  However, like log shipping, it is still only a database-level disaster recovery solution.  Meaning that any logins, server role memberships or server-level permissions will not be mirrored over…

Read more

0 comments, 978 reads

Posted in Everyday SQL on 26 March 2013

SQL Server : Part 8 : Explaining The Covering Index or Included Columns

In our earlier discussion about non clustered index ,we have seen that, the leaf level of a non clustered index contain only the non clustered index key column and clustered index key (if the table is a clustered table). To fetch the remaining column from the clustered index structure or…

Read more

9 comments, 1,190 reads

Posted in PracticalSQLDba on 25 March 2013

Pragmatic Works Webcasts This Week #passwit

Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month, the series is showcasing all of its sessions with women speakers.  Doing this offers all of us a chance highlight some of the female voices in… Read more

0 comments, 349 reads

Posted in StrateSQL on 25 March 2013

Speaking at SQLSaturday #197 in Omaha on April 5-6

I will be speaking on both Friday and Saturday (April 5-6) at SQLSaturday #197 in Omaha, Nebraska. I will be delivering a full day pre-con on Friday, and then doing Hardware 201 on Saturday. Here is the abstract for my pre-con:

Scaling SQL Server 2012

How can you scale SQL…

Read more

0 comments, 386 reads

Posted in Glenn Berry's SQL Server Performance on 25 March 2013

SQL Server – How to Search/Query the SQL Server Error Log

Often times I keep checking the error log to make sure if everything is running fine. Here is an undocumented stored procedure that really helps simplify our task of searching the error log. Exec XP_ReadErrorLog GO This proc has 4 parameters: Parameter 1 (int), is the number of the log…

Read more

0 comments, 92 reads

Posted in SqlServerZest.com - SQL in simple style on 25 March 2013

A Week from Omaha–SQL Saturday #197

Next week I head out to SQL Saturday #197 in Omaha NE. I’m looking forward to it as I’ve never been to Omaha, and only been to the state once, in the far SW corner to Oshkosh for a horse race. I’ll arrive Friday and have a short time to… Read more

0 comments, 394 reads

Posted in The Voice of the DBA on 25 March 2013

Last Weeks Top “Reading” Links #25

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These tweets include “Reading” in the message and are items I’ve read over the past few days, usually after hours when sharing would be… Read more

0 comments, 382 reads

Posted in StrateSQL on 25 March 2013

How do I move a SQL login from one server to another without the password?

This is an uncommon task but one that does turn up every once in awhile. A SQL login has to be moved from a development server to a test server, test to prod etc. Or maybe a lateral move to a new server. And frequently the DBA doesn’t and/or shouldn’t… Read more

10 comments, 3,541 reads

Posted in SQLStudies on 25 March 2013

Cumulative Update – 10 for SQL Server 2008 Service Pack 3 Is Now Available !

The 10th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 10 contains all the hotfixes released since the initial release of SQL Server 2008 SP3.

Those who are facing severe issues with their environment, they can plan to test CU10 in test environment… Read more

0 comments, 341 reads

Posted in MSSQLFUN on 25 March 2013

Execution Plans in Azure SQL Database

Microsoft has stated pretty clearly that they’re putting code on Azure first, ahead of the desktop. Which makes one wonder when we’re going to start to see some of this cool stuff within SSMS. What cool stuff you ask? Well, let me explain. Let’s start with a query:

SELECT	m.MovieName,…

Read more

5 comments, 1,365 reads

Posted in The Scary DBA on 25 March 2013

Implicit Conversions and Avoiding Them With Computed Columns

I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known technique and I wanted to share it with you here.

A customer environment was suddenly receiving high CPU alarms and I was called in to take a look.

Having… Read more

6 comments, 2,500 reads

Posted in John Sansom - SQL Server DBA in the UK on 25 March 2013

Newer posts

Older posts