Pinned Post

Lowell's avatar

SSMS Tips and Tricks to make you more productive

Many DBA's and Developers use SQL Server Management Studio on a daily basis, but there are dozens of functionalities that exist, that you may not even be aware of. We will be going over some of the nice things that can make you more productive as a DBA or Developer: Central Management Servers, Activity Monitor, Built in Reports, Object Explorer Details, Template Explorer, code snippets and so much more.
Keyboard Shortcuts are a free built in functionality that can make finding and accessing your data easier, and easily increase your productivity.
There are various Plug ins that can make your life easier, that range from free to expensive, that can really make a difference in your day to day productivity, or even save you from losing hours or days of work. Come see how you can make your life easier, with a tool already in your toolbelt!

Recent Posts

Lowell's avatar

Active Directory And The DBA

This session covered Getting Active Directory Information, Inserting and Updating into SQL Tables via Powershell. the scripts get all AD Users, all AD groups, all computer and server names in the AD, and a lot more, and put them in your sweet spot: a suite of tables in the database of your choice for further analysis.
A complete suite of both Powershell and TSQL scripts will be provided to add to your DBA Toolkit for all the features presented.
I will go over the prerequisite if you want to do this on your workstation, vs a Server, which might already have the Powershell AD components installed.
Once in the database you can do some great analysis that can help you remove individual logins and replace them with the groups they belong to , Who has access but are no longer working, which groups are inheriting from other groups, and lots of other possibilities.
Examples of some of the reports I generate:
List of all Groups a user belongs to, including inheritance via nested groups.
List of All Users who are enabled / disabled.
List of users who's passwords must be changed in the next x days
List of All Users who are locked out, and whether it's due to password expiration or other reasons.
List of users who also have SQL Server access, and their permissions at either the server or database level.
List of users who also have SQL Server access,and they are disabled in AD.
How to schedule this as a job to keep the data up to date.

Lowell's avatar

Using Virtual Box with SQL Server 2016

Using VirtualBox to create a Virtual Server with SQL Server 2016 Developer Edition.
Ideal for the Developer on a budget! The only thing this costs is your time to learn.
A step by step Demonstration on using VirtualBox, where we will create a Virtual Machine With a Windows Server Operating System Evaluation Edition, install SQL 2016 Developer, and show how we can then clone or snapshot those machines for rollback and recovery purposes.
I went over the caveats for using the portable edition version as well, so you can avoid headaches in the future, while carrying around your entire lab on an SSD drive.
You may know that if your operating system is Windows 7, you cannot install SQL2016. Having a virtual lab that you control give you the leg up and allows you to test other operating systems and the latest SQL Versions you might otherwise not get to work with.

Lowell's avatar

Real World DBA Toolkit by Lowell Version 3.12

This session will consist of a handful of applications I recommend to make your like easier, and a huge suite of stored procedures to put a real world DBA's primary responsibilities at his or her fingertips.
Lowell is Senior Database Administrator in the Healthcare industry whose daily emphasis is improving performance automating and streamlining tasks. The SFSSUG Study Group contributed to his ability to earn his MCSA this year.

Lowell's avatar

South Florida SQL Server Users Study Group

SQL Staurday Planning Meeting

Planning Meeting

The Team at the Miami Sessions

At New Horizons

Lowell's avatar

Helpful Links

SSMS Tools Pack
This pack, which costs ~35 dollars per year,and 25 per year to renew, has made me more than twice as efficient,as well as guarding my code from accidental deletion.
every TSQL command I have executed in the last seven years is in a searchable index.
That means those days where i wrote inspired code, that code never gets lost.
pure awesomeness.
Productivity Tools: Personal Favorite and Recommendations
By under

Keyboard Shortcuts

By under
Lowell's Keyboard Shortcuts
My personal recommendation and TSQL stored procedures to call via SSMS shortcuts.
The key is really to highlight, and then hit the keyboard shortcut.
This technique lets me save HOURS per day,and amaze people looking over my shoulder.

Core Links

SQL 2016 Developer Edition w/SP1
Visual Studio Dev Essentials
SQL Server Management Studio 2016
SQL Server Data Tools

~