Blog Archives

Notepad++ Common Settings for SQL

Turn off backslash as an escape character for SQL Preferences… Misc… Uncheck “Treat backslash as escape Character for SQL” Click Close Restart Notepad++

Posted in SQL, T-SQL

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

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.    

Posted in SQL
Follow SQL Uber Geek on WordPress.com
Try Audible and Get Two Free Audiobooks