Tara Kizer Blog

Tara Kizer

SQL Saturday #47 in Phoenix

SQL Saturday is coming to Phoenix, Arizona on February 19th, 2011. I have submitted my session for this event. If my session gets approved, it’ll be the same presentation that I gave recently at SQL Saturday #55. Read more →

What three events brought you here?

Paul Randal recently blogged about three life-changing events that brought him to where he is today. His blog is a very interesting read and idea, and so I bring to you my three events that brought me to where I am today in my technical career as a SQL Server DBA. Read more →

1-click installation for SQL Server 2005 - FineBuild

Has anyone used SQL Server FineBuild before? According to the web site, it "provides 1-click install and best-practice configuration of SQL Server 2005." It doesn't mention anything about clusters though, which is what I'd be interested in as installing SQL Server on a cluster is a bit of a pain. Read more →

Data Types of Parameters and Execution Plans

In a previous blog, I mentioned a performance problem that I've been working on for a few weeks. I can finally say that this issue has been resolved. The problem was that the database server (SQL Server 2005) was running at 95%-100% CPU utilization at all times. Read more →

Microsoft MVP Award

I'm proud to announce that I have received the Microsoft MVP Award for my contributions to the SQL Server community. I'd like to thank Ben Miller from Microsoft for the nomination. Read more →

SQL Server "Katmai"

Microsoft announced yesterday that the new version of SQL Server, code-named "Katmai", will be delivered in 2008. Check this out for information on "Katmai". Legacy Comments Jon 2007-05-11 re: SQL Server "Katmai" Wow we barely got to dig into 2005. Read more →

32-bit/64-bit aliases

We don't use the default port for SQL Server for security reasons, so we usually have to explicitly tell the client how to connect to SQL Server by creating an alias on the client machine. Read more →

Management Studio slowness

We've been having performance problems on a new 64-bit SQL Server 2005 cluster in our test environment. We opened a ticket with Microsoft to assist us with this. After modifying several things, the only thing that was slow was Management Studio. Read more →

Generating SQL Scripts in SQL Server 2005

In SQL Server 2000, you could generate a SQL script easily using the Generate SQL Script wizard. You could get to it from pretty much anywhere from within Enterprise Manager. For instance, you can get to it by right clicking on any object in the database, then selecting All Tasks, and then selecting Generate SQL Script. Read more →