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

Archives: June 2009

Connector Editorial for July 1, 2009

I currently write the editorial for the PASS Connector which is published every two weeks as part of my role on the Board of Directors. I'm cross posting those editorials here as well as to the main PASS blog.

Just as the list issue of the Connector was ready… Read more

0 comments, 1,496 reads

Posted in SQLAndy on 30 June 2009

Querying the Procedural Cache on Canada Day (July 1st)

The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better.  Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver (my original hometown,…

Read more

1 comments, 2,416 reads

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

SSIS - Creating a Deployment Manifest

Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a wizard for installing your packages.  The benefit to using it is the nice user interface that a wizard provides.  The disadvantage of using it is it’s lack of flexibility.  When… Read more

20 comments, 39,317 reads

Posted in Devin Knight on 30 June 2009

Unwired for Days

Today is the first day that I've really had any significant time on the computer over vacation. That probably sounds like it should be the rule, and it does tend to be, but this is the first time in a long time that I've let go of SQLServerCentral for a… Read more

0 comments, 1,356 reads

Posted in The Voice of the DBA on 30 June 2009

Tracking My Goals – Half the Year

I made a series of resolutions in January related to SQLServerCentral. These are things that I wanted to accomplish this year, things to work on, and it’s time to check how I am doing for through the second quarter. I’ve copied the list below and included my updates as of… Read more

0 comments, 1,708 reads

Posted in The Voice of the DBA on 30 June 2009

Featured Blog: Jeremiah Peschka

I met Jeremiah at the PASS Summit last year and since then I’ve looked in on his blog from time to time. He has an interesting mix of content covering his local PASS chapter, SQL, and one of my favorites, his Links of the Week where he aggregates good stuff… Read more

0 comments, 1,662 reads

Posted in SQLAndy on 29 June 2009

Best Thing I Learned at PASS

At the 2003 PASS Summit in Seattle the organization had a "SIG Challenge" that involved developing a database solution to a business problem. They assigned people to teams and allowed us to work on the problem only when sessions weren't occurring, but...(read more)

Read more

0 comments, 1,349 reads

Posted in Allen White on 29 June 2009

SQL Saturday #17 - Abstract Submitted

I was asked to attend SQLSaturday #17 in Baton Rouge, LA. Despite my lack of desire to travel, I've never been to Louisiana (just driven across), the timing is good, and so I submitted an abstract to speak. The organizers had asked Red Gate to send someone, and since I'm… Read more

1 comments, 1,489 reads

Posted in The Voice of the DBA on 29 June 2009

LinkedIn Groups

I’ve written a few posts now about LinkedIn, and for now still find it be the best fit for me as far as a networking tool. If you prefer something else, that works too! But if you’ve decided to use LinkedIn, groups should be a part of your strategy, and… Read more

0 comments, 1,536 reads

Posted in SQLAndy on 28 June 2009

SQLPSX Release 1.6

I completed Release 1.6 of SQLPSX which adds support for SQL Authentication and addresses several issues. SQLPSX consists of 106 functions, 2 cmdlets and 12 scripts for working with SMO, Agent, RMO, SSIS and SQL script files.
Here's an example of using SQL Authentication:
$server = Get-SqlServer 'Z002\SQL2K8' 'sa' 'mypassword'

Read more

0 comments, 1,586 reads

Posted in Chad Miller on 28 June 2009

Presentation materials: Intro to Analysis Services (SSAS)

I did a presentation last week for the Denver SQL Server User Group (www.DenverSQL.org) and the Colorado Springs SQL Server User Group (www.SpringsSQL.org) on Intro to Analysis Services.  The slide deck can be found here: http://www.marcbeacom.com/downloads/IntrotoAnalysisServices.pptx.  Both were short presentations (30 minutes) aimed at getting folks started with… Read more

0 comments, 1,491 reads

Posted in Marc Beacom on 26 June 2009

Incorporating Kids Into Work

I recently attended SQL Saturday #14 in Pensacola and took my daughter along. This was the third presentation she's come with me for, and it worked out OK. She sat up front and flipped slides for me as I'd forgotten my clicker on the trip.

However it wasn't perfect. At… Read more

3 comments, 1,450 reads

Posted in The Voice of the DBA on 26 June 2009

My Favorite Bad Movie

My favorite bad movie is The Master Gunfighter starring Tom Laughlin of Billy Jack fame. It’s a Western, and he’s a gunfighter armed with two 12 shot revolvers (each with two cylinders if you’re interested, quite the idea) and a katana – a samurai sword. What more do you need… Read more

0 comments, 1,477 reads

Posted in SQLAndy on 25 June 2009

Plug for a Cool Catalog

Ran across the Levenger site while researching laptop bags and it’s branded as ‘tools for serious readers’. Some of it perhaps over done, but some of it looks interesting. They’ve got some beautiful pens and while reading about them realized I had never tried a fountain pen, so I wanted… Read more

2 comments, 1,423 reads

Posted in SQLAndy on 25 June 2009

Exceptional DBA Award Entries Must Be In By July 10, 2009

If you have been considering entering yourself in the Exceptional DBA Awards this year, or nominating a DBA you know, don’t procrastinate much longer, as the last date you can enter is July 10, 2009.

I am one of four judges who will be selecting the nominees, and I want… Read more

0 comments, 1,574 reads

Posted in SQL Aloha on 25 June 2009

How to Avoid Database Restore Issues by a Simple Script Edit - A DB Restore Work-around

During the process of applying changes to a production database - let's call it Change Management (pick your ITIL or COBIT method accordingly), we should always go through a thorough testing process on an exact copy and environment too, if possible, of the production database itself.  Straight to the point, there is a… Read more

3 comments, 2,549 reads

Posted in The Database Hive for SQL Server DBAs on 25 June 2009

An Android Update - TMobile G1

I still love my G1, and I got a pleasant surprise recently. I was out at dinner with my wife, and we needed to look something up. So we decided to race, her with her Blackberry Curve (and Verizon), me with my Tmobile G1. The kids were excited, and so… Read more

0 comments, 1,461 reads

Posted in The Voice of the DBA on 25 June 2009

Powershell + SMO Error Handling Tips

Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO coded in any other .NET language. SMO uses an error object's InnerException which can be several layers deep and you must traverse the nested InnerExceptions to get to the detailed…

Read more

0 comments, 1,622 reads

Posted in Chad Miller on 25 June 2009

Why Do I Blog?

It's late, it's been a busy day, so why bother to spend 10 or 15 minutes at night jotting things down?

For me there are a few reasons, but the main one is that it's cathartic. I can unwind a little, let go of things, and sometimes think more clearly.… Read more

2 comments, 1,472 reads

Posted in The Voice of the DBA on 24 June 2009

Dell Mini – The Follow Up

Back in January I posted about purchasing a Dell Mini 9, wanting to see what how it worked and a certain amount of cool factor to it. In the months since the popularity of netbooks has definitely increased (you think my blog caused that?) and I could be wrong,… Read more

1 comments, 1,351 reads

Posted in SQLAndy on 24 June 2009

Older posts