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
Tag: SQL Server
Apply Those Updates
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
Management Data Warehouse Whitepaper
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!
I Had a Dream, too!
Some people have dreams and they talk about them and an entire generation is changed. Things line up and world is a lot different than the day before just because of a little dream. I dream, too. But my dreams aren’t so grand. I tend to dream about SQL Server professionals coming together to network, … Continue reading I Had a Dream, too!
Moving to the Head of the Line
Jobs aren’t a dime a dozen like they used to be during the dot-com bubble. These days the unemployment rate is heading to territory that hasn’t been seen in decades. With some states seeming unemployment rates as high as 15%. It becomes more important with every interview to differentiate yourself from the pack. Differentiate Yourself … Continue reading Moving to the Head of the Line
Are you busy Wednesday, Thursday, and Friday?
This week SSWUG is hosting another virtual conference featuring content for SQL, SharePoint, BI, and .NET professionals. There is a lot going on and like their previous conferences you don’t have to leave the comforts of your beach bungalow to participate in the conference. I encourage everyone to check this out… We're excited to … Continue reading Are you busy Wednesday, Thursday, and Friday?
Analyzing Your Indexes with a Custom Report
A while back I put together a number of posts around an index analysis query that I had put together to assist when I go out to clients. If you are interested, the background for the query can be found in the following posts: Analyze Your Indexes Part 1 Analyze Your Indexes Part 2 Analyze … Continue reading Analyzing Your Indexes with a Custom Report
Resource Governor Whitepaper
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
Volunteering and Resume Building
I really like a great idea. They have this way of going from a great idea to success. When you hear a great idea it is always a good idea to share the idea – and let it spread like a virus. Today, while I was going through and reading posts from Microsoft’s SQL Server … Continue reading Volunteering and Resume Building
5 Common Mistakes with Tempdb
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
Strate SQL 