Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the recovery models, recovery point objectives and recovery time objectives. What I have found from speaking at many SQL Saturday’s and User Groups is that most DBA’s do not regularly practice… Read more
I have known Tim for a few years now. We have attended numerous events together over the years and… Read more
I as well as many others have a decision to make on who I am voting for the PASS Board of Directors. I haven’t made my mind up completely for all the votes I get to cast but one vote for sure is for Allen Kinsel.
Why is my mind… Read more
I have been working recently in making sure that max memory is configured for the hundred plus database servers I support. In reading numerous books, blog post and attending various talks on memory management people reference the OS memory counter “Available Mbytes” a lot. Various references state that this value… Read more
It was a huge honor to be chosen for the 2013 US tour of SQL in the City. Red Gate put on a phenomenal tour in 2012 hitting 6 major cities. This year they are bringing the event back. This year will bring Red Gate to Pasadena on October 9th,… Read more
<begin soap box rant>
Time and time again I find myself having to email people to remind them about how and when to use BCC when sending out correspondence to a huge group via email.
The main rule of thumb I tell the senders is that if dialog is not… Read more
Recently attempting to install a new three node cluster I ran into a new issue. Once I was able to run a successful “Cluster Validation Check” and chose the option to install a new cluster I received a message “The computer xxx is joined to a cluster”.
My… Read more
In April 0f 2012 I was fortunate enough to be asked to become Linchpin People LLC’s first ever TeamMate. (blog). I was really cool to become part of a great group of guys like Andy Leonard (blog | twitter), Brian Moran (blog | twitter)… Read more
PASS Summit 2013 will be my fifth Summit to attend. I wrote a blog post about how different my fourth Summit experience as from the previous three. Summit 2012 was all about networking and offered my first experience to speak to a crowd. Idera allowed me to present two sessions… Read more
I started this post over a year ago and have just now come back around to finish it. Over the years I have been asked about a few misconceptions about speakers for SQL Saturday’s.
Over the past several years as I have been involved with speaking and organizing SQL Saturday’s.… Read more
I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items that came up that would like to collected is the date that SQL Server was installed on the server. In doing a quick search on where this property would… Read more
Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know that a quick look at perfmon or task manager can tell us of high CPU usage, but what is a good way to quickly look at proper memory usage.
Checking… Read more
On Thursday March 14th (PI Day) in Duluth GA, Audrey Hammonds and Julie Smith will put on a spectacular SSIS training event to benefit the Cloverleaf School of Atlanta.
Both Audrey and Julie are SQL Server MVP’s and have given a countless amount of their time to the SQL… Read more
I have been working with a client recently who purchased a nice top of the line de-duplication backup device in order to synchronize backups between two data centers. This device is very nice in how it will de-duplicate data to reduce storage needs and also compress the data. It will… Read more
In just three months SQL Backup and Recovery has sold nearly 500 copies. I am… Read more
That latest installment of SQL Saturday Atlanta was just announced. On May 18th 2013 SQL Server experts from all over will come together in Atlanta GA for a full day of free training. I have been part of the previous two years SQL Saturday events in Atlanta and have had… Read more
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list I noticed memory pressure on the box and made the recommendationof more memory which was simple to fix. What caught my attention though was that blocking was occurring on a… Read more
I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle Washington and attended the largest Microsoft SQL Server convention in the world. My first year was all about attending sessions and learning new things. Year two was about attending technical… Read more
If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the benefits of Instant File Initialization.
Microsoft does not provide many details around the reasoning why but I would have to assume that since data is encrypted at the page level,… Read more
Many of us know the importance of scripting out our users on a regular bases in order to be able to before DR restores more efficiently. If you are responsible for performing backup and restores or disaster recovery solutions and you do not have a routine to regularly script out… Read more