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

Archives: October 2009

Blogging From the 2009 PASS Community Summit

Like a lot of other SQL Server bloggers, this week I will attempt to write regular blog entries each day, and hopefully include some photographs of the activities I attend. I am not an “official” PASS blogger, but I will try and offer my perspective of the event, with my… Read more

2 comments, 1,361 reads

Posted in SQL Aloha on 31 October 2009

Not Attending/Presenting at SQL Connections

Given everything that has happened in the last couple of weeks, this is not surprising to those who have kept up with my family's most recent struggle. I had one more big decision to make from a professional side of things and that was whether or not to still attend… Read more

1 comments, 1,359 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 31 October 2009

The Gift Count

I went by Best Buy this afternoon, with my updated budget, to grab 2 last gifts and blow out the money. We’re now at 65 gifts, according to my daughter’s count. Lots of DVDs and books, but I’ve added in a few nicer things that we’ll randomly give away:

  • A…

Read more

1 comments, 1,422 reads

Posted in The Voice of the DBA on 31 October 2009

SQL Server 2008 cluster install and slipstreaming!

I was asked to set up a SQL Server 2008 cluster on Windows 2008 R2 this past week. One interesting issue I ran into was that only SQL 2008 SP1 is supported on Win 2008 RW. In that past, that meant that you could just do the SQL cluster install… Read more

0 comments, 2,076 reads

Posted in Advice from Aunt Kathi on 31 October 2009

PASS Officers for 2010-2011 Announced

Posted yesterday at http://www.sqlpass.org/Community/PASSBlog/articleType/ArticleView/articleId/118.aspx, Rushabh Mehta is the incoming President, Bill Graziano is the VP Finance, and Rick Heiges is the VP of Marketing.

Congratulations to all! Read more

0 comments, 1,403 reads

Posted in SQLAndy on 31 October 2009

When Technical Support Fails You – UPDATE and Answers!

As promised and update on what has happened so far. A correction needs to be made. the P800 is a PCIe 1.0 card so the bandwidth is cut in half from 4GB/sec to 2GB/sec.

My CDW rep did get me in contact with an HP technical rep who actually knew… Read more

0 comments, 1,704 reads

Posted in SQL Man of Mystery on 31 October 2009

Consider this while doing any UPDATE


When you create trigger for insert and delete we will get two reference table as “inserted” and “deleted” respectively now what if we create a trigger for “update” on trigger, your answer might be  we will get reference table “updated” :-) …. NO their is no updated table in… Read more

0 comments, 1,466 reads

Posted in Vinay Thakur on 30 October 2009

More PASS Activities

As if I needed more.

I’ll be sitting at the blogger table and blogging live (as live as I get) during the keynotes. It should be fun. As I said on Twitter, this means I get to pick on the cool kids. Life is good.

Thursday I’ll be doing a…

Read more

0 comments, 1,368 reads

Posted in The Scary DBA on 30 October 2009

Happy Halloween to the DBA - Pumpkin Carving as a Team Building Exercise


The past couple of days we have had some fun with a Team Building exercise by means of designing our Pumpkin for an internal competition between teams.  Unfortunately we did not win anything, nor even make the top three, but we certainly did have some fun – and… Read more

0 comments, 2,041 reads

Posted in The Database Hive for SQL Server DBAs on 30 October 2009

Heading back to Seattle

I love visiting Seattle, even in November. Getting to catch up with old friends and meet new people is always the highlight of my trip. Don’t get me wrong, the training is awesome and I always learn so much, but I am a social creature. I can always go to… Read more

4 comments, 1,437 reads

Posted in SQL Man of Mystery on 30 October 2009

When Technical Support Fails You

I have had the pleasure of being a vendor, and technical support for both hardware and software products. I know it isn’t easy. I know it isn’t always possible to fix everything. The level of support I’ve received from HP on my current issue is just unacceptable. This is made… Read more

0 comments, 1,485 reads

Posted in SQL Man of Mystery on 30 October 2009

Twitter SQLBingo at the PASS Community Summit

Who are the people in your SQL neighborhood?

Stuart Ainsworth (Blog, Twitter), Brent Ozar (Blog, Twitter), and some other really bright and creative folks in the SQL Community have gotten together to create what’s sure to be a great networking game at the upcoming…

Read more

0 comments, 1,416 reads

Posted in Joe Webb on 30 October 2009

MCTS: Business Intelligence Developer 2008 & MCITP: Business Intelligence Developer 2008


I am not about to get into a theoretical discussion of whether certifications will benefit you in your career. I am a firm believer that this follows the rule of “it depends”. However if you’re a professional in a field, whether plumbing or technology, certification is a good way… Read more

1 comments, 1,423 reads

Posted in Adam Jorgensen on 30 October 2009

OFF-TOPIC: God is Still Good, Even as We Mourn

Kimberly and I went to the high risk doctor's office this morning for the ultrasound. Unfortunately, they realized very quickly that both children had passed away. There was no heartbeat. They suspect Twin-to-Twin Transfusion syndrome. We are in mourning and have begun the procedures to ensure Kimberly's health. Support from… Read more

Fun in Seattle

I know there are a number of people heading to Seattle this weekend for the PASS Summit next week. I am coming in on Monday, leaving Fri, and pretty much stuck with work all week.

However I know some of you are going to be in town early or late,… Read more

6 comments, 1,596 reads

Posted in The Voice of the DBA on 30 October 2009

Running to the PASS Summit

Well, not literally. I’m not going to run to Seattle from Denver, but I’ll be running at the Summit.

Last year when the Summit took place, I was about 70 days into my running streak. I was worried about keeping it going at the Summit since it’s a busy week… Read more

1 comments, 1,499 reads

Posted in The Voice of the DBA on 30 October 2009

PASS Presentation Rehearsal

My friend Trevor Barkhouse called me up a couple of nights ago and asked if I could host a Live Meeting Rehearsal of his PASS Presentation.  Is that a question, of course I can.  So if you have some time this morning join in a for a sneak peek.  The… Read more

1 comments, 1,549 reads

Posted in SQLDownSouth on 30 October 2009

SQL University: Multiple Paths and Ownership Chaining

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus, you should be picking up history next week with Jorge Segarra. SQL Server has a rich history. I know you'll enjoy the coming week. However, before we move on,… Read more

1 comments, 2,488 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 October 2009

Diners, Drive-Ins, and Dives – In Seattle

If you’re going to spend 3-5 days in Seattle at the PASS Summit it’s worth sampling the local food rather than sticking with the ‘safe’ chain choices. I enjoy Diners, Drive-In’s, and Dives on the Food Network, so I grabbed the list of restaurants they had featured from Seattle. Haven’t… Read more

2 comments, 1,727 reads

Posted in SQLAndy on 29 October 2009

Suggested Max Memory Settings for SQL Server 2005/2008

It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subject to signals from the operating system that it is under memory pressure). This…

Read more

74 comments, 239,861 reads

Posted in Glenn Berry's SQL Server Performance on 29 October 2009

Older posts