SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2009

SQL Saturday Atlanta Recap

I had a great time at SQL Saturday Atlanta last weekend. I drove from Orlando to Atlanta on Friday with Andy Warren and took advantage of the long ride to talk about PASS, user groups, volunteering, blogging, networking etc. Andy's a great guy to talk shop with because of… Read more

0 comments, 1,522 reads

Posted in Kendal Van Dyke on 29 April 2009

PASS Summit Sessions Submitted

It's official – I've submitted my abstracts for the 2009 PASS Summit and received my confirmation. Now I wait to see if the abstract selection committee decides if I am worthy. As I promised in my interview with Brent Ozar, I'm publishing my submissions for all to see. If… Read more

0 comments, 648 reads

Posted in Kendal Van Dyke on 24 April 2009

Register A Server More Than Once In SSMS

In yesterday's post about using SQL 2008 Express as a Central Management Server I mentioned that you can't register a server more than once in Object Explorer. Technically that's correct, but I meant to say Registered Servers. It turns out that you can register a server more than once in… Read more

0 comments, 535 reads

Posted in Kendal Van Dyke on 21 April 2009

Use SQL 2008 Express As A Central Management Server

I had the chance to catch Brent Ozar's webcast last week on creating a poor man's CMDB. In it he talked at length about the Central Management Server feature in SQL 2008. While I use SSMS 2008 my only SQL 2008 database installs so far are running inside Virtual… Read more

0 comments, 872 reads

Posted in Kendal Van Dyke on 20 April 2009

Full Text Catalog Scripting "Gotcha" in SSMS 2008

With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these features will be removed in a future version of SQL Server but they continue to work for the time being. In some cases, though, arguments for statements are left in… Read more

0 comments, 565 reads

Posted in Kendal Van Dyke on 15 April 2009

Undocumented Trace Flag Improves Performance By Up To 25%

As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware and software shouldn't I get the best possible performance out of it? In that vein, I've shifted my focus in the last few weeks from disk performance to tweaking SQL… Read more

0 comments, 526 reads

Posted in Kendal Van Dyke on 1 April 2009