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

Archives: March 2012

Monitor SQL Server Backup job duration

if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the SQL Agant backup job which is created by maintenance plan,  it will be difficult to monitor the percentage of backup process.

here you can use the query below:

Read more

2 comments, 1,759 reads

Posted in James' SQL Footprint on 31 March 2012

Reflections on Leaving Microsoft

Reflections on Leaving Microsoft

Reflections of Microsoft By Jeff Sandquist (http://www.flickr.com/photos/jeffsand/)

Several members of my SQLFamily have made adjustments to their career path recently. Several of us got together for #SQLNomz yesterday to celebrate our job changes, though granted, we don’t generally require an excuse to get together. Yesterday (Friday,… Read more

Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial

My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of errors of my own making. This week’s mistutorial likewise teaches through bad example, by the same heuristic principle that experiencing what can go wrong with a task can sometimes… Read more

1 comments, 3,524 reads

Posted in Multidimensional Mayhem on 31 March 2012

Presenting at SQLSaturday #107 in Houston in April 2012

I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012. I’ll be doing two presentations, one on professional development plans and another on SQL security for developers. This will be my first time at the Houston SQLSaturday and really looking… Read more

0 comments, 1,501 reads

Posted in SQLAndy on 31 March 2012

Remote DAC connections


I wrote a post recently about setting the DAC port for an SQL instance.

I now do this as a matter of course on all of my SQL instance as I manage most of them remotly.

However, from time to time I discover instances that have had… Read more

0 comments, 1,865 reads

Posted in measure twice, cut once. on 31 March 2012

Select : Lock or No Lock?

Here is a post I happen to find today: why select command is not blocked by update command?

First, I thought it might be a transaction isolation level issue, but when I dig into the problem, something interesting pop up.

Here is the script to repro this issue
first create…

Read more

1 comments, 2,858 reads

Posted in James' SQL Footprint on 30 March 2012

Spring SQL Server Connections / DevConnections

I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I talked about Encryption, Filestream/Filetable, and Contained Databases. Always cool to see your name in print

It was a nice event, with decent crowds in the… Read more

1 comments, 2,656 reads

Posted in The Voice of the DBA on 30 March 2012

Re-blog – March 23 – March 29

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have… Read more

0 comments, 1,846 reads

Posted in StrateSQL on 30 March 2012

BIDS Helper 1.6 for SQL Server 2012 released

BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio, and now supports SQL Server 2012 (including tabular mode) and Visual Studio 2010 (SSDT).  Version 1.6 can be downloaded here, and read up… Read more

1 comments, 2,498 reads

Posted in James Serra's Blog on 30 March 2012

Stress Thoughts-Part 4

Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes to sort out why I was stressed, but instead I had to step right into another meeting. It was a follow up meeting to build out an implementation plan for… Read more

0 comments, 1,585 reads

Posted in SQLAndy on 30 March 2012

SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.

On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition. I have done this multiple times with no issues. The “kicker” was that the upgrade required a 48-hour turnaround time but no installation media for SQL Server Enterprise… Read more

1 comments, 4,792 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 30 March 2012

Liveblog for #SQLBits X Day 1 Keynote

Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.

There’s no need to refresh your browser folks, we’re technology savy here at SQLBrit don’t you know and using a LAMP stack  Send your Tweets to @SQLBrit and keep an eye on the #SQLBits hash… Read more

2 comments, 1,585 reads

Posted in John Sansom - SQL Server DBA in the UK on 30 March 2012

SQL Saturday #130 Jacksonville Schedule Posted

SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released the schedule for the event. We have a great line up of speakers with a variety of topics for both DBAs and Business Intelligence developers. You can register to attend… Read more

0 comments, 1,636 reads

Posted in Devin Knight on 30 March 2012

SQLSaturday #107 Houston

About 3 weeks to go until SQLSaturday #107 at YES Prep Public Schools - North Central Campus, 13703 Aldine-Westfield, Houston, TX, 77039!  Register today if you haven't already!

Remember, in addition to traditional DBA topics, the event will have some topics of interest to developers that work with SQL…

Read more

0 comments, 1,312 reads

Posted in SQL Tact on 29 March 2012

An Amusing New Chapter of My Career

My New Office

Starting next week, that’s the first week of April, this will be my new office. Well, not really, but I’ll be working for the company that hosts this coaster, Six Flags. I’ll be overseeing all the SQL Server stuff for the entire organization. That means the back… Read more

1 comments, 1,694 reads

Posted in Eric Humphrey on 29 March 2012

Caveats of a CONTROL SERVER permission

Today morning I was working on one of the server to complete the regular documentation of security audit with details of logins with sysadmin rights and their access to various database. Later I have realized that, one login has access to all database but it is not captured by my auditing script.…

Read more

15 comments, 1,900 reads

Posted in PracticalSQLDba on 29 March 2012

Three Sessions at Spring 2012 Connections Conference

I will be a busy little beaver today, presenting three sessions at the Spring 2012 Connections Conference, the first one at 8AM! Hopefully enough people will be able to get up by then and join me. It should be a lot of fun!

SQL301: Scaling SQL Server 2012
Glenn Berry

Read more

9 comments, 1,722 reads

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

Save yourself from despair with full database documentation

Your ability to document thoroughly will determine  your efficiency and productivity when it comes to managing your SQL Server databases. Aside from the question of productivity, there’s always the concern of having to come across with problems relating to the unfamiliarity of vendor databases (this is particularly true with third-party… Read more

1 comments, 2,681 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 29 March 2012

Contained Databases in SQL Server 2012

One of the problems with databases in SQL Server is the dependency of the database on various parts of the host instance. In SQL Server 2012 there is an enhancement to the database format that allows for partial containment of your database, and will make the movement, migration, and management… Read more

3 comments, 1,985 reads

Posted in The Voice of the DBA on 29 March 2012

Importing data from Excel – using INSERT statements

You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However, when the data is simple and limited I avoid using it (too lazy to click through 6 screens… ) instead I generate INSERT statements using CONCATENATE function in Excel… Read more

6 comments, 3,270 reads

Posted in SQL and Me on 29 March 2012

Older posts