Archive for April, 2010

New on SQLMag – Automating the Startup and Shutdown of Windows Services

Tuesday, April 27th, 2010

I just posted a new blog entry on how I automate the shutdown and startup of Windows services.

Check it out at http://www.sqlmag.com/blogs/tool-time.aspx.  Be sure to let me know what you think and if you have your own unique methods for automating the control of Windows services!

Many thanks,

-Kevin
-Twitter @kekline

Join Me May 19th for 24 Hours of PASS

Monday, April 26th, 2010

Join Us for 24 Hours of SQL Server Training

(with a special focus on SQL Server 2008 R2)

Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!?

The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May 19.

Get an in-depth look at the hottest SQL Server and BI topics, including (but not limited to!) – the new SQL Server 2008 R2, with its business intelligence and data management innovations, and much more.

When does it start? 12:00 GMT (UTC):

New York: 08:00
Chicago: 07:00
San Francisco: 05:00
London: 13:00
Paris: 14:00
Moscow: 16:00
Mumbai: 17:30
Singapore: 20:00
Sydney: 22:00

The roster of phenomenal speakers features many MVPs and top-rated presenters, including Adam MachanicAndy Leonard, Brad McGehee, Brent OzarBrian KnightChuck HeinzelmanDean Richards, Don KielyDon VilenDonald FarmerGlenn BerryGreg LowJacob SebastianJessica MossKevin CoxKevin KlineLouis DavidsonMaciej Pilecki, Peter MyersPeter WardRushabh MehtaSean McCown, Simon SabinThomas Grosher.

Check out all the great SQL Server sessions you can attend for FREE. Share this information with a friend or colleague.

PASS is looking forward to having you join us all for this exceptional event. Please contact us at 24hrs@sqlpass.org with any questions.  You can also find lots of general details at http://www.sqlpass.org/24hours/2010/.

April Omnibus

Wednesday, April 21st, 2010

I freely admit it – I’m a sluggard.  I should be blogging a couple times per week and tweeting in between.  But, for some unknown reason, April has been a tough month to get this in gear.  Hence, I’m putting out an omnibus post to cover all of the stuff I’ve been up to, instead of the one-off’s I usually post when I’ve got something new to mention.

Isn’t it funny how life gets in the way of the stuff we want and intend to do?  As they say – “The road to hell is paved with good intentions”, or was that Detroit?  But I digress.

A New Translation!

I don’t like to toot my own horn.  [sarcasm on] You can tell that I’m completely honest when I say that since I have a couple blogs and a twitter account. [sarcasm off]  But one thing I’m really proud of is how popular SQL in a Nutshell is.  It’s now translated into approximately eight languages, with Russian being the newest language:

I'm even more proud of my lil' girl than that book!

I also had the pleasure of working with another translator and I’m looking forward to having a copy of the book in simplified Chinese soon too!

Lots of Speaking Events Coming!

There will be more details on my Events page soon, but here’s the run down on what’s just around the corner:

I also have three “Pain of the Week” webcasts schedule with Quest over the next couple months, with great co-hosts like Buck Woody and Grant Fritchey.  The sessions aren’t officially scheduled yet, but you can find them here.

Also, a big thanks to the local PASS chapter in Houston for the warm welcome they put out when I spoke there on April 12 and to the fine folks in Chicago for their awesome SQL Saturday on April 17th.

New Articles and Session Recordings

I had a couple new articles come out last month which I either wrote or added commentary too, including Master Data Services could spur SQL Server 2008 R2 migrations appearing at SearchSQLServer.com.

The PASS DBA Virtual Chapter just posted a recording of my session on SQL Server Internals and Architecture.

I made an appearance on Microsoft’s Thrive website as their IT Pro of the Month for March.  I also had the opportunity to work with Steve Wynkoop at his SSWUG.org vConference in March.

And don’t forget about the incredibly popular Quest vConference that Brent, Ari, and I did on troubleshooting and performance tuning using SQL Server DMV’s.  You can get the code samples, download the slides, and rate the presentations at http://questkb.com/live and/or http://www.vconferenceonline.com/shows/spring10/quest/conference/ondemand.asp