Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Upgrades

The Plan for Evaluating a New Release

SQL Server 2008 R2 is now out, and you can get the "Customer Technical Preview" or CTP here: http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx But it seems like SQL Server 2008 just came out! I'm still installing and upgrading it on the systems

Should I stay or Should I Go?

I'm writing this post on a bus headed towards the Seattle Convention Center, where the technical folks in the field meet once a year to hear from the product teams about all the new features coming in the future. I used to present at this conference (and

ODBC Drivers Are Updated in Windows 7

One of the first exposures I had to an ODBC driver was NOT a good one - the particular behavior for ANSI NULLS ended up causing some issues in a database application that I had inherited, so I tend to keep my eye on these things. Mind you, it was back

SQL Server 2008 SP1 is Now Available

SQL Server 2008 Service Pack 1 is now available for download at the following location: http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displayLang=en As always, read the release notes before you install

Migrations and ROI

We've had a lot of folks switching to SQL Server from other platforms lately. They start looking at SQL Server because many of the other vendors are prohibitively expensive, and they also charge for things that come with SQL Server out of the box, like

Versioning the Database

If you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entire

Which Edition is Right for Me?

I had a discussion the other day with someone who had some questions about Enterprise Edition of SQL Server 2008. In many cases, I've seen someone not using the "right size" of SQL Server. Many installations really call for Enterprise Edition

SQL Server 2005 SP2 Gains CEC EAL4+

No, that's not a mis-print - it's SQL Server 2005 SP2 I'm talking about. This criteria is increadibly exacting, and takes a huge investment in time and money from a company (like us) to reach. If you're in an installation that requires this type of certification,

CU1 for SQL Server 2008 is now Available!

Many people wait for the “first” service pack of a product to work with it. Well, the CU#1 for SQL Server 2008 is now available. This is a new service model where we get out fixes far faster than a full Service Pack. You should read the article

A move with a view

With new features, there are new things to consider when you’re moving from SQL Server Edition to SQL Server Edition. For instance, certain database operations (such as Transparent Data Encryption)  make changes to the file layouts that make
Posted by Buck Woody | 1 Comments

News Flash: SQL Server 2008 is here

You can find it on MSDN Subscriber Downloads and TechNet Subscriber Downloads . Either search for SQL Server 2008 or navigate under Servers then to SQL Server 2008. http://msdn.microsoft.com/subscriptions/downloads/default.aspx http://technet.microsoft.com/subscriptions/downloads/default.aspx

Security Bulletin for SQL Server 2005

You might notice that I blog quite often about security here, even though I'm on the management team. The reason is that over the years as a DBA I've seen so many shops that don't take care of the basics, so I think you just can't talk about it enough.

Why you should upgrade to SQL Server 2008

One of the readers recently asked about the blog post I made regarding the performance of replication being so improved in SQL Server 2008. We don’t have a formal study posted on that particular result yet, but we do have others that talk about speed

SQL Serve 2005 Cumulative Update 7

The information for the Cumulative Update (CU) 7 is now available - make sure you check that out here: http://support.microsoft.com/kb/949095/en-us

Support for SQL Server 2000 is ending - make your plans!

We're at the end of "Mainstream" support for SQL Server 2000, which is April 8th, 2008. If you're still using this version in your enterprise, you need to plan to move off of that version platform starting now. Many folks are planning to "jump" from SQL
 
Page view tracker