Category Archives: TSQL

Domain Security Groups – Who is in the group?

As we all know, user access is one of the tasks that DBA’s are responsible for in their environment.  And if we are following best practices and want to make our lives easier, we should be handling user access with … Continue reading

Posted in PowerShell, Security, TSQL | Tagged | Leave a comment

Investigating Job Schedules

One of the very first blog posts I made was on knowing what happened last night (https://sqlbadboy.wordpress.com/2012/10/12/what-happened-last-night/). In that post, I mentioned various ways that we could find out the statuses of jobs that had run. And this is an … Continue reading

Posted in DBA, TSQL | Tagged , | Leave a comment

Getting to Know Your Hardware

Should a DBA know what kind of hardware they are running on? And better yet, should they care? My answer to both questions would be a firm … YES! Here are two reasons why a DBA should know and care … Continue reading

Posted in DBA, PowerShell, TSQL | Tagged , , | Leave a comment

Full-Text Search – A Beginner’s Guide

In my experience, many DBA’s and developers seem to shy away from Full-Text Search (http://technet.microsoft.com/en-us/library/ms142571.aspx).  But, it is not as complicated as you may think.  In this post, I am going to attempt to make it as easy as possible … Continue reading

Posted in DBA, Developer, TSQL | Tagged | Leave a comment

Undocumented Stored Procedures … Do NOT Rely on Them in Production!

“Just because you can, does NOT mean you should.”  This is one of my favorite sayings that I like to apply in many aspects of my life, including when I am dealing with SQL Server. For example, there are a … Continue reading

Posted in DBA, Developer, TSQL | Tagged | Leave a comment

Should Size Matter in Database Decisions?

Imagine that you are faced with two different database situations.  Would your decision on what to do be influenced by the size of the objects involved? For example: You need to update all the rows for a column in a … Continue reading

Posted in DBA, TSQL | Tagged , , | 1 Comment

Database Administrators or Developers … Who is Responsible for Indexing?

To answer that question, I am going with “it depends” and “both”! The reason I answer that way, is that anyone designing, building, querying, or maintaining database objects needs to have a grasp of indexing and how it will affect … Continue reading

Posted in DBA, Developer, TSQL | Tagged , , , | Leave a comment