This is a short script to help the DBA with documentation purposes. This would come in handy especially in those cases where you are consulting or you have taken on a new job. Suppose you […]
Category: News
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a couple of different queries that I like to use. The two scripts returned different pieces […]
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
Another month and another opportunity to write about an interesting topic. This month hosting TSQL Tuesday is Argenis Fernandez (Blog | Twitter). This month, Argenis has invited us to talk about demons from our past. […]
What is a Favicon?
If I were to show you the tabs in the following pic without a description, would you recognize the websites to which they belong? I would dare say that you would likely recognize them. Not […]
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned on getting a solution that involves TSQL to help determine if you are running SQL […]
Views in Use?
Today, I am following up on a topic I mentioned in an earlier post. In case you haven’t read the post on finding your linked servers, you can read it here. It is in that […]
A DBAs List of Little Things
Today is Meme Monday. Today we get to talk about all of the little things a DBA does. Thomas LaRock started things off with his list – here. I want to just add to the […]
Are my Linked Servers Being Used?
This is a follow up to an article published on 3/1/2012. That article showed how to find what linked servers were created on your instance of SQL Server. You can read it here. This article […]
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means to be able to find the […]
Goals 2012
As I have wanted to do each year, here is my goals post for 2012. Last year I set out to do this very same thing but was very unsuccessful at completing the post. Here […]