SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2013

Six top SQL Server 2012 management tools you should know about

Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high training costs and poor database administrator (DBA) productivity.

To keep up with these new demands of complex… Read more

1 comments, 1,394 reads

Posted in Basit's SQL Server Tips on 26 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, 1,405 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, 573 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, 2,099 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, 1,578 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, 919 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, 872 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, 602 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, 3,839 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, 1,001 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, 2,323 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

21 comments, 2,358 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, 683 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, 737 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, 354 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, 901 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, 1,027 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, 8,772 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, 665 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, 3,316 reads

Posted in The Scary DBA on 25 March 2013

Newer posts

Older posts