img by Coba

Results tagged “sql server 2008”

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: , , , , ,

CU4 for SQL Server 2008 RTM Is Out

- by Scott Whigham on March 18, 2009 8:31 AM
First, let's get the acronyms out of the way: "RTM" stands for "Release To Manufacturing" and it is the software as it was originally shipped (no service packs or hotfixes). "CU" is the "Cumulative Update" and this is many hotfixes rolled into a single installer (but not so many that...
0
comments
read postarrow
Tagged As: , ,

New Version of SQL Server 2008 Books Online (January, 2009)

- by Scott Whigham on February 20, 2009 8:31 AM
Just a quick heads-up: Microsoft updated the SQL Server 2008 Books Online for January, 2009. Microsoft has stated that they plan to publish web updates to the SQL Server 2008 Books Online pretty often so watch this site (or MSFT's site) for updates: We plan to publish Web updates to...
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: , ,

Cumulative Update 3 (CU3) for SQL Server 2008 Released

- by Scott Whigham on January 20, 2009 8:09 AM
Quick FYI: Microsoft just released CU3 for SQL Server 2008 yesterday. You can get it here. The version number is 10.00.1787. As always, I suggest you do not upgrade to this CU unless it specifically addresses a known issue you are having or you have been recommended to use this...
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 2008 Video Training - LIVE!

- by Chad Weaver on December 8, 2008 9:37 AM
Over the weekend learnsqlserver2008.com was launched. Currently there is 13 hours of content on the site. Make sure to view the full list of videos here. Stay tuned as Scott will be adding quite a bit of content to the site over the coming weeks. UPDATE: We've moved LearnSqlServer2008.com to...
0
comments
read postarrow
Tagged As: , ,

A new Cumulative Update package for SQL Server 2008 released

- by Scott Whigham on December 8, 2008 8:05 AM
Microsoft released CU2 (Cumulative Update 2) for SQL Server 2008 which contains a multitude of fixes. What's a "Cumulative Update"? Watch this video - Service Packs, Hotfixes, and More: Keeping Your SQL Server 2008 Up to Date Download/request it via KB article 958186 I've been running it in development for...
0
comments
read postarrow
Tagged As: ,

How to Change/View Database Compatibility Levels in SQL Server 2008

- by Scott Whigham on December 4, 2008 9:44 AM
Those of you used to working with SQL Server 2000 are familiar with using the stored procedure sp_dbcmptlevel to view and change the compatibility of a database. That stored proc has been deprecated however and it's replacements are far better!By the way, LearnItFirst has some great SQL Server training classes...
0
comments
read postarrow
Tagged As: , ,
1
authors
scott whigham
grant moyle
chad weaver