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
I was very fortunate to have the opportunity to write a book for Joes2Pros on a topic that is very important to me. As database professionals, few things are more important than being able to properly backup and recover our data.
I had put together a presentation for user groups… Read more
The Red Gate SQL in the City US tour begins tomorrow in New York City. If you have not registered for an event in your area then hurry up as seats are limited.
SQL Saturday #167 is just hours away. We have worked hard to get everything setup and in place and hope no details were missed. We have an excellent lineup of speakers, coffee and donuts ordered for the morning, hundreds of bottles of water and soda, large coolers, swag bags packed,… Read more
I was asked to speak at SQL in the City in New York and Austin Texas. I have used many red-gate products in my time as a DBA but was not familiar with SQL Storage Compress until a couple of months ago. I did what any regular DBA would do,… Read more
Is SQL in the City coming to a town near you? The events are being held in New York, Austin, San Francisco, Chicago, Boston and Seattle. If so you need to make sure to register ASAP as seats are filling up quick and seating is… Read more
This past week I was presented with a very unique issue. A call came in with a production issue on a tier one application. Unfortunately it was on a system that utilizes SQL 2000 SP4. Having a rather small toolset to use for support I had to rely on Perfmon,… Read more
I have recently been notified that my neighboring SQL PASS Chapter Atlanta MDF will be sponsoring SQL Saturday 167 in Columbus GA. The Columbus GA SQL Users Group has been dubbed the “Extreme Southwest Atlanta Chapter” by Aaron Nelson (blog, twitter) For the past two years… Read more
WordPress creates a unique link for each of your post. They are broken out with your URL then YYYY / MM / DD then what you are allowed to name your link. This is inconvenient when trying to reference back to yourself. Wouldn’t it be nice to have a shorter… Read more
Today a friend Kevin Edward Kline announced he was joining SQL Sentry. Last week Kevin announced his intent to leave Quest Software which he has been at for over 10 years. Being part of the SQL Community for the past 4 years, Kevin has been a staple of Quest. When… Read more
Working on a recent consulting job, I was asked to explain the difference in throughput, which is, measured in MB/s verses IOPS as I had recommended a storage array that would provide many more IOPS and throughput than what is currently in use.
For this client I had presented the… Read more
I was reading an article over the weekend where the author pointed out that the standard naming convention for SQL Server database files was .MDF for the data file, LDF for the log file and NDF for additional data files. This was good stuff so far, then the author stated… Read more