
DBA ramblings, tips and scripts to make the work of a DBA smarter and better.
“The more that you read, the more things you will know. The more that you learn, the more places you’ll go.” Dr. Seuss
Feel free to browse the site with the helpful SQL scripts provided. Hope these will help to make your DBA life a little easier.
I have been working as a SQL Server Database Administrator for the past 20 years. I love what I do and the flexibility of a DBA’s work schedule that lets me have a healthy work life balance. All the after hours work as a DBA has its pros and cons but hey – when life gives your lemons (after-hours outage), you make lemonade (just go with the work until it gets resolved…lol)
I am available for any SQL Server Administration consulting work. Please feel free to contact me via the contact us page. Look forward to hearing from you.
VIEW SERVER STATE
There are occasions when database users will reach out to me get elevated database permissions to run DMVs. Members of sysadmin roles can view the results of Dynamic Management Objects but sometimes it There are occasions when database users will reach out to me get elevated database permissions to run DMVs. Members of sysadmin roles […]
SQL Server build numbers
As a DBA we are asked every so often to check the sql server version on a server. When you look at the version # in ssms it looks like this: Looking at the above SQL Server 13.0.52012.2 does not really tell me right away what is the version # of the sql server running. […]
SQL Server Integration Services installation failure – VS Shell Installation has failed with exit code 1638
I recently received a request to install SQL Server 2017 integration services only on a server.After I mounted the iso media on the server, I started with the SQL Server installation. Choose the option to install a new SQL Server instance as indicated above. Click Next to continue… Accept the Licensing Terms…and click next Next, […]
Find a schema in all databases
So what is a Schema?A SQL Server database contains multiple objects: tables, views, stored procedures, functions, indexes, triggers. SQL Server Schemas are a logical collection of database objects. A user that owns a schema in the database are known as Schema owners. There is no restrictions on the number of objects can be in a […]
Email Alert when SQL Server is restarted
As a DBA we need to be notified when a SQL Server is restarted so that we can take a proactive reaction to identify the cause of the restart which could be an indication of underlining issues with the Server OS or the SQL Server Engine. I have used this several years now and it […]
Get hard drive brand, size and serial number on a Windows Machine
A few occasions I came across a request to find the hard drive brand, size and serial number installed on a Windows OS machine. To get the basic hard drive info and to determine some basic info about the hard drive installed on your machine, follow these steps: Click on the Search icon on your […]