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 […]
Category: News
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 […]
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times we inherit some things that are just plan annoying. Yet other times, we inherit things that may be annoying and we probably just haven’t discovered them yet.
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?” […]
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that trend. I do have a good excuse for why I haven’t posted many blogs […]
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along – the transaction log on the primary […]
SQL 2012 has Launched
LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it, some really cool features are now available to use in our SQL database environments. […]
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then possibly a manager or client. Usually this comes up when evaluating for missing indexes or […]
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.