img by Coba

Results tagged “SQL Server 2005”

A Comparison of SQL Server Pricing Through the Years

- by Scott Whigham on November 12, 2009 6:02 AM
Recently Microsoft announced the new SQL Server 2008 R2 pricing and a lot of people wondered, "Why such big price increases?" There are the new "premium" editions - Datacenter and Parallel Data Warehouse - which are priced at more than $50,000 per processor but what caught my eye is the...
0
comments
read postarrow
Tagged As: , , , , ,

How is anyone supposed to know how to use trace flag 4621?

- by Scott Whigham on March 18, 2009 1:33 PM
I'm helping a client work through some TokenAndPermUserStore performance issues and we're investigating using the new trace flag 4621 that was introduced in Service Pack 3 for SQL Server 2005. Oh wow is this not easy stuff to wade through... Here's a little background: in SQL Server 2005, there is...
0
comments
read postarrow
Tagged As: , ,

Help! I added a new column to a table and my view is not showing this new column (with explanation and resolution)

- by Scott Whigham on January 29, 2009 11:37 AM
It happens to me once a year at a minimum: I forget that, if I add a new column to a table, I must refresh my views otherwise I will not see that column in my views. Maybe you haven't seen this - if not, you might want to follow...
0
comments
read postarrow
Tagged As: , ,

System Views Map for SQL Server 2008 is Out

- by Scott Whigham on January 29, 2009 7:01 AM
I remember when the first SQL Server 2000 System Tables poster came out in SQL Server magazine - I was so thrilled. I studied that map like crazy and, in doing so, I became more knowledgeable about both the product and how to design systems. These days, the maps are...
0
comments
read postarrow
Tagged As: , ,

A SQL Server Security Hole “Could Allow Remote Code Execution”

- by Scott Whigham on December 23, 2008 6:36 AM
The skinny: apparently back in April, SEC Consult notified the MSFT team of a vulnerability in the sp_replwritetovarbin system stored procedure. Microsoft has thus far declined to create a patch and so, for whatever reason, SEC Consult decided to release the vulnerability publicly. You can view the scripts to reproduce...
0
comments
read postarrow
Tagged As: , ,

CU1 for SQL Server 2005 SP3 Already Out!

- by Scott Whigham on December 21, 2008 4:38 PM
FIVE days after the release of SP3 we already have CU1. Give me a break... Timeline is simple: Dec 15: SP3 released. Dec 20: CU1 released. I haven't installed it but what do you want to bet that CU1 requires me to stop/restart my SQL Server?! Argggghhhhhh. This follows on...
0
comments
read postarrow
Tagged As: , , ,

Recommendations For Using the SQL Server 2005 Best Practices Analyzer

- by Scott Whigham on December 19, 2008 8:47 AM
The SQL 2005 BPA can be found here: SQL Server 2005 Best Practices Analyzer Do: Take full, differential, and/or log backups (whichever is appropriate) before running the analyzer (so you don't get warnings/information messages that clutter the report) Prior to running the BPA, run DBCC CHECKDB commands on your DBs...
0
comments
read postarrow
Tagged As: , ,

Should you install SQL Server 2005 Service Pack 3? Not so fast...

- by Scott Whigham on December 18, 2008 5:55 AM
I just read an interesting piece over on Aaron Bertrand's blog about how the overlap of Cumulative Updates 10 and 11 (CU 10 and CU 11) overlap with Service Pack 3. It's a good read - check it out here....
0
comments
read postarrow
Tagged As: , ,

Good bookmark: How the SQL Server developers update SQL Server

- by Scott Whigham on December 16, 2008 3:55 PM
Here's a good read: How the SQL Server team releases updates. Okay - so that's not the official title (the official title is the overly officious An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems) but I think my title is something...
0
comments
read postarrow
Tagged As: , ,

SQL Server 2005 Service Pack 3 Is Out

- by Scott Whigham on December 16, 2008 12:47 PM
It's here, it's here! The new phonebook service pack is here! Now before you run out and patch all of your SQL Servers, repeat after me: I will not install brand new service packs and patches on important systems I will not install brand new service packs and patches on...
0
comments
read postarrow
Tagged As: ,

How to Speed up SQL Server Management Studio in SQL Server 2005

- by Scott Whigham on December 11, 2008 8:31 AM
Have you ever launched SQL Server Management Studio (SSMS) and had to wait over 60 seconds before you could even login? I have - all too often! It's annoying - and thankfully there's an easy fix. Launch Internet Explorer Browse to Tools -> Internet options -> Advanced tab Uncheck the...
0
comments
read postarrow
Tagged As: , , ,

How to slipstream SQL Server 2005's Books Online Update

- by Scott Whigham on December 10, 2008 6:34 AM
Delete the original ...\SQL Server x86\Tools\Setup\SqlServer2K5_BOL.msi Rename the downloaded SqlServer2K5_BOL_Jul2006_v2.msi (or whatever the latest version is) to SqlServer2K5_BOL.msi and copy it to the ...\SQL Server x86\Tools\Setup folder. Run setup. Thanks to John Paul Cook, a SQL Server MVP out of Houston, TX, for pointing this out. John Paul Cook...
0
comments
read postarrow
Tagged As: , , ,

SQL Server 2005 Peer-to-Peer Replication (A peek inside Microsoft)

- by Scott Whigham on December 10, 2008 6:32 AM
Peer to Peer Replication made its SQL Server debut in SQL Server 2005 and just got even stronger in 2008. I found an interesting article recently that talks about how MSFT uses peer-to-peer internally and thought I would share: http://www.microsoft.com/technet/technetmag/issues/2006/07/InsideMSFT/default.aspx. It talks about how Peer-to-Peer replication with SQL Server 2005...
0
comments
read postarrow
Tagged As: , , ,
1
authors
scott whigham
grant moyle
chad weaver