Feb 28 2012
What Brings a Good Looking DBA Like You to a Place Like This? You’ve most likely found this post because of one of the following reasons: You’ve got this shiny new server and are thinking about installing SQL Server on it. You’ve been following this series from the beginning (thank you by the way) and [...]
Feb 22 2012
The db_owner Database Role Has a Secret The right solution is not frequently the easiest to implement. Avoiding hyperbole as much as possible I’ll simply say that database security is a very fine example of that adage. It is by far easier to … grant all users in a database membership in the db_owner database [...]
Feb 17 2012
A Little Patience It’s been a long time since I rock and rolled since I addressed this series on common mistakes in SQL Server database administration. When it comes to this topic I’m glad I held off because the recommendations have changed from when I was originally working on this series when it comes to [...]
Sep 28 2010
Details for tonight’s West Michigan SQL Server Users Group Meeting are listed below. Robert Davis of Microsoft will be presenting on Advanced Tuning Techniques. Robert is a Sr. Production DBA and Operations Engineer at Microsoft and has worked with SQL Server for 10+ years. He is a certified Master in SQL Server 2008. Robert is [...]
Aug 9 2010
Anyone who even casually reads this blog knows all about SQL Cruise by now. If not, then there is an every-growing wealth of information about this endeavor that Brent Ozar (Web|Twitter) and I just produced last week. We had an amazing cross-section of cruisers on this first SEA-QL training event: senior-level consultants, experienced DBAs, and the [...]
Aug 6 2010
I’m sitting in the Fort Lauderdale airport with so many thoughts milling through my head over what a success our first ever SQL Cruise has been. I’m doing my best to avoid any boat or water-related puns whatsoever (we’ve heard them all over the last 4 days – trust me.) This will in no way, [...]
Jul 31 2010
Though my official last day at work is August 9th (exit interview, et. al.) My last day doing production work was yesterday. I am tethered to the on-call rotation until noon while my replacement returns from a trip to Italy. What the hell, I’ve never been to Italy! I’ve thought long and hard about how [...]
Jul 27 2010
Tonight is the July meeting for the West Michigan SQL Server Users Group (WMSSUG). Details are below, including information on our speaker this month, none other than Robert B. Davis aka @SQLSoldier! The meeting is being presented virtually so feel free to attend even if you aren’t a member. Robert is a Sr. Production DBA [...]
