Excelent artical about not shrinking MSSQL database data files. on sqlskills
Now, don’t confuse shrinking the transaction log with shrinking data files. Shrinking the log is necessary if your log has grown out of control, or as part of a process to remove excessive VLF fragmentation (see Kimberly’s excellent posts on this here and here). However, shrinking the log should be a rare operation and should not be part of any regular maintenance you perform.
Here are Kev’s links for today
Maintaining high availability of SQL virtual machine
Danielle Ruest and Nelson Ruest, Contributors
Since the release of Hyper-V, Microsoft has continued its commitment to server virtualization by releasing new software products that are optimized for just that. This is the case for SQL Server 2008 among other Microsoft products.
Read More on SQL Server Search
Capturing I/O patterns using Process Monitor
By Edward Elliott,
The single most expensive native operation SQL Server can perform is reading and writing to the disk. While SSD drives have been hailed as the future and fault tolerant ram drives are prohibitively expensive, most of us still use the humble mechanical disk drive to store and retrieve data. Understanding SQL’s I/O patterns can help you design your disk infrastructure and knowing your application’s patterns can help you get the most out of your disks.
In this article I will be show how to measure the quantity and size of I/O requests in each database as well as being able to work out where your I/O’s are hitting and then matching those up with physical tables. To do this we can use the free “Process Monitor” tool and then load the output into SQL Server.
Read more on sqlservercentral
I Found a great project on CodePlex last week. giving a summary of all new SSIS projects this is a great resource for anyone using SSIS
Project Description This is a community project for developing additional tasks and components for SSIS, and identifying other CodePlex projects that do the same. 34 Connection Managers, Tasks, and Components exist on CodePlex – find them here.
http://ssisctc.codeplex.com/Wiki/View.aspx?title=Home
I am just starting to try and do a daily blog with a list of intresting sites so here goes day 1 post
Another encounter with Ubuntu from Aardvark Daily
Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005
Published: April 1, 2005 | Updated : September 1, 2005 http://technet.microsoft.com/en-us/library/cc966395.aspx
Identifying the source of SQL Server login failures (18456 errors)
And a great story from the BBC “Battle of the Smartphone” http://www.bbc.co.uk/blogs/technology/2009/06/battle_of_the_smart_phones.html
AucklandSQL User Group – June meeting
June 18, 2009 04:05 by Dave
Being the DBA
The involuntary DBA role
The previous DBA left and your boss decided you should cover the position. But where do you start? Which questions should you ask? What should you do first? You don’t even know what it is you don’t know. We’ll discuss maintenance, disaster recovery, storage, performance, and monitoring. We’ll touch on many other areas as well so you’ll at least have heard a bit about them and you’ll know to learn more and ask questions on them.
Keeping the business running- Backup & Restore
The Backup and Restore commands are the most important SQL Server commands in a Database Administrators arsenal. But there is more to Backup & Restore than just recovery from a system failure or user error. This session will cover some of the features and option available for not just disaster recovery, but day to day operations.
DBA 101: Common best Practices (with discussion)
As soon as you get into the office in the morning, before you’ve even had your first coffee, you should be thinking about on your routine. This session cover best practices for what DBAs need to do on a day-to-day basis. This is the kind of information you won’t find in most books. It is the kind of information that can only be learned on the job.
via AucklandSQL User Group – June meeting .
