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

RealSQLGuy - Helping You To Become A SQL Hero

My real name is Tracy McKibben. I’ve been working with database products for over 20 years, starting with FoxBase running on Xenix. Over the years, I’ve worked with all flavors of FoxPro, some Clipper and dBase, and starting somewhere around 1995, SQL Server. I’ve even dabbled with Oracle, though I’ve tried to block out all memories of that experience. At present, I’m the Senior SQL Server DBA and the DBA Team Supervisor for Pearson VUE. All opinions expressed on this site are my own and do not reflect the opinions of Pearson VUE.

Archives: November 2013

What’s In My Utility Belt? Issue #2

Wow, can you believe it’s been a month already since I posted the first issue of “What’s In My Utility Belt?”? Time flies when you’re having fun. Or when you’re really busy. A lot has happened since that first issue – I became, once again, a Rockstar Blogger, I… Read more

0 comments, 255 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 30 November 2013

Friday Followup For November 29, 2013

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

  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • 20 Abuses: Procedurally Going In Circles
  • Do You Need…

Read more

0 comments, 213 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 29 November 2013

What Are Your Servers Doing While You’re Sleeping?

Well, do you know? You’re the DBA, the guy in charge, the guy who gets pounced on first thing in the morning with complaints of “my report took FOREVER to run last night, why?”, or “customers are saying the web site was really slow at 3:00am this morning, why?”. You’re… Read more

6 comments, 317 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 November 2013

Friday Followup For November 22, 2013

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

Read more

0 comments, 136 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 22 November 2013

What Happens In Vegas…

…stays in Vegas, except when it comes to chocolate. After walking more than 1500 miles over the past 9 months, 30 of those in Las Vegas last week, I’ve earned a treat. What’s this have to do with SQL Server? Absolutely nothing…

That doesn’t mean it’s not relevant to this… Read more

2 comments, 152 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 21 November 2013

Automated Permissions Auditing With Powershell and T-SQL: Part 6

Everybody still with me?  Have you tried the script from Part 5?  Did you notice how SLOW the Active Directory lookups are?

They’re not fast, that’s for sure. On one of my servers, the number of databases is somewhere in the neighborhood of 120, the old “one database per… Read more

6 comments, 217 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 20 November 2013

Automated Permissions Auditing With Powershell and T-SQL: Part 5

If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now looking at a Powershell script that is slowing getting more complex.

By now, you should be starting to appreciate how much power (pun intended) Powershell gives you.  It’s quickly becoming… Read more

0 comments, 1,731 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 19 November 2013

Automated Permissions Auditing With Powershell and T-SQL: Part 4

Previously, on REAL-SQL-Guy…

We were introduced to two SQL queries to obtain database login permissions, one for SQL Server 2000, one for SQL Server 2005 and higher.

We saw how these queries, combined with Powershell, can be used to loop through all databases on a SQL Server instance… Read more

3 comments, 335 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 18 November 2013

Superpowers Revealed

Like many of you out there, I’m constantly looking for new things to learn. A new skill, a new hobby, a new word. I’m a sucker for gadgets and gizmos, self-help books, “life hacks”, recipes, brain games, all of the standard nerd attractions. I’m also easily distracted by shiny things,… Read more

0 comments, 181 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 16 November 2013

Friday Followup For November 15, 2013

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

  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • Do You Need A Log Recovery Tool?
  • The Cloud…

Read more

0 comments, 145 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 15 November 2013

Automated Permissions Auditing With Powershell and T-SQL: Part 3

In this episode, I’m going to start introducing some of the Powershell elements that tie this audit process together.

DISCLAIMER:  I am NOT a Powershell expert, I have only recently begun to use it.  There are likely parts of this process that can be done differently, more efficiently, or are… Read more

2 comments, 1,034 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 14 November 2013

Automated Permissions Auditing With Powershell and T-SQL: Part 2

In Part 1 of this series, I presented a T-SQL query that will return a summary of login permissions within a SQL 2005/2008 database. I also mentioned that SQL 2000 requires a slightly different query.

Here is that query.

In the upcoming Part 3, I will start diving into the… Read more

0 comments, 215 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 13 November 2013

The Cloud Is Scary – #TSQL2sDay #49

It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic isn’t one that I have much experience with from a SQL Server perspective, but I I’m definitely a user of the technology.

This month’s topic is all about the cloud.…

Read more

1 comments, 246 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 12 November 2013

Automated Permissions Auditing With Powershell and T-SQL: Part 1

A big part of my job is controlling security to multiple production databases, and reporting on that security for quarterly audits.  In my environment, it’s not important to know who has access to specific tables or other objects, but we are interested in knowing who has some form of read… Read more

4 comments, 462 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 11 November 2013

SYS.PARTITIONS: Better Than X-Ray Vision

Originally posted 2011-09-09 21:27:00. Republished by Blog Post Promoter

Over the past few months, I’ve been doing a lot of work with the table and index compression introduced in SQL Server 2008. If you’ve worked with this stuff much, you know that, in an existing database, it involves index rebuilds… Read more

2 comments, 1,110 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 9 November 2013

Friday Followup for November 8th, 2013

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

Read more

0 comments, 168 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 8 November 2013

Transparent Data Encryption’s Dirty Little Secret

Remember when you were eight years old, how exciting it was to order some of those amazing products that were advertised in the back of comic books? Sea Monkeys, your very own nuclear sub,  X-Ray glasses? Good stuff…

Remember how utterly disappointed you were when the crap that you ordered… Read more

0 comments, 388 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 7 November 2013

Do You Need A Log Recovery Tool?

A couple of weeks ago I wrote a post dispelling the myth that the simple recovery model disables the transaction log on a SQL Server database. In that post I touch briefly on the topic of a “point-in-time” restore, which is used to restore a database back to the way… Read more

10 comments, 375 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 4 November 2013

Building The Redneck Treadmill Desk

Don’t tell Brent Ozar, but here’s another DBA writing another helpful article about shrinkage. Before he gets bent out of shape and writes another rant about shrinking database files, let me clarify one thing – this article isn’t about database shrinkage, it’s about DBA shrinkage.

Almost a year ago,… Read more

4 comments, 2,962 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 4 November 2013