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.
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/
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.
I am constantly having to search for stored procedures to manipulate SQL Agent jobs. Here is a list that I have used recently.
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.
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 »
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 might get around to rewriting it one day.
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.
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/
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