I ran into a small problem where I needed to automate a restore of my last full backup to a different database. Since my full backup file names include a date/time stamp I needed to query msdb for the backup name. Since I figured it out, I thought I'd post it so I would know where of find it the next time I need it, and maybe help someone else out in the process.
Last weekend I attended SQL Saturday in Chicago.
We are in the process of upgrading a Microsoft product that just hasn't gotten around to integrating with AD and uses SQL accounts. It also has a really bad habit of locking SQL accounts if your AD policy for failed login attempts is set low. So I got tired of searching through SSMS to unlock accounts, so I wrote a quick script to list the locked accounts and the command to unlock it. I didn't go as far as to auto-unlock the locked accounts but that would be a simple edit. Here's the script.
I was asked to find all tables in a database that had a DML trigger so a developer could ensure that all the old functionality was available in the new database. So once I built my query to give me the information, I thought I'd save it here for future use.
I was installing SQL Server 2008 on a Windows 2008 cluster the other day and I received and error: 'The current SKU is Invalid'. So I went looking for the resolution. I came across a blog post by Vittorio Pavesi that pointed me to the answer. I did not take the course of copying the install files to the local server. I was installing from a network share, so I simply moved the file DefaultSetup.ini to a new location and started the 'Add node to a SQL Server failover cluster' again and entered the key included on the DefaultSetup.ini manually. The rest of the install went without issue.
1 comment
No trackbacksWe have a database that holds information that is fairly personal, so much that the application team that supports it may only have read access to the database. There came a need to occasionally lock all the administrators out of the system for updates. These updates will occur every few months. So I created a SQL user and gave that user select and update rights to the necessary table. Then I created a couple of stored procs, one to disable the logins and one to enable the logins.
Here's a little simple one that I'll probably need again, so I thought I'd just blog it:
When I became our companies MSSQL DBA I inherited an smooth running machine. My predecessors were extremely talented and their scripts did everything we needed done. But I can't just live off their hard work, I need to leave my mark on the environment. So I am tweaking some of their scripts to get rid of what annoys me. The current task is old backup files. The scripts they wrote do this awesome thing that archives a backup if the archive bit has not been cleared. This is so cool. If NetBackup has a problem, the old backup file that hasn't gone to tape/disk is moved to an archive folder and then the new backup file is created. But what happens when after the file is backed up and the archive bit is cleared. It just sits on the disk and is backed up again with every full backup that occurs. That makes the backups bigger and take longer. So I added a job that deletes all *.bak files that have their archive bit cleared. That was so much easier than I expected it to be.
I was working with SQL2000 on a windows cluster. I needed to write the results of a query to a test file on the local drive. I was using @@servername to get the server name to write the file. Unfortunately that appends the instance name and gave me a problem. So I went looking for how to remove the instance name and I found a pretty neat trick.
Well, it's been 10 days since I started to play with parallelism on this server. I have gotten the self blocking to stop. My CPU utilization has stabalized and my phone is not ringing. So I think that the issues is mitigated. I finally settled on Max Degrees of Parallelism of 2 and the Cost Threshold for Parallelism of 500. I also have the developers looking at the code to ensure all their joins are nolock, they tell me they should be, but I am asking nicely to them to verify. So I'm moving on to other issues unless this one pops back up.
Write a commentNo trackbacks
Delicious
Digg
Furl
Magnolia
Reddit
Slashdot
Stumbleupon
Technorati Favorites
Twitter
.
.
.