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
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
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
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
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
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 each server to a central location. After the copy is complete and loops back
In this part of the process, we will set up 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
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 automating processes was Windows 2000, so I forgot
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
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