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

Archives: March 2013

Custom Reports for SSMS 2012

I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13.  I promised I would post my code/solutions, so here it is.  For those that were not able to attend the meeting, here is a brief description of what I am posting.

I am lucky enough to be… Read more

0 comments, 2,100 reads

Posted in SQL Swimmer on 29 March 2013

SQLServer Log Shipping Work File ! What is this all about ?

A short and sweet post for a gorgeous morning -

Have you seen a file with extension .wrk in the log shipping copy folder ?

What is this all about, Curious? Then here is the answer -

When the transaction log backup files are copied from the primary server to… Read more

5 comments, 4,221 reads

Posted in SQLSailor.com on 29 March 2013

Exploring Excel 2013 for BI Tip #5: Cleaning Up Slicers

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 1,566 reads

Posted in DataOnWheels on 29 March 2013

Reblog: March 22 to March 28

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 1,405 reads

Posted in StrateSQL on 29 March 2013

Free SQL Server Training for the Week of April 1, 2013

Here are some training events you might be interested in for the coming week:


Tuesday, April 2


Thursday, April 4

Read more

Is BETWEEN faster than GTE and LTE?

I know I have been light on blog posting this year. They always say that life tends to get in the way of these sorts of tasks, and this year that is certainly true. Anyways, I want this blog to be more than just SQL Server virtualization with VMware vSphere,… Read more

0 comments, 15,875 reads

Posted in Technobabble by Klee from @kleegeek on 29 March 2013

SSPI error and Incorrect timing.


Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance using SQL SERVER Management Studio (SSMS)

Now, I could RDP to the server and connect to the local instance using SSMS, however any attempt to connect to the… Read more

0 comments, 1,621 reads

Posted in measure twice, cut once. on 28 March 2013

Disk Space Checker

One method my company deploys our software is in a dedicated hosted environment. In this situation, we partner with a data center that provides hardware, we install the software and the client doesn’t get access to the hardware directly. This normally works well, unless they tend to have a-lot of… Read more

0 comments, 1,115 reads

Posted in Jason Carter on 28 March 2013

Exploring Excel 2013 for BI Tip #4: Adding a Slicer

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 1,900 reads

Posted in DataOnWheels on 28 March 2013

The Great Laptop Search of 2013

It’s time for a new laptop. I don’t think it’s time, as I love the Macbook Air I bought a couple years ago. Rather some requirements for work, mainly Hyper-V, have come up and I can’t meet them with the Macbook Air. Even a 2013 summer refresh of this platform… Read more

10 comments, 3,884 reads

Posted in The Voice of the DBA on 28 March 2013

SQL Server 2012 Business Intelligence Enhancements

My first article in SQL Server Pro magazine has been published.  It is entitled “SQL Server 2012 Business Intelligence Enhancements” and can be found here.  I hope you enjoy it!

Read more

4 comments, 1,539 reads

Posted in James Serra's Blog on 28 March 2013

Squishy Limits in SQL Server Express Edition

It’s an old story you’ve probably heard before.  Provide a free version of your software product with strict limitations on performance or other specific capabilities so that folks can give it a try without risk, while you minimize the chance of cannibalizing sales of your commercial products.  Microsoft has take… Read more

4 comments, 1,333 reads

Posted in Kevin E. Kline on 28 March 2013

Security: People Are the Weakest Link

There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's what I've seen:


  • Most people know the basic rules.
  • People will follow the basic rules until it interferes with something they want.


This is why security awareness generally fails.… Read more

@LearningTree: SQL Server High Availability

Learning Tree are offering their 3 day SQL Server High Availability course this April in London. Running between 17th and 19th of April and taught by Chris Radcliffe come and learn all about SQL Server high availability and get your hands dirty with

  • SQL Server Clustering
  • Database Mirroring
  • Availability Groups

Read more

0 comments, 1,431 reads

Posted in The SQL DBA in the UK on 28 March 2013

SQLTreeo – Migration of extended properties to local storage

New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and folders. This option was added because many users had issues with storing their folders in extended properties of SQL objects (mostly because of permission issues).

Users who need to swap… Read more

0 comments, 1,636 reads

Posted in SQL Treeo on 28 March 2013

Network Packet Size: to Fiddle With or Not to Fiddle With

A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s something that DBAs should be aware of. There is a server configuration in SQL Server that controls the size of packet in which SQL Server sends out data. This setting…

Read more

The DBA Team #1–Code and Slides

Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again.

In the meantime, we didn’t make a separate site for this series of events,… Read more

2 comments, 1,627 reads

Posted in The Voice of the DBA on 27 March 2013

SQL Intersection!

The best emotion to describe how I’m feeling is ‘astounded’.  I’m astounded that I’m in such august company to be speaking the SQLIntersection (#iSQL) conference.  Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection.

Check out this list… Read more

9 comments, 1,310 reads

Posted in Kevin E. Kline on 27 March 2013


In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE, it helps to keep code simple and clean. I use XML extensively in my code and many a time, I find myself looking up code, searching the internet or trying… Read more

0 comments, 196 reads

Posted in SQL Roadie on 27 March 2013

What to Do When You Can't Wipe an Infected System

When it comes to workstations within most organizations, the solution when one gets infected is to wipe it and re-image it. However, when we're talking about servers, sometimes that's not a viable business option. I've been in that position. In those cases you do your best to remove any traces… Read more

Older posts