This summer I had the chance to visit China. My brother and his wife are living in China and teaching English. I spent a little over two weeks in Shanghai, Suzhou and Yancheng. During that time I wrote some detailed updates for family and a few close friends on the…
This year the Summit registration opens at 6PM on Sunday at the Seattle convention center. Last year we had a dozen people hanging out, watching the twitter feed on the big monitor and catching up. All we really needed was a bar and we’d have our own little party…
I regularly visit client sites and review their SQL Server configurations. I come across all kinds of strange settings. I’ve been thinking about a way to aggregate people’s configurations and see what’s common and what’s unique. I used to do that with polls on SQLTeam.com.…
If you’re a member of PASS you can view our FY2011 budget at http://www.sqlpass.org/AboutPASS/Governance.aspx. Our detailed budget is 29 pages long and provides an incredibly detailed snapshot of where our money comes from and how we spend it. I’ve also written a…
Our SQL Saturday in Kansas City [http://www.sqlsaturday.com/53/eventhome.aspx] is coming up on October 2nd. We have over 40 sessions on the schedule. These cover everything from very basic SQL Server administration to database mirroring to professional development topics. If you’re in the area we’…
I regularly move logins between servers. Mostly this is between production and our DR site. I’ve used the code in KB246133 [http://support.microsoft.com/kb/246133] many, many times but it’s pretty limited. I started with that and wrote the script below. * There is a user-defined function…
One of the requests I get on a regular basis is to capture the performance of statement level events. The latest beta [http://www.scalesql.com/cleartrace/ClearTrace.2008.35.zip] has this feature available. If you’re interested in this I’d like to get some feedback. * I handle…
My SQL Server blog reading list is around one hundred blogs. Many people are writing great content and generating lots of page views. I see some of them running Google AdSense [https://www.google.com/adsense/] and trying to make a little money off their traffic. If you want to…
At 1:10AM Sunday morning the main SAN at one of my clients suffered a “partial” failure. Partial means that the SAN was still online and functioning but the LUNs attached to our two main SQL Servers “failed”. Failed means that SQL Server wouldn’t start and the MDF and…
Peter Larsson [http://weblogs.sqlteam.com/peterl/] recently scrubbed his laptop but didn’t bring over his favorites and made a plea for interesting SQL Server related blogs [http://weblogs.sqlteam.com/peterl/archive/2010/02/03/The-impossible-thing-happened.aspx] . My reading list of SQL Server blogs and sites is up…