It’s a very good question. One that might not seem to insidious. Nothing that should be able to bring down the system and cause failures. Or will it? I’ve been to a number of clients and done it myself before where I start to check out a stored procedure with some performance issues and sitting … Continue reading Does Your Stored Procedure Grant Itself Permissions?
If you don’t know where you've been, how can you expect to know where you are going. Seems like such a simple little line and I’m sure many of us can look at history, politicians, and maybe that restaurant review that you didn't heed when it comes to this line. But this also applies to DBAs and more specifically … Continue reading If You Don’t Know Where You’ve Been
In less than a month SSWUG will be hosting the Ultimate Virtual Conference on October 21-24. This is an excellent opportunity to get the benefits of heading to a conference full of Rock Star speakers while be able to view the content from the comforts of home or your desk. Reasons to Attend Some of … Continue reading Check out the Ultimate Virtual Conference from SSWUG
About a year ago I was working on a project that required that data be extracted from one database and inserted into an database. Not the most earth shattering concept. This is done quite often and doesn’t necessarily require a discussion of foreign keys. So why talk about them… well… in this case the source … Continue reading Gotta Stop Violating Foreign Keys
Staying on top of patches for your applications can be important, especially when those patches can fix issues that are currently affecting your environment. I’ve run into this from time to time with where the fix for an issue is related to the current state of updates to the SQL Server instance. If the data … Continue reading Apply Those Updates
One of SQL Server 2008 features I’ve been especially thrilled about is the Management Data Warehouse (MDW). Just recently, Microsoft released a white paper by Kalen Delany that goes into a bit a depth on MDW and covers some best practices and things to watch out for. Happy reading!
There were some questions last night at the PASS MN user group meeting last night about the resource governor. There must be some psychics working over at Microsoft because it seems just this morning a whitepaper came out on it. Some highlights from the whitepaper from the whitepaper include (from the download page): How the … Continue reading Resource Governor Whitepaper
One of the things I get to do pretty often is to visit with clients and discuss how they’ve implemented their SQL Server environment. And if the title of this post is any indication of the contents there are a number of issues that I tend to be able to make recommendations on in all … Continue reading 5 Common Mistakes with Tempdb
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 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?
Strate SQL 