Browse by Tags

Tagged Content List
  • Blog Post: How Microsoft helps you NOT break your Windows Azure Application: Storage Services Versioning

    One of the advantages of using Windows Azure to run your code is that you don’t have to constantly manage upgrades on your platform. While that’s a big advantage indeed, it immediately brings up the question - how do the upgrades happen? Microsoft upgrades the Azure platform in periodic increments, and...
  • Blog Post: Data as Strategy

    I’ve created a presentation called “Data as Strategy”, and in it I cover multiple solutions for various issues that organizations face in dealing with the “new world” of data management. No longer are we just DBA’s or Developers, now we’re part of the broader business strategy of using data in strategic...
  • Blog Post: Spit it out already!

    You’ve probably seen that commercial where the chewing-gum company van stalks the guy who has been chewing the same piece of gum too long, and they attack him and make him chew another piece. I feel like that with SQL Server 2000. Almost every shop I go into has at least one primary application running...
  • Blog Post: 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 I manage. I tend not to focus too much on a...
  • Blog Post: 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 in fact I still do), but today I'll be attending...
  • Blog Post: 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 in the SQL Server 6.5 days, and I haven't had an...
  • Blog Post: 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 anything, and make sure you install it on your...
  • Blog Post: 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 ETL, BI and Reporting. But before they make the...
  • Blog Post: 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 DB again and version that as well. That allows...
  • Blog Post: 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 when they are using Standard. They'll use an edition...
  • Blog Post: 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, you can move to SP2 now. Here's the full...
  • Blog Post: 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 to see if you face any of these issues, and...
  • Blog Post: 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 it – interesting – to move to another...
  • Blog Post: 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...
  • Blog Post: 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. Microsoft just released a new security bulletin...
  • Blog Post: 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 increases in SQL Server 2008 – especially cool things...
  • Blog Post: 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
  • Blog Post: 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 Server 2000 to SQL Server 2008, but if you need...
Page 1 of 1 (18 items)