Monthly Archives: June 2013

The Chocolate Beach: SQL Style

I am humbled and honored to have been selected to present my “Backup Strategies are for Losers” presentation at the inaugural SQL Saturday for Cocoa Beach, Florida.  This is SQL Saturday #231 as well as being the first for the Space Coast SQL Users Group, so please make your way to the chocolate beach on July 27th for a great day of SQL Learning.

You can register here, come on you know you want to hit the beach for the weekend.  There is also a group rate code for the Hilton (SQLP), where the event is being held, that expires tomorrow (June 28th).  You can reserve your room here.  However, I will be staying just down the road at the Courtyard where my wife and I stayed on our wedding night before our honeymoon cruise to the Bahamas.  I look forward to seeing you there.  Enjoy!

The Chocolate Beach courtesy of Space Coast SQL User Group

Are Those Transaction Logs Empty?

Ever wonder what your usage statistics are for your transaction log files without opening each individual one in the SQL Server Management Studio shrink file dialog.  DBCC SQLPERF is a neat little utility that can tell you the size of the log file and the amount of the space occupied by transactions inside the file.

DBCC SQLPERF

DBCC SQLPERF

You can also use this utility to clear the sys.dm_os_wait_stats and sys.dm_os_latch_stats statistics, in such a manner:

DBCC SQLPERF(“sys.dm_os_wait_stats”,CLEAR);

SQL Server Domination Plan: Two Weeks After

A few weeks ago, I let loose a rebel yell and issued a command directive: Death to Oracle!  Then I delivered the death knell as we migrated all of the data to SQL Server over Memorial Day weekend.  Today, I am proud to announce that after two weeks of the Finance SQL Servers being in production, the users are happy and productive.

Most would say that is how it should be, but the Oracle DBAs told me that the users would complain daily.  They were happy to rid themselves of those users and now I know why.

Hopefully I did not jinx myself but it looks like the domination plan is working!

Initiatives

We had a meeting this morning where our Director talked about initiatives and people bringing forth new ideas to help streamline our department.  Therefore, soon I will be bringing forth a new initiative to eliminate Oracle altogether and replace it with SQL Server.  It will ultimately be denied because of the cost involved with the conversion but they will have to discuss it and think about it.  Take that Oracle, SQL Server Global Domination plan is gaining traction.

Enjoy!