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

Archives: May 2010

SQLSaturday #49 Planning Update

Planning for SQLSaturday #49 – Orlando is on-going and going well especially since we have a good head start.  We have our location, Seminole State College - Lake Mary Campus, our date, October 16th, and, at this writing 30+ sessions submitted, which would give use 6 tracks.
I have…

Read more

0 comments, 434 reads

Posted in Wise Man or Wise Guy on 27 May 2010

Adding Space to a Home Server

I got new drives for my Windows Home Server the other day and decided to add some space to the box. I don’t need the space so much as I’d like to be sure that I’m protected with some extra drives.

The first step, obviously, is to shut down the… Read more

2 comments, 968 reads

Posted in The Voice of the DBA on 27 May 2010

The SSIS Data Flow is Like... an Automotive Assembly Line

When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to fall back on automotive metaphors.  No, I'm not a gearhead, and no, it doesn't work every time, but it does seem to be the first thing that pops in my…

Read more

0 comments, 418 reads

Posted in Todd McDermid's Blog on 27 May 2010

Follow Up On My Keynote Survey

Here are the results of the survey, 75% in favor of a non-technical keynote, with a less than stellar sampling of 32 votes!

Thought twtpoll worked pretty well, haven’t compared to others, but very easy to use and I like the automatically tweet at the end reminding you that the…

Read more

2 comments, 574 reads

Posted in SQLAndy on 27 May 2010

Becoming a Part of the SQL Server Twitter Community

There have been tens of thousands of blog posts and articles written about Twitter, and because of this, I have hesitated writing one myself. I have decided to write a short post because of something I overhead at a recent conference I attended. Here is what I overhead, “I’ll start… Read more

2 comments, 687 reads

Posted in SQL Aloha on 27 May 2010

IndyTechFest 2010 a Big Hit

Jesse Liberty,a Developer Community Program Manager for Microsoft, starts off IndyTechFest 2010 with the keynote presentation.

On Saturday, May 22, 2010, over 400 SQL Server, .NET, SharePoint, Silverlight, and Windows Phone professionals gathered together and spent a free day of training at IndyTechFest, sharpening their technical and career skills,… Read more

0 comments, 436 reads

Posted in SQL Aloha on 27 May 2010

North Texas SQL Server User Group Offers Innovative Educational Series

On Thursday, May 20, 2010, I had the opportunity to speak at the North Texas SQL Server Users Group, which is held on the third Thursday of every month at the Microsoft offices in Irving, TX (near Dallas).

The user group is headed up by Sri Sridharan, with help… Read more

0 comments, 438 reads

Posted in SQL Aloha on 27 May 2010

Kalen Delaney Speaking In Denver on June 9, 2010

Well-known SQL Server MVP and author Kalen Delaney (blog) will be speaking  about SQL Server Plan Cache and Recompilation on Wednesday, June 9, 2010 at the Denver Marriot Tech Center on 4900 South Syracuse Street, Denver, CO 80237. The event is free, but you need to register in… Read more

1 comments, 903 reads

Posted in Glenn Berry's SQL Server Performance on 26 May 2010

Connecting to DB2 using SSIS

To start, first download and install the Microsoft OLE DB Provider for DB2. Click here to download. After it is installed I suggest rebooting your machine. In some cases a reboot is not required; however I have encountered problems without rebooting.

Next open an SSIS project and create a new… Read more

2 comments, 6,641 reads

Posted in SQLDownSouth on 26 May 2010

Reporting Services – Building the first report

One of my goals this year was to spend some time learning Reporting Services. Not necessarily do the 10,000 hours to become an expert, but perhaps the 100 hours or so Andy Warren mentioned in his Professional Development presentation.

I’ve done a little getting SSRS installed and running on… Read more

0 comments, 1,997 reads

Posted in The Voice of the DBA on 26 May 2010

SQL Saturday #35 Notes and Observations

First of all, I want to congratulate all the volunteers that made this happen. It was a very well organized event and ran smoothly. I had a great time. It was nice meeting people that I couldn’t have met any other way.


As A Vendor…

The Good:

Ryan Adams… Read more

6 comments, 1,089 reads

Posted in SQL Man of Mystery on 25 May 2010

The Power of Regex in PowerShell

PowerShell is probably banned in MLB as a performance enhancing substance. You won’t find red-blooded American baseball player admitting to knowingly using PowerShell. It doesn’t matter what his coach and former teammates say. “I’m clean.” he’ll say to the public. “I didn’t come to talk about the past.” he’ll say… Read more

0 comments, 653 reads

Posted in Joe Webb on 25 May 2010

Space Used

At long last I am bringing the next installment in this mini-series.  You can find the rest of the articles by perusing the last article I wrote on the topic.  That article was a correction to the TableSpace script about which I had already blogged.

As you will recall, this… Read more

4 comments, 1,325 reads

Posted in SQL RNNR on 25 May 2010

Yesterday's Vermont SQL Server User Group Presentation on Database Mirroring (Official PASS Chapter for Vermont)

To celebrate the Victoria Day Holiday in Canada I drove down to the U.S.A. with 'ol Volvo Wagon (not Smart this time, since 3k of maintenance awaits it today :) to present on Database Mirroring on SQL Server 2008.

Yesterdays’ meeting when well and I met some very interesting people at the Competitive Computing’s… Read more

2 comments, 1,335 reads

Posted in The Database Hive for SQL Server DBAs on 25 May 2010

Time Off, Recharge, Rethink

Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of my last post. Well, in the last few weeks I have been on holiday. Me and the family took a trip to the USA and the Sunshine state to celebrate… Read more

2 comments, 586 reads

Posted in The SQL DBA in the UK on 25 May 2010

Does The Job Matter To You?

Last week I wrote an editorial for SQLServerCentral titled Does The Job Matter To You?, asking how much the type of work mattered – what if you could do something you really wanted to and make the same money?

As usual the comments (90 or so as I write… Read more

1 comments, 512 reads

Posted in SQLAndy on 25 May 2010

SQL Saturday Dallas Top Ten(ish)

So for those of you who attended SQL Saturday Dallas this past weekend, here’s my Top Ten(ish) list from the event:

  • Getting lost in the construction zone on Spring Valley on the way
  • A thousand Quest splat balls
  • Competing with SQL Saturday Portland and Indy Tech Fest on the same…

Read more

2 comments, 581 reads

Posted in Tim Mitchell on 25 May 2010

Quick Audits of Schema Changes

I saw someone post a question recently about tracking down who deleted a stored procedure. I suggested the default trace, and linked to a beginner article on it.

However there was another post that had a better way to track things. In SSMS there’s a report that will help you: Read more

4 comments, 873 reads

Posted in The Voice of the DBA on 25 May 2010

Two Free Training Webcasts Open for Registration

We’ve got two sessions that you (the “we” meaning the fine folks at Quest Software) need to sign up for right away.  The upcoming webcast for Oracle-oriented folks has huge registration numbers.  And I’m sure you’ll learn more than you expected thanks to my fine co-presenters.  Get in while… Read more

2 comments, 573 reads

Posted in Kevin E. Kline on 24 May 2010

It’s Done - SQLSat35

This is a strange feeling.  No frantic deadlines.  No daily conference calls with the team.  No hurried trips to the printers, no sessions to juggle around, no all-day Saturday work days coming up.  My kids recognize me again.  I know what my house looks like in daylight.

More importantly, I… Read more

3 comments, 605 reads

Posted in Tim Mitchell on 24 May 2010

Newer posts

Older posts