Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here. Granted, it has been a month and I still have been slacking. I am […]
Tag: TSQL
Where have all the Orphans gone?
Do your database users appear to be having an out of body experience? Have they lost all ties to their login? Does it feel like maybe what this baby rhino might be experiencing – just […]
Where in the World is…
You may or may not have noticed that over the past several months I have been somewhat absent from my blog. Very few articles if any have been produced. There has been a very good […]
A Trio of EachDB
When administering a larger database environment, sometimes one needs to perform repetitive tasks. Performing repetitive tasks becomes more and more painful (maybe even demoralizing) with the larger the number of databases that might exist on […]
SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say if it could be more like […]
Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to you asking “What do we do?” […]
Another Interesting Sort
Some code requirements can be met through various means including the use of a different collation – which means a lot of testing.
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 […]
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 […]