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

Archives: February 2010

Should DBAs be Paid Overtime?

For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs should be paid for off-hours work? With 259 votes, its very clear (see the graph below) that most DBAs think they should be paid overtime. Unfortunately, this is usually… Read more

31 comments, 2,636 reads

Posted in SQL Aloha on 27 February 2010

Speaking in Cambridge, England March 24, 2010

If you are near Cambridge, England, I will be speaking at the Cambridge SQL Server Users Group on Wednesday, March 24, 2010.

The meeting will be held fro 6:00 PM to 9:00 PM, and I will be spending about 45 minutes discussing “How to Use the SQL Server 2008 Performance… Read more

2 comments, 1,295 reads

Posted in SQL Aloha on 25 February 2010

SQLBits 6 to Be Held in London, April 16, 2010

The upcoming SQLBits 6, to be held Friday, April 16, 2010, will be held at the Church House Conference Centre in Westminster, London, England. This full day, free event will be themed around SQL Server performance and scalability.

Currently, the call for speakers is open, and if you would like… Read more

0 comments, 1,397 reads

Posted in SQL Aloha on 25 February 2010

Where Do You Look on the Internet for SQL Server Jobs?

I recently had a SQL Server DBA write to me that they were going to be laid off, and they asked me if I had any special insight into what are the best websites to look for SQL Server-related jobs. I haven’t looked for a SQL Server job in a… Read more

7 comments, 606 reads

Posted in SQL Aloha on 24 February 2010

Adventures in Webinar Presentations

Over the past several years, I have given 2-3 live web presentations a year, and I have always found them to be an adventure. In other words, there always seems to be one problem or another.

Sometimes the meeting software used is not very cooperative, connection speeds vary (or drop),… Read more

1 comments, 593 reads

Posted in SQL Aloha on 23 February 2010

2010 MVP Summit Held This Week

If you can’t tell what is happening in the above photo, you won’t be alone. Today, at the opening keynote at the 2010 MVP Summit, the audience of nearly 1,400 Microsoft MVPs, from over 70 countries, got to see one of Seattle’s most famous traditions, the Pike Place… Read more

1 comments, 534 reads

Posted in SQL Aloha on 17 February 2010

SQL Server 2005 & 2008 SP Release Dates

Microsoft has announced that Service Pack 2 for SQL Server 2008 will be released in the third quarter of 2010, and that Service Pack 4 for SQL Server 2005 will be released in the fourth quarter of 2010. Find out more here.

Read more

1 comments, 728 reads

Posted in SQL Aloha on 13 February 2010

PASS is Seeking Program Committee Volunteers

The sessions presented at the PASS Community Summit are selected by volunteers from the PASS Program Committee. If you would like to volunteer some of your time to review session abstracts, and help make recommendations as to which sessions will be offered at the PASS 2010 Community Summit, then you… Read more

1 comments, 333 reads

Posted in SQL Aloha on 12 February 2010

Free SQL Server Training Webinar Series

SQLServerCentral.com, PragmaticWorks, and Wrox Press are sponsoring a series of free SQL Server webinars in February. Called the SQL Server 101 Series, the sessions include:

  • Introduction to Managing a SQL Server Database with Jorge Segarra
  • Beginning T-SQL with Patrick LeBlanc
  • The Modern Resume with Steve Jones
  • How…

Read more

2 comments, 840 reads

Posted in SQL Aloha on 12 February 2010

Speaking in Portland, OR and Tumwater, WA the Week of February 8th

I’ll be speaking in Portland, OR and Tumwater, WA the week of February 8th, 2010. The details, and the session descriptions, are below. Hope to see you there.

Oregon SQL Developers User Group

Topic: Introduction to Graphical Execution Plans
Date: Wednesday, February 10, 2010
When: 6:30 PM… Read more

0 comments, 350 reads

Posted in SQL Aloha on 5 February 2010

February Question: What is one of your best practices for making full backups and transactions log backups of your production databases?

Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). If you have more than one best practice you would like to offer, please enter each one as a separate comment. And… Read more

1 comments, 481 reads

Posted in SQL Aloha on 4 February 2010

Searching for Objects or Text Strings Using SQL Search

As a DBA, at one time or another, you will need to quickly find an object within a database, such as a table, view, or stored procedure. In other cases, it is handy to be able to search objects to locate specific text strings. Depending on which version of SQL… Read more

7 comments, 3,606 reads

Posted in SQL Aloha on 4 February 2010

Questions About SQL Server Backups

SQL Server backups are a “funny” topic to talk about. If you are talking with experienced DBAs, the topic of backups rarely surfaces, as this is a fundamental skill most DBAs learn early in their career. On the other hand, there are thousands of part-time, accidental DBAs who are tasked… Read more

0 comments, 730 reads

Posted in SQL Aloha on 3 February 2010