Tracy Boggiano's SQL Server  Blog Rotating Header Image

Exam 70-458 – Objective 2 – Implement Security

Manage logins and server roles Configure server security (http://msdn.microsoft.com/en-us/library/bb283235.aspx) Secure the SQL Server using Windows Account/SQL Server accounts, server roles Server-Level Roles (http://msdn.microsoft.com/en-us/library/ms188659.aspx) Create log in accounts (http://msdn.microsoft.com/en-us/library/aa337562.aspx) Manage access to the server, SQL Server instance, and databases Database Roles (http://msdn.microsoft.com/en-us/library/ms189121.aspx) Create and maintain user-defined server roles (http://msdn.microsoft.com/en-us/library/ee677627.aspx) Manage certificate logins CREATE LOGIN Example D […]

Exam 70-458 – Objective 1 – Manage Data

Configure and maintain a backup strategy Manage different backup models, including point in time recovery Recovery models (http://technet.microsoft.com/en-us/library/ms189275.aspx) FULL SIMPLE – No point in time recovery BULK-LOGGED – Can recover to last backup, no point in time recovery Should take transaction log backup before and after Protect customer data even if backup media is lost […]

Exam 70-458 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Study Resources

I passed the 70-457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 today.  Next I will be attempting the 70-458, as I study I’ll put my notes and links to relevant materials here.  I hope to take and pass the exam by the end of March 2014. I’ll add links […]

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 […]

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 […]

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

In 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.  After the copy is complete and loops back through each server and […]

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

In 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 start the data collector or counter log on the remote servers for […]

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

I 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 processes was Windows 2000 so I forgot about this tool.  Now I […]

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 […]

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 […]