The below is a script that I’ve built that helps with cleaning up sensitive information and frees up space. This script should never be ran on a production database as it shrinks it at the end. Read the comments in it and then look through the script before blindly running it. Let me know if … Continue reading Cleaning up a database for local use
If you ever have a business process that’s been running for an extended period of time it’s more than likely going to be because of something going on in the database. One instance that I had come up lately was a dynamic selection being dumped into a temp table. This was part of an out … Continue reading How to kill a long running business process
One of the things that organizations tend to want or need during and after implementation are database refreshes. Right now we have 3 database servers: production, staging, and test. Full backups are taken of every user database on the servers every night. I setup a job that would automatically move them nightly after the backups … Continue reading Refreshing with production databases
I’ve lately been working on getting a build setup using Visual Studio Team Services. The build works fine, but deploying everything is a different story. I’m going to rewind back to the basics of how to setup a minimal build in your visual studio solution. If you aren’t familiar with postbuild files then head over … Continue reading Builds
Some of you may have both VS2008 and VS2010 installed on your machine and are developing against a 2.9 and 2.91 versions. Well if you haven’t already had to constantly run the SetCurrentSDK.bat files then you will soon enough. I just created some batch files to make my life a little easier. The first part … Continue reading Developing on a machine that has 2 SDKs.
I had a need to open BBEC in 32 bit on a 64 bit machine in order to get a piece of third party software to work correctly. I was stumped, and rightfully so because the application is compiled for AnyCPU, therefore when it’s on a 64 bit machine it runs in 64 bit. The … Continue reading Opening BBEC in 32 bit on a 64 bit machine
This is an awesome trick I learned from Greg Howe, (all credit to him). While having to connect to another network and have the need to run queries on a db on that network, I usually had to remote in to that machine and run the queries. Well that is no longer the case. Create … Continue reading Need to run some queries or profiler under a different domain user?