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

Archives: November 2011

DBA in Space: Behind the Scenes—Question 8

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

This is a continuation of my DBA in Space journal.

Episode eight is another Friday task-related question. On the previous Fridays, I wasn’t involved in any of the scenes. But on this Friday I… Read more

0 comments, 841 reads

Posted in SQL Aloha on 30 November 2011

SQLServerCentral.com Track to be Offered at 2012 SQL Server Connections in Las Vegas this Spring

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, 425 reads

Posted in SQL Aloha on 29 November 2011

DBA in Space: Behind the Scenes—Question 7

This is a continuation of my DBA in Space journal.

Episode seven is filmed at the “Animals in Space” exhibit at the Roddenberry Launch center, and alien Brad is becoming more comfortable in his human skin, although he thinks he is better than he really is as he impersonates the… Read more

0 comments, 298 reads

Posted in SQL Aloha on 29 November 2011

DBA in Space Spoof Interview and Review

If you are a DBA in Space fan, and in case you missed them, there have been two items published on Simple-Talk.com that you may be interested in reading.

The first is “Stars of the DBA in Space Webisodes Revealed”. This is a spoof interview where Miss Friday… Read more

0 comments, 315 reads

Posted in SQL Aloha on 28 November 2011

DBA in Space: Behind the Scenes—Question 6

This is a continuation of my DBA in Space journal.

Episode six is filmed at the “Visions of the Future Exhibit” at the Roddenberry Launch center, and it is time for another question for the DBA in Space Competition, so Miss Friday and alien Brad are ready to offer up… Read more

0 comments, 443 reads

Posted in SQL Aloha on 28 November 2011

DBA in Space: Behind the Scenes—Question 5

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

This is a continuation of my DBA in Space journal.

Episode five (the longest of all the episodes) aired on a Friday, so that means it’s time for another task-related question from Miss Friday.… Read more

0 comments, 326 reads

Posted in SQL Aloha on 23 November 2011

DBA in Space: Behind the Scenes—Question 4

This is a continuation of my DBA in Space journal.

With each episode, DBA in Space becomes goofier and goofier. Episode four is also set at the “History of Computing Exhibition”, as the previous episode, but from a slightly different angle. At the right side of the screen you can… Read more

0 comments, 258 reads

Posted in SQL Aloha on 22 November 2011

DBA in Space: Behind the Scenes—Questions 2 & 3

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

This is a continuation of my DBA in Space journal.

In this blog post I am going to talk about filming questions two and three.

Filming Question Two of DBA in Space

Question two… Read more

0 comments, 289 reads

Posted in SQL Aloha on 21 November 2011

DBA in Space: Behind the Scenes—Question 1

This is a continuation of my DBA in Space journal.

In the opening of the first episode of DBA in Space, I am playing myself, or at least a future self, as I am talking from the Roddenberry Launch Center. I introduce myself first, and then the launch center’s mascot,… Read more

0 comments, 351 reads

Posted in SQL Aloha on 18 November 2011

DBA in Space: Behind the Scenes—The Trailer

This is a continuation of my DBA in Space journal.

In this next series of blog posts, I am going to change the format somewhat. In my previous posts, I wrote chronologically, as it made the most sense. As is common in film or video production, filming is generally done… Read more

0 comments, 389 reads

Posted in SQL Aloha on 17 November 2011

DBA in Space: Behind the Scenes Part 3

This is a continuation of my DBA in Space journal.

 

Friday, September 16, 2011

OMG. (This is the first time in my life that I have ever used OMG, so you must know how overwhelmed I felt.) What have I gotten myself into? I got to sleep in late… Read more

0 comments, 409 reads

Posted in SQL Aloha on 16 November 2011

DBA in Space: Behind the Scenes Part 2

This is a continuation of my DBA in Space journal.

 

 

Monday & Tuesday, September 12-13, 2011

Today I make my “secret” journey to England for the filming. While I explained to my family where I was going, and what I would be up to, they were given specific… Read more

0 comments, 236 reads

Posted in SQL Aloha on 15 November 2011

Do You Use “Forced Parameterization”?

In SQL Server 2005 and later, there is a database option called “forced parameterization”. When it is turned on, it overrides the default “simple parameterization” normally used by SQL Server. It does this by forcing most SELECT, INSERT, UPDATE, and DELETE statements to be parameterized, potentially boosting performance of databases… Read more

0 comments, 515 reads

Posted in SQL Aloha on 14 November 2011

DBA in Space: Behind the Scenes Part 1

The DBA in Space contest ends November 18, 2011. If you haven’t entered yet, you still have time.

 

Filming DBA in Space was both a great opportunity and an adventure for me. It allowed me to break out of my comfort zone and do something few people have the… Read more

0 comments, 357 reads

Posted in SQL Aloha on 14 November 2011

Recording SQL Server Configuration Settings.

(I’m ‘standing in for Brad, who is busy ..er.. somewhere, and I found this unpublished piece by Brad and I. I have no idea what the diagram at the end means, but he seemed to feel it was important
Phil Factor)

Server Configuration Settings

SQL Server has about 70… Read more

1 comments, 747 reads

Posted in SQL Aloha on 3 November 2011

November Question: What is your favorite, and not so favorite hardware to run SQL Server on?

Selecting which hardware to run SQL Server on is often discussed among DBAs. So, for this month’s question, “What is your favorite, and not so favorite hardware to run SQL Server on?”, tell us about the hardware you love, the hardware you hate, and why.

Also, get your free copy Read more

0 comments, 308 reads

Posted in SQL Aloha on 1 November 2011