Author: Tracy Boggiano

T-SQL Tuesday #44 The Second Chance

This month’s T-SQL Tuesday is brought to us by Bradley Ball (blog | @SQLBalls). Bradley asked us to write about Second Chances.  Giving us a chance for us to talk about things we have learned from mistakes we have made.  Over the years we have all made mistakes or wished we would have done something …

Read More “T-SQL Tuesday #44 The Second Chance”

Query “SQL Server has encountered ? occurrence(s) of I/O requests taking longer than 15 seconds to complete on file” from the Logs

Recently we moved some servers from being physically on local drives to virtual on our SAN.  We started getting Error 833 messages every night during Integrity Checks.  The more servers we added the more messages we got.  I needed a quick way to retrieve these messages from our error logs and considering we cycle the …

Read More “Query “SQL Server has encountered ? occurrence(s) of I/O requests taking longer than 15 seconds to complete on file” from the Logs”

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 3

This entry is part 3 of 3 in the series Automation of PAL

This entry is part 3 of 3 in the series Automation of PALIn the final part of the process will be the process that creates all the reports and zips up the performance counter file on a central server.    The first part copies the PerfMon file from the each server to a central location.  …

Read More “Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 3”

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 2

This entry is part 2 of 3 in the series Automation of PAL

This entry is part 2 of 3 in the series Automation of PALIn this part of the process we will setup a process to automatically stop the data collector or counter log on the remote server.  Then  rename the file with a time stamp if it is an older version of Windows.  Finally we will …

Read More “Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 2”

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 1

This entry is part 1 of 3 in the series Automation of PAL

This entry is part 1 of 3 in the series Automation of PALI recently was re-exposed to the PAL (Performance Analysis of Logs) Tool available on CodePlex at a wonderful SQLskills class.  I had played with the tool in the past but at the time the server I had for setting things up and automtaing …

Read More “Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 1”

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

This month’s T-SQL Tuesday is brought to us by Argenis Fernandez (blog | @DBArgenis). Argenis is asking if we specialize or not, why we do (or don’t) specialize, and why we feel that’s a good thing. I started out my career as a Jack of All Trades mainly because my first employer was a small …

Read More “T-SQL Tuesday #028 – Jack of All Trades, Master of None?”

A New Year Means New Resolutions – 2012

I usually do not make resolutions because that seems like you are trying to give up something instead of gaining something.  I would prefer to call them goals that way they can be a list of possible accomplishments instead of potential failures.  For 2012, I decided to record my goals for the New Year and …

Read More “A New Year Means New Resolutions – 2012”

SQL Saturday #80 – Wheeling, WV

I attend SQL Saturday #80 this past weekend in Wheeling, WV.  Many thanks to John Sterrett (Twitter | Blog) for putting a wonderful event.  The event offered us three different tracks with six sessions each. The first two sessions I attend where on PowerShell by Ed Wilson aka the Scripting Guy.  I just recently starting …

Read More “SQL Saturday #80 – Wheeling, WV”

List What Permissions Each Database Role or User Has in a Database

Below is another script I frequently use to list what users or roles have what permissions to tables and views in our database. It basically cursors through the list of objects and stores the results of sp_helprotect in a temp table then displays the results.

List Members in Each Database Role

We receiving have been working with auditors to provide list of SQL logins that exist in each database role defined. Here is a short script to return all the members of each group that can easily be copied into Excel and shared with auditors and anybody else looking for this information. It basically cursors through …

Read More “List Members in Each Database Role”