You are here: Home
SQLSaturday 107 Wrap Up

SQLSaturday 107 Wrap Up

by on April 24, 2012 in Training Events

SQLSaturday 107 – Great Success I was excited to go to SQLSaturday 107 for three main reasons. For one, my SQL Server 2012 AlwaysOn session was picked and I love giving that one. Secondly, Kalen Delaney (blog| @sqlqueen) was giving an all-day precon on SQL Server Execution Plans: Tuning And Management and I just had [...]

Read full story • Comments { 2 }
What Have You Done For Me Lately?

What Have You Done For Me Lately?

by on April 23, 2012 in Training Events, User Group

The blog has been quiet over the Winter, so where have I been lately? Simply put: On the road with the SQL Server community! I’ve been doing a lot in the community lately, as well as having our busiest Winter ever with SQLWatchmen.  So instead of making a bunch of blog posts about what I’ve [...]

Read full story • Comments Off
Attitude of a DBA

Attitude of a DBA

by on October 6, 2011 in Career

Is a DBA just a button clicker? Can a good DBA be replaced by anyone who knows the same technical skills? ‘Supporting the business’ can be a lot more involved. What Does a DBA (Database Administrator) Do Anyway? Some people think a DBA simply Tweets, Facebooks, YouTubes and occasionally checks SQL Server logs. Others think [...]

Read full story • Comments Off

Denali AlwaysOn – Finally, A usable ‘mirror’!

by on September 14, 2011 in SQL Server Presentations, Training Events, User Group

I’ll be presenting at this months SQL Server User Group (UG) meeting of CACTUSS Central (www.cactuss.org) this upcoming Monday 9/19/2011.  The location of the presentation is here.  The abstract is below. Abstract In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not [...]

Read full story • Comments Off

User Group Meeting Location Picked

by on August 12, 2011 in Training Events

Wes Brown and I just had a very nice meeting with the folks at Experis about them sponsoring the CACTUSS User Group by offering a place to meet for the newly formed Central meeting, which I have the privilege to lead. I really like their style. Very nice people and very eager to help the [...]

Read full story • Comments Off
POSSE Formed

POSSE Formed

by on July 21, 2011 in User Group

We just had our formation board meeting for POSSE (sqlposse.com). Wes, Richard and Mike K. met in person since they arrived early to the monthly user group meeting, while I was conferenced in via phone. We did set the initial executive committee in this first meeting: President – Wes Brown Secretary – Richard Heim Treasurer [...]

Read full story • Comments Off
SQL Rally 2011 – Awesome Event

SQL Rally 2011 – Awesome Event

by on May 17, 2011 in Training Events

SQLRally 2011 The Best SQLRally Ever! – Thomas LaRock. (twitter | blog) Overview Came prepared with a brand new twitter account and 1 follower. Spam. Hey, at least I’m popular. Don’t know how to delete them, but not sure that’s a bad thing at this point. I left the conference with about 20 followers so [...]

Read full story • Comments { 10 }
Best Practices for Database Schema Design (Beginners)

Best Practices for Database Schema Design (Beginners)

by on March 28, 2011 in DB Design

In this article, we will discuss a few common design decisions when defining a Schema. We’ll focus on the planning stage. There are many opinions about what is ‘best’. Here we discuss some basic guidelines which may or may not be best for your specific needs. There are two primary ways a database is used. One is Online Transaction Processing (OLTP) and the other is [...]

Read full story • Comments Off

DBCC loginfo, VLFs and SQL2000 and earlier.

by on March 24, 2011 in SQL Server Maintenance, SQL Server Presentations

I was reading Paul Randall and Kimberly Tripp’s discussions about Virtual Log Files (VLFs), found here. DBCC loginfo I found that performing a log backup will cause the active VLF to ‘rotate’ to the first VLF, freeing up the rest of the VLFs for maximum shrinkage. Uh, well, you know what I mean. In SQL [...]

Read full story • Comments Off