Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Testing

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

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

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
Posted by Buck Woody | 7 Comments

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

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

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.

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
 
Page view tracker