Archives: May 2010
SQLSaturday #49 Planning Update
I have…
0 comments, 77 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, 241 reads
Posted in The Voice of the DBA on 27 May 2010
The SSIS Data Flow is Like... an Automotive Assembly Line
0 comments, 75 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…
2 comments, 104 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, 132 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, 110 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, 113 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, 145 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, 1,479 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, 692 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, 191 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, 106 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, 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, 391 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, 132 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, 93 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…
2 comments, 129 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, 232 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, 81 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, 116 reads
Posted in Tim Mitchell on 24 May 2010



Subscribe to latest posts