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

Archives: January 2011

My Thoughts on the Intel Sandy Bridge Chipset Recall

I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I also had a number of Tweets directed at me (@GlennAlanBerry) and several e-mails from people asking me what I thought about this.

First, I hate to see something like this… Read more

0 comments, 2,161 reads

Posted in Glenn Berry's SQL Server Performance on 31 January 2011

SQL Lunch - Introduction to Change Data Capture

Join me tomorrow for a little CDC.

#47-Introduction to Change Data Capture

Speaker: Patrick LeBlanc

Add To Outlook: Add To Calendar

Meeting URL:  https://www.livemeeting.com/cc/usergroups/join?id=269DRP&role=attend

Date and Time: 2/1/2011 11:30:00 AM CST
BIO: Patrick LeBlanc, SQL Server MVP, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as…

Read more

0 comments, 1,947 reads

Posted in SQLDownSouth on 31 January 2011

Building an Extremely Power Efficient Intel Sandy Bridge Desktop System

Since I have a 3.15Kw grid-tied Solar PV System on the roof of my house in Parker, I pay pretty close attention to my electrical power usage. I try to generate more electricity than I use, because I care about the environment and because I hate my electric company ( Read more

0 comments, 2,122 reads

Posted in Glenn Berry's SQL Server Performance on 31 January 2011

SQL Rally 2011 Voting - Reporting Services Boot Camp


Since SQL Server Reporting Services 2005 came out, I have been working very close within the BIDS environment and every other aspect of Reporting Services to include the architecture. With the many changes that we saw between 2005 and 2008 R2, I have compiled a boot camp style presentation… Read more

0 comments, 1,533 reads

Posted in BrianKMcDonald on 31 January 2011

SQL Saturday #57 – Houston

SQL Saturday #57 was this weekend! Sean and I went, talked, webshow-ed, and then presented a total of SIX sessions!


Sean and I drove down Friday afternoon – only confusing I-35 with I-45 for about an hour, and then diverting back toward Houston.  We really enjoy these trips together,… Read more

0 comments, 1,634 reads

Posted in SQL Awesomesauce on 31 January 2011

Powershell to Automate SQL Compare

A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate creating scripts for all your databases at once. What’s the first thing that popped into my head? Yep, Powershell.

SQL Compare Pro comes with a command line utility that allows… Read more

2 comments, 4,169 reads

Posted in The Scary DBA on 31 January 2011

PASS Update #50-January 2010 Board Meeting

This post is my thoughts on the Board meeting, and my views on related topics. I encourage you to read the minutes (not yet published) as the official documentation.

I flew into Dallas around noon on Wed, catching an early flight so I could get to The Joule hotel and… Read more

1 comments, 1,948 reads

Posted in SQLAndy on 31 January 2011

Presentations Materials From Last Week

Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS chapter.  For both nights the presentations seemed to go fairly well – especially given the e-mail requests for the presentation materials after the events.

PASSMN Meeting

Session: Error Logs… Read more

0 comments, 1,366 reads

Posted in StrateSQL on 31 January 2011

SQLSaturday, Rocky, and a CheeseSteak - Upcoming Event

As you know, the SQLSaturday sensation has exploded all over the nation.  So many events scheduled this year, there is sure to be one somewhere near you!  If you’re not sure, simply check out the PASS sponsored site: http://www.sqlsaturday.com .  If any of you want to vacation… Read more

3 comments, 2,095 reads

Posted in Pearl Knows on 31 January 2011

Microsoft Support Policies for Windows Server and SQL Server

Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack level for Business and Developer products, which include Windows Server and SQL Server. The term “supported service pack level” means that you cannot be on a retired service pack (which… Read more

3 comments, 4,815 reads

Posted in Glenn Berry's SQL Server Performance on 31 January 2011

31 Days of SSIS – Importing Execution Plans (30/31)

31 Days of SSIS

Almost time to wrap up the 31 Days of SSIS.  We are down to just two more posts with today’s post being number thirty.  If you’re behind on this series, check out the introductory post.

This morning’s one day late twenty-ninth post went over… Read more

0 comments, 2,841 reads

Posted in StrateSQL on 31 January 2011

SQL Saturday #57 Slides, Code & Video

This past weekend I spoke at SQL Saturday #57 in Houston, TX.

I want to thank the local PASS chapter HASSUG, the organizers Nancy Wilson (blog | twitter), Jonathan Gardner (blog | twitter), Malik Al-Amin (twitter), the volunteers, the other speakers, and the attendees.… Read more

0 comments, 1,616 reads

Posted in Eric Humphrey on 30 January 2011

31 Days of SSIS – Exporting Execution Plans (29/31)

31 Days of SSIS

A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still coming out.  And if things go right, I’ll be caught up where I need to be by the end of the day.  If you’re behind on this series,… Read more

2 comments, 2,365 reads

Posted in StrateSQL on 30 January 2011

I've been in Alabama

Let me start of by saying I could have taken this picture in Florida. But I didn’t. I was in Alabama. Folks – we’re not helping our stereotype here in the south.

In the meantime I was working with a cool client who is delivering BI  as part of their…

Read more

0 comments, 1,310 reads

Posted in Adam Jorgensen on 30 January 2011

SQL Rally Voting

Hey Everyone – SQL Rally Voting opens today for the BI Track. There are lots of good sessions and at the risk of being self promotional I thought I would share that my Summit spotlight Zero to Cube session was top five in it’s track and the 23rd session overall…

Read more

0 comments, 1,321 reads

Posted in Adam Jorgensen on 30 January 2011

Invest in Yourself

Hey folks. I think we can all agree that there is some really quality training available for free on the web for SQL Server. Many of you take advantage of this but I still get to many clients who have no idea what is out there. This includes even… Read more

1 comments, 1,429 reads

Posted in Adam Jorgensen on 30 January 2011

What...you mean I won...and Thank You.

Well, what a week it’s been. I started my winning blog post for the SQLskills blogging competition by stating that the blog itself was now starting to pay real dividends. And it seems to continue - in a big way - with a free seat at the Dallas Internals event with… Read more

3 comments, 2,092 reads

Posted in measure twice, cut once. on 30 January 2011

SQL Lunch #48 Advanced SSIS Tips & Tricks

I had the privilege of giving a SQL Lunch presentation today.  The slide deck for that can be found here: SSIS Tips & Tricks deck.  The recording can be downloaded at SQLLunch.  I am not sure when it will be available, but when it is I'll see about… Read more

0 comments, 1,860 reads

Posted in SQLRunner on 30 January 2011

Shout out to SQLPeople.Net

I wanted simply give a shout out to Andy Leonard (twitter | blog) for his never ending commitment to the SQL Community.  Take a look at SQLPeople.net and join the community. Read more

0 comments, 1,329 reads

Posted in SQLRunner on 29 January 2011

Silent Install

A few weeks a go I presented at OSQL-D in Portland, OR, and a lot of people ask me if I could send it to them.  I have decided to post the script here.  You could just copy and past the statement into a note pad and save it as… Read more

0 comments, 2,273 reads

Posted in Sopheap Suy on 29 January 2011

Older posts