Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

SQL Database Tuning Advisor Output Renamer

I’ve uploaded the ‘Database Tuning Advisor Output Renamer’ at http://DtaOutputRenamer.codeplex.com/ . OK… so Friday marked the first day I’ve ever gotten sunburned while coding. I had a little bit of free time while at an outdoor event, and whipped up

PowerShell Script to reset the local instance of SQL Server

I use virtual machines a lot for development and testing. I typically start with a sysprepped base image that I then initialize every time I need a new machine. One issue is that SQL Server doesn’t know it has been sysprepped… if you execute 1: SELECT
Posted by ddarden42 | 0 Comments
Filed under: ,

SQL Load Generator Tool

A few weeks ago I spoke at PASS on using the Resource Governor in SQL Server 2008. For my demo, I created a little application that could fire off multiple queries against SQL Server to simulate different users/applications. This tool… gasp… creates a

Testing and Tuning an Internet Facing PerformancePoint M&A Dashboard

I've spent the past 15 months, off and on, working as the technical lead on a performance management project using PerformancePoint Server. The project was to create a SharePoint Portal where users could view the performance of a school system. The portal