Welcome to SQL Server User Group Exchange

SSUGE.org

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.

SQL Scripts | SQL Server

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

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, […]

SQL Scripts

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 […]