A while back, I saw the following tweet mentioning that you can’t script out data from SQL Server tables. https://twitter.com/cliff_77/statuses/2521180719 It turns out, though, that you can do this. And as long as you are using SQL Server Management Studio 2008 or higher, you have access to the tools necessary. To demonstrate, I’ll walk through the steps … Continue reading Using SSMS to Script Out Data
Everyone likes taking some time to relax. You’re sitting out in the sunshine or on a beach and the waitress is bringing you your favorite beverage. The company and conversation is great and it seems like the perfect day. And then… suddenly without warning… your drink is gone. You were having a great time and … Continue reading What Happened to My Fabulous Beverage!
I received an e-mail from Microsoft today presenting me with the 2009 Microsoft MVP Award for the work I’ve done with SQL Server. I thrilled beyond believe to have this honor. I think this means I should buy myself a new jet ski… is three of them really enough? Thanks to everyone that has helped … Continue reading Microsoft MVP 2009 for SQL Server
I haven’t blogged much since getting back from vacation. It seems like a good restart after the two week hiatus would be to address an issue that has arisen countless times. Sudden File Growth In a number of SQL Server environments that I’ve worked in there either isn’t a method for monitoring file size or … Continue reading When Did That File Get So Big?
Yesterday I posted about having an alert in place to know when SQL Agent jobs don’t have operators setup. I’ve found this alert to be extremely useful, but often when its been shared it just leads to junk e-mail. The reason for this is when the alert is added to 5, 10, or 50 servers … Continue reading Oops… A Lot Of Trees… Jobs to Update
It’s happened a few times, I go out to assist with recovery from some sort of failure and the question of database backups results in an uncomfortable pause. One group thought the other group was taking the backups and the other group didn’t know that the backups needed to be taken. And neither group previously … Continue reading But It Wasn’t My Job To Do The Backups!?
Have you ever gone out and made a new SQL Agent job and forget to assign notification settings for it? God, I hope I’m not the only one because that would mean I suck. This is a common issue that exists in most environments that I’ve worked in. So I must not suck. Quite often … Continue reading Does A Job Really Fail If Nobody Knows About It?
Yesterday I talked about installing the Best Practices Analyzer 2005 (BPA) for a client that I was working with. After some initial installation issues, I was ready to check out their SQL Server environment. While the tool was running, I started checking out the SQL Server event logs to see if there was anything interesting … Continue reading Are You Down With The BPA?
I was hoping to have a case of the Mondays the other day. Whenever one hopes for “the Mondays”, Monday will always deliver. I was using a new PC at a client and installing some tools for an assessment that I was working on. After some download and installing, Best Practices Analyzer 2005 was installed … Continue reading BPA Installs But Doesn’t Work
This project has been on CodePlex for a while, but I thought I would give it a plug. It’s a really good way to generate a load against a SQL Server without a lot of effort. I've used it quite a number of times with presentations and use it when testing different code choices to … Continue reading SQL Load Generator
Strate SQL 