If you use RDP to remotely connect to your servers, you've probably encountered a clipboard issue where copy/paste stops working. A quick Google search on the problem indicates you can easily fix the problem by logging out/logging back in or killing/restarting rdpclip.exe on the remote server. Here's an article which covers this topic. But what do you do when copy/paste is intermittent? It works one second, stops working for 5-30 seconds, and then on its own starts working again. This is what’s occurring in our new non-production environment. The DBA team is setting up 16 new physical servers and...
If you've ever had to copy large files on a Windows platform using the Windows copy method (copy/paste in Windows Explorer or copy/xcopy commands), then you know how slow it is. Recently I had to setup database mirroring for a largish database, so I needed to copy the full backup to the mirror server. The database is about 110 GB in size, but since we use Quest's LiteSpeed product, the full backup is just 35.8 GB in size. I had heard about FastCopy, which claims to be the fastest Windows copy product, so I decided to do comparison tests. ...
This is very amusing and sad, and it is a great example of why backups are so important.
Now the company is dead thanks to their malicious IT guy.
I recently got setup at home with three identical monitors as I work from home often. Here's a picture of them. The left-most monitor is my main monitor for my work laptop. I extend that desktop to the middle monitor. The right-most monitor is for my home computer. For productivity and neatness reasons, I wanted to use only one mouse and one keyboard for both my work laptop and my home computer.
There are many tools out there that allow you to use one keyboard and one mouse with multiple computers, but most of them require special hardware and aren't...
There are times when I need to run some process using credentials other than my current security context, such as when my userid doesn't have permissions to a remote resource but another userid does. I can easily do this interactively via the "Run as..." option (right click a process and then enter credentials) or via the runas command in a cmd window. The problem with these though is that I have to type in a password, which creates a problem when I want to do this as a scheduled job. In the past, I've written a batch file to map...
Microsoft "confirms" the small world theory. We are linked by 6.6 degrees of separation.
Read more here.
Most of you probably already have done this, but just in case you haven't and find yourself frequently using cmd to run commands such as sqlcmd, you will find this registry "hack" useful. I use sqlcmd on a weekly, if not daily, basis. I'm constantly switching directories to where my scripts are. Rather than switching directories in cmd, I can instead use the "Open Command Window Here" option in Windows Explorer. To get this option on your machine, save the below as a reg file and then double-click on it: Windows Registry Editor...
Attention Loyal Readers,
I've updated my RSS feed to use FeedBurner. If you haven't already done so, please update your link to this one: http://feeds.feedburner.com/RamblingsOfADba
If you don't update your feed, you will be redirected to the new one. However, I won't know how many loyal readers I have out there. I could be persuaded to write more if I knew how big my audience is.
For those of you who read my blog through my main blog page or through the SQLTeam main blog page, I'd recommend getting a blog reader to make it easier to read blogs. I use Google Reader.
Windows Server 2003 Service Pack 2 has been released. Check this out for details.
I've been trying to determine what new cell phone I want to get since my current personal one is pretty old. One of the most important features that I am considering is its size. I want to get a smartphone, but most are quite bulky. I've been using this site to compare sizes between the phones that I am interested in. The top contender right now is the Blackberry Pearl.
You just need to know the dimensions of the product to be able to use the tool.
I deleted a few hundred spam comments today from my posts. I hadn't kept up with deleting them, so I had quite a bit of work to do today. Due to the amount of spam my posts have received, I've decided to close comments after 90 days so that the amount of spam is reduced. I wish we had a better way of handling it, but the options aren't available to us right now.
If you want to comment or ask a question on an old post (one that is older than 90 days), you can send me an e-mail...
Do you ever need to connect to the console of a server? Are you too lazy to go to the server to do it? If so, then check this out from a cmd window:
mstsc /v:serverName /console
I almost never need to connect to the console as most everything that I need to do can be accomplished with the SQL Server tools and the use of Terminal Services/Remote Desktop. But this will come in handy when two other people are already connected to the server via RDP. Now a third person can connect!
Have you tried out YourGMap? It allows you to plot multiple locations on one map (Google Maps) and publish it to the Internet for others to see.
We are currently using it to plot the houses that we've looked at or need to look at in search for our new home. Our real estate agent probably has a similar tool but I doubt it's as efficient as this one.
I would like to make some changes to code that I posted for database maintenance routines. I'm wondering what your opinion is for modifying the originals or creating new ones.
I need to change isp_DBCC_INDEXDEFRAG and isp_DBCC_DBREINDEX as the way it is coded now it will only do it for one of the indexes on each table. I also want to change isp_Backup and isp_Backup_LS based upon people's comments about saving more than 2 days of backups on disk.
So should I just modify the original blogs or create new ones and reference the old ones?
Well it's over 90 degrees in San Diego, CA this week. I went to the beach yesterday to escape the heat as did thousands of others (I should have sold my parking spot when I left). It was actually pretty cold at the beach with the winds. The water was unbearable. But it was better than sweating it out inland (I'm really only 15 minutes away but the ocean breeze isn't making it out there this week). It's barely May and we are having record breaking tempartures already. It's going to be a very hot summer here. I'll be dreaming of...
This is my first post. Hopefully I'll have some good information to post here soon.