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

Archives: March 2014

Reblog: March 21 to March 27

Photo credit – Jenn and Tony Bot

Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came… Read more

0 comments, 567 reads

Posted in StrateSQL on 28 March 2014

SQL Saturday RVA recap

Wow, what a month. On March 22, 2014, the SQL Saturday train came into Richmond VA (RVA). I was one of the organizers of the event, and what a ride we had.

The rough part of the ride started off earlier in the week. A freak spring snowstorm rolled through… Read more

0 comments, 825 reads

Posted in A Discussion of SQL Server-Related Topics on 28 March 2014

Table Space updated again

Today we have another update for an age old script on this site.  You can find the last update to the script here.

This time we have a bit of a bug update.  The details of that bug are in the notes for the script.

Read more

2 comments, 729 reads

Posted in SQL RNNR on 28 March 2014

SQLServerCentral Editorial: The Perfect Environment

I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them here, so trying to resume doing so. Today it’s The Perfect Environment, which is, as you might guess, discussing to what degree you strive for perfection and how far… Read more

0 comments, 492 reads

Posted in SQLAndy on 28 March 2014

Building the SQLSaturday Orlando Marketing Plan–Part 1

I’ve volunteered to lead the marketing effort for SQLSaturday Orlando this year. Broadly speaking that means drive attendance to the main event as well as any seminars we host on Thursday or Friday. We’ve hit a cap the last few years, never getting beyond the 275-300 range (I’ll get exact… Read more

0 comments, 464 reads

Posted in SQLAndy on 28 March 2014

Can’t See The Forest For the Logins–Question of the Day

My latest question is live today – Can’t See The Forest For the Logins is worth 2 points if you’re playing for score. It’s another question where you have to infer some to get the answer. So far it’s proving to be a tough question, be sure to read the… Read more

0 comments, 406 reads

Posted in SQLAndy on 28 March 2014

Friday Followup For March 28, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Cheating DBCC To Fix Index Corruption
  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • Building The Redneck…

Read more

0 comments, 420 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 28 March 2014

South Alabama Day of .NET 2014

About 200 miles east of Baton Rouge there lies a beachside town called Mobile, AL that will settle down long enough from spring break to host the first South Alabama Day of .NET at the University of South Alabama. The wife and I are looking forward to presenting at the…

Read more

0 comments, 685 reads

Posted in SQL Tact on 27 March 2014

Getting RUN back in Windows 8

Recently I heard a few people that note that they were really hoping the next update for Windows 8 will bring back the “Run button”, which was available in XP and Windows 7. I guess it was in Vista, but we won’t talk about that fiasco.

I asked a question… Read more

0 comments, 655 reads

Posted in The Voice of the DBA on 27 March 2014

PASS Summit 2012 session videos online

All PASS Summit 2012 recordings are now available for free to all PASS members (201 of them!).  To view, log on to your myPASS account, and watch the sessions from myRecordings.  While there, check out mine: Building an Effective Data Warehouse Architecture

Read more

0 comments, 713 reads

Posted in James Serra's Blog on 27 March 2014

Tally Tables in T-SQL

The Tally (or Numbers) table is one of the most useful constructs in intermediate-level SQL. Have you ever written a T-SQL WHILE loop? How about a CURSOR? If your answer to either of those questions is yes, you’ve probably been coding some really poor-performing SQL and you may not even… Read more

10 comments, 19,602 reads

Posted in DwainCSQL on 27 March 2014

Quick Tip: Migrating a SQL Server Mirroring Witness server.

If you’re like me, you might be thinking “I want some more things to think about when I migrate between SQL Servers.” … No? Okay, fair enough. There’s a whole list of things to think about when migrating from one SQL instance to another including:

  1. Logins.
  2. Jobs/Alerts/Operators.
  3. Credentials/Proxies.
  4. Linked Servers.

Read more

3 comments, 594 reads

Posted in Ctrl-alt-geek on 27 March 2014

Two IDs, One database and a Magic Number (and maybe even an empty string)


I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least I thought it was odd

Normally, I join with sys.dm_exec_sessions and filter out anything that is a system process (WHERE [sys].[dm_exec_sessions].[is_user_process] = 1 )

However, this time… Read more

0 comments, 1,215 reads

Posted in measure twice, cut once. on 26 March 2014

SQL Scripts Manager

We have Down Tools Week multiple times per year at Red Gate. This allows various employees to spend a week on a project, working to build something new and interesting that we rarely have time to spend our limited resources on. Past projects have resulted in SQL Search, a mobile… Read more

0 comments, 3,478 reads

Posted in The Voice of the DBA on 26 March 2014

Zap Business Intelligence Installation

This walkthrough helps you to install Zap Business Intelligence. Some of you may need help knowing where to download the files. This is where I can help you. Firstly, go to www.zapbi.com Go to the download section and download the installation file. Run setup: Setup the connection details: Setup IIS…

Read more

4 comments, 853 reads

Posted in Terry's Business Intelligence on 26 March 2014

Speaking at OPASS – April 2014

If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a long time ago! I’ll be back at oPASS in April doing two presentations (to make up for missing 2013!):

Building A Learning Plan

What should you learn next? How…

Read more

0 comments, 570 reads

Posted in SQLAndy on 26 March 2014

SQL Saturday Oklahoma City precon: Becoming an Enterprise DBA

We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an Enterprise DBA” August 22!.  Get your early bird ticket by July 15, and save over 15%! Precon: Becoming an Enterprise DBA August 22, 2014, Norman Technology Center, Moore OK There’s…

Read more

0 comments, 568 reads

Posted in SQL Awesomesauce on 26 March 2014

The Unusable User–Question Of The Day

My latest question The Unusable User is live today over at SQLServerCentral. It’s a three pointer, how is that for an incentive to give it a try? Here are the early stats, it’s definitely a hard question (or badly written? nah):



I’ll post follow up on… Read more

0 comments, 631 reads

Posted in SQLAndy on 26 March 2014

Collation: Expression

I had a recent run in with collation problems and it got me started reading. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

Once you have… Read more

0 comments, 1,627 reads

Posted in SQLStudies on 26 March 2014

Collation: Expression

I had a recent run in with collation problems and it got me started reading. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

Once you have… Read more

0 comments, 430 reads

Posted in SQLStudies on 26 March 2014

Newer posts

Older posts