Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Excerpt from Upcoming Book by Grant Fritchey Called Learn “SQL Server in a Month of Lunches”

Later this year, a new book by author Grant Fritchey, called Learn SQL Server in a Month of Lunches, will be released by Manning Publications. Below is a preliminary excerpt from the book on “Creating a Full Backup”. The book is geared toward readers new to SQL Server.

Read more

1 comments, 700 reads

Posted in SQL Aloha on 15 February 2012

February Question: If you weren’t a DBA, what would you like to do?

Sometimes its fun to think of what career you might have chosen if you hadn’t become a DBA. With this in mind, this month’s qustion is “If you weren’t a DBA, what would you like to do?” Tell us what careers you considered before becoming a DBA, including any crazy… Read more

8 comments, 434 reads

Posted in SQL Aloha on 1 February 2012

DevConnections Offers DBAs Many Options for Training

As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections (a part of the greater DevConnections event) in Las Vegas, NV, on March 26-29, at the MGM Grand Hotel. This is in addition to the SQL Server tracks that are… Read more

0 comments, 1,386 reads

Posted in SQL Aloha on 31 January 2012

DBAs and the Career-Life Balance

Reprinted from my editorial in Database Weekly.

I know a lot of DBAs who make SQL Server the focus of their life. In many ways, if you want to be an exceptional DBA, and stand out from the crowd, you don’t have a lot of choice about devoting a… Read more

4 comments, 533 reads

Posted in SQL Aloha on 20 January 2012

What’s Wrong with this Picture: A Database Misconfiguration Well Demonstrated

Recently, I was doing some testing/playing around on a particular database on my home test servers. After I was done, I checked out the “Data/Log Files Autogrowth/Autoshrink” portion of the “Disk Usage” report for the database, which is shown below.

While I might expect to see results like this… Read more

8 comments, 440 reads

Posted in SQL Aloha on 6 January 2012

Have You Planned Which SQL Server Events You Will be Attending in 2012?

2012 is already upon us and I have been busy working on my travel schedule for this year. It is still incomplete, but I have many events scheduled, and I am leaving room for some additional events as they are announced.

So how about you, have your scheduled the training… Read more

1 comments, 317 reads

Posted in SQL Aloha on 4 January 2012

January Question: What feature(s) of SQL Server would you like to learn more about?

Although SQL Server 2012 coming out this year, I think some of us are still trying to catch up with all the new features introduced in SQL Server 2008. SQL Server has become so feature-laden, I think it is becoming harder and harder to keep up. With this in mind,… Read more

8 comments, 456 reads

Posted in SQL Aloha on 4 January 2012

Does the Role of the DBA Need to Evolve?

This editorial was originally published in Database Weekly.

The November 2011 edition of Popular Science magazine was devoted to data. In fact, the special issue was called “Data is Power: How Information is Driving the Future”. The focus of the issue was how we can use data to transform… Read more

0 comments, 533 reads

Posted in SQL Aloha on 14 December 2011

DBA in Space: Behind the Scenes—Question 14

Part 1 of Question 14—The question.
Part 2 of Question 14—The follow up to the question.

This is a continuation of my DBA in Space journal.

As the previous episode was the climax, this final episode is the denouement of the series. It starts out with the real Brad welcoming… Read more

0 comments, 337 reads

Posted in SQL Aloha on 8 December 2011

The Day-to-Day Tasks of the Average DBA

DBAs (Database Administrators) perform many different tasks, and one way to explain what a DBA is, is to describe the kinds of tasks they perform on a regular basis. The following lists some of the most common tasks performed by the average DBA, from A to Z.

Auditing

An emerging… Read more

0 comments, 1,063 reads

Posted in SQL Aloha on 8 December 2011

DBA in Space: Behind the Scenes—Question 13

Part 1 of Question 13: The Question.
Part 2 of Question 13: The follow up to the question.

This is a continuation of my DBA in Space journal.

While there are fourteen episodes, this episode was the climax of the two subplots. It was also a complex episode with many… Read more

0 comments, 299 reads

Posted in SQL Aloha on 7 December 2011

A DBA is a Data Professional

By Grant Fritchey
http://www.scarydba.com/

A DBA (Database Administrator) is a Data Professional tasked with managing an organization’s data using some sort of database software, such as Microsoft SQL Server. They are concerned with gathering, storing and presenting data to data consumers, which includes virtually anyone in the modern world. For… Read more

0 comments, 1,657 reads

Posted in SQL Aloha on 7 December 2011

Meet the DBA in Space Judges

Judging any contest is difficult, as you want to be as fair as possible. So coming up with the final 15 contestants for the DBA in Space competition was not an easy job for the judges. But as you have probably already learned today, they have made their decision, and… Read more

0 comments, 246 reads

Posted in SQL Aloha on 6 December 2011

The Final 15 Revealed: DBA in Space

Today, the final 15 competitors were announced at the DBA in Space website. To get into the final 15, the contestants first had to successfully answer all 14 tasks and questions from the competition, and then submit what would be their first Tweet from space. According to the rules, the… Read more

1 comments, 406 reads

Posted in SQL Aloha on 6 December 2011

DBA in Space: Behind the Scenes—Question 12

This is a continuation of my DBA in Space journal.

As this scene starts on Lunar Exhibition set, Miss Friday is nowhere to be found, and alien Brad asks question twelve of the competition. As you can see, alien Brad really looks bad. His face is completely covered with boils,… Read more

0 comments, 190 reads

Posted in SQL Aloha on 6 December 2011

What is a DBA?

The voting for Red Gate Software’s DBA in Space Contest is to begin on Tuesday, December 6, after the final 15 are announced, and anyone is allowed to vote once a day for their favorite candidate. In many cases, non-DBAs will be voting, so we thought this would be a…

Read more

0 comments, 277 reads

Posted in SQL Aloha on 6 December 2011

DBA in Space: Behind the Scenes—Question 11

Part 1 of Question 11—The Question.
Part 2 of Question 11:The follow up to the question.

This is a continuation of my DBA in Space journal.

This was a Friday task-related question and involves two key scenes. First, in what appears to be a video from a dead Miss Friday… Read more

1 comments, 335 reads

Posted in SQL Aloha on 5 December 2011

DBA in Space: Behind the Scenes—Question 10

This is a continuation of my DBA in Space journal.

Alien Brad is not looking very well (more boils), or very happy (there are tears on his face if you look closely). This is because he realizes that he has been “outed” by Miss Friday, and because of this, probably… Read more

1 comments, 423 reads

Posted in SQL Aloha on 2 December 2011

DBA in Space: Behind the Scenes—Question 9

This is a continuation of my DBA in Space journal.

Episode nine was filmed in the “Mars” exhibit. In this scene, alien Brad is feeling very homesick. Miss Friday starts the scene talking about the Mar Rovers, and alien Brad makes a bad joke about rovers breaking Martian traffic laws.… Read more

0 comments, 337 reads

Posted in SQL Aloha on 1 December 2011

December Question: When reflecting on this year, what has gone well, and what would you do differently?

December is the last month of the year, and is often a good time to reflect on the past year and think about the upcoming year. So, for this month’s question, “When reflecting on this year, what has gone well, and what would you do differently?”, tell us what went… Read more

0 comments, 751 reads

Posted in SQL Aloha on 1 December 2011

Newer posts

Older posts