|
|
|
|
The random ramblings and rantings of frazzled SQL Server DBA
May 2009 - Posts
-
This blog post by James Rowland Jones on a specific type of deadlock is so interesting that I have to share the link to it. Not only so other people read it, but in case I ever need to find it again in a pinch, I can easily find it on this post. Read More...
|
-
This one is from the MSDN Forums on a post titled DDL trigger limitations . Basically the problem in a nutshell is that an application is harvesting information from the Internet and storing it in SQL Server on what appears to be a timed schedule. Read More...
|
-
At the beginning of the year, I wrote an article titled Retrieving Deadlock Graphs with SQL Server 2008 Extended Events that detailed how to use the default system_health session to retrieve deadlock graphs from SQL Server 2008 without having to use SQL Read More...
|
-
Extended Events are with out a doubt, my personal favorite amongst the new features in SQL Server 2008. Today my first whitepaper was published on the Microsoft web site as a part of the SQL Server 2008 Whitepaper's. Using SQL Server 2008 Extended Read More...
|
-
Today I presented a Live Meeting session for the PASS DBA Special Interest Group on the Default Trace. A big thank you to everyone who attended. The presentation slide deck and TSQL scripts from the presentation are attached to this blog post. If you Read More...
|
-
I'll be doing a live meeting event for the PASS DBA Special Interest Group on Wednesday, May 27th at 12pm EST. The session will cover the default trace in SQL Server 2005 and 2008, what information is contained in the default trace, how to query Read More...
|
-
Bob Ward blogged about this on the Customer Support Services blog this morning: SQL Server Support Policy for Failover Clustering and Virtualization gets an update… Essentially you can now run SQL Server 2005 and 2008 in a Virtualized Failover Cluster Read More...
|
-
This is a place holder for updates regarding Extended Events for linking to in the whitepaper being published on MSDN. It will contain current problems, bugs, and connect feedbacks as well as known workarounds for existing issues. As written in the whitepaper, Read More...
|
-
There are already quite a few Addin's for SQL Server Management Studio online, most are free or donation like the SSMS Tools Pack , Allocation SQL Server Management Studio Add-in , or the SSMS Addins on Codeplex. Today I got an alert from Google Read More...
|
-
Just for starters, I don't need a primer on how shrinking a database is bad, or why I shouldn't be doing it. Trust me, I understand the implications of shrinking databases, why it shouldn't be done, and I explain this to people online all the time. That Read More...
|
-
A new whitepaper was released yesterday on Disk Alignment, an often overlooked aspect of properly configuring your hardware for SQL Server performance. You can find the whitepaper and additional information about it on the SQLCAT blog: http://sqlcat.com/whitepapers/archive/2009/05/11/disk-partition-alignment-best-practices-for-sql-server.asp Read More...
|
-
As a preface to actually writing the meat of what this blog post is about, I have to admit that I am not a fan of using triggers in general, and I am even less of a fan of having SQL CLR Triggers in all but the most obscure of scenario, but that is just Read More...
|
-
While I was gone, I was tagged by a number of the chain Quizes that have been going around the SQL Server Community, so I am working to answer each of them as I get around to it. Aaron Alton tagged me for this one, and it is actually one that I Read More...
|
-
I never knew this until I read a forums post today, but Maintenance Plans have owners in SQL Server. Beyond that, there is no way to change who the owner of a Maintenance Plan is in SQL Server Management Studio. Generally speaking when a DBA Read More...
|
|
|
|
|
|