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: Plan for Diagnostics in Cloud Computing From the Git-Go

    “Git-Go” is something we say in the South that means “right at the start”. I’ve seen several applications for on-premise systems that don’t have much in the way of diagnostics - the developers rely on a debugger, the event logs on the server and client workstation, and most of all, the ability to watch...
  • Blog Post: Database Testing Links

    Yesterday at the SQL PASS 2010 Summit I did a presentation on database testing - I have two sets of links I mentioned there, one for the information I presented and the other for various tools I've tried. Enjoy: More information on Database Testing and Testing methodologies: http://www.agiledata.org...
  • Blog Post: Attaching a Database

    I had someone ask me yesterday how they could get to a database used by a product that they owned, but that was installed using SQL Server Express. They didn’t have access to the database, and they didn’t know the password for the service that started Express, so they wanted to know if they could look...
  • 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: After the Upgrade, it runs differently…

    I got a question yesterday in the mail that I thought I would just answer here in a broad context. While I can’t troubleshoot or do performance tuning from a distance, there are some interesting concepts and suggestions this e-mail brings up: “I have recently seen a change from SQL Server from 2005 to...
  • Blog Post: Channeling Bruce Lee: Tuning without Tuning

    I’m leading a Performance Tuning workshop here in Portland, Oregon today, and I normally start this kind of workshop with a segment on “pre-tuning” – or, the steps you take so that you don’t have to tune as much later. When we set up a system is the greatest opportunity for optimal performance. From...
  • Blog Post: Using Perfmon Data in Profiler

    In SQL Server 2005 a great new feature was introduced into SQL Server Profiler – the ability to import Perfmon data. If you’re not familiar with one or both of those tools, SQL Server Profiler is a package included with SQL Server that can “watch” your system’s activities. You add these activities into...
  • 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: Idera's Job Manager - Trying it Out

    I've downloaded Idera's free Job Manager this morning and I'm going to play with it a little on one of my test systems. Job Management is a difficult thing to visualize, so the Outlook-format this tool has looks interesting to me. Has anyone implemented this tool already, and do you have any thoughts...
  • Blog Post: Check that database before you restore it...

    I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as a test. Then things started going awry... Then this...
  • 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: Simulating Multiple Connections

    As I was giving a demo of the new multi-query capabilities the other day, I was asked how I had four Instances installed on one small, underpowered laptop. In fact, I don't - I have one instance of SQL Server 2005 and one Instance of SQL Server 2008 installed. What I've done is to create two "aliases...
  • Blog Post: Setting up a Testing System

    I build a new SQL Server just about every other day. As we write new software or fix bugs on old software, we create a new installation of SQL Server. Those of us who are testing the fixes, creating new features and so on have to install these new versions on a system to check the software. To do...
Page 1 of 1 (14 items)