SQL PASS Summit 2015

Having a great time at the PASS Summit.  I will be adding items I learned over the next few weeks.  I am also going to try and add a blog entry once a day.

SQL 2014 Cluster

Starting last week at work, we were trying to get a SQL 2014 cluster installed.  Here is the link that I found that was very useful in getting it installed.  The key was to “deactivate” the sql cluster computer name in AD after it was created manually. http://www.sqlshack.com/sql-server-2014-install-clustered-instance-step-step-13/  

Category: SQL

SQL Restore Script

I have had to script restores using different backup programs and different options.  Here is my latest script that searches a network path for the latest backup using the maintenance plan naming format.  It can also be used to restore a single backup file.  This version is designed to only restore a single database.

Job Stored Procedures

I am constantly having to search for stored procedures to manipulate SQL Agent jobs.  Here is a list that I have used recently.

Category: SQL

Add Role to User

I create this script because I was tired of forgetting to check to see if a user actually had access to the database before granting a database role to it.  So, it will add them to the server, the database, and the role.  Just run the script in the database where the role exists.

Category: SQL

Duplicate Role Permissions by Login

I have had continual requests by people to duplicate someone’s role accross multiple databases on the same server.  It use to be a manual process to look at each user and check the roles and then compare them individually.  I finally got my script together that will create the login, the user, and assign the… Read More »

Category: SQL

Free SQL Formatter

I got tired of everyone at work using different formatting standards.  While working on the standard, someone found Poor Man’s TSql Formatter.  It’s great.  There is even a Notepad++ version.  Try it out.  It’s great.    

Category: SQL

Virtual Lab

I use Virtual Box at work for my development.  I searched internet for websites on how to save disk space for my Virtual Lab.  Chris Davis has a great series of blog posts about building a Virtual Box lab using snapshots to save disk space.  Check it out. http://pc-addicts.com/building-the-ultimate-virtualbox-lab-intro/

The Beginnings of SQL Uber Geek

I have been a SQL DBA for about 15 years and working in IT for over 20 years.  This site is going to be where I post things that I have learned.  Everything from general PC support to SQL scripts. Danny