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.

Tagged with:
Posted in SQL

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

Posted in 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

Posted in T-SQL

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.

Posted in 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,

Posted in 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

Posted in SQL

Query Row Count, Size, and Index Size for Each Table in a Database

I have used this script for years to generate a listing of all the tables and their row counts, size, and index size.  I can’t find where I found it, so if you recognize it, please let me know.  I

Posted in SQL