What’s your favorite SSMS time saving hotkey?
Recently I have been on the LEAN improvement quest to make a 2 second improvement in my process every day. Part of that improvement is… Read More »What’s your favorite SSMS time saving hotkey?
SSMS
3 Steps to Work More Efficiently in SSMS.
Throughout my career I have worked with different programming and database tools. Thinking back the tools that I enjoyed using were the tools that were… Read More »3 Steps to Work More Efficiently in SSMS.
Default Maintenance Plan Shrink Database – Video Tip
The problem with using the default maintenance plans is that SQL Server Management Studio makes it easy to turn on some features that are really… Read More »Default Maintenance Plan Shrink Database – Video Tip
Bulk Update Database Mail Password
Database mail is a critical part of getting notifications from your SQL Server when things go wrong. The problem comes when you have a database… Read More »Bulk Update Database Mail Password
sp_readerrorlog – Msg 22004, Level 16, State 1, Line 0 – Failed to open loopback connection. Please see event log for more information.
Recently while working on a SQL Server for a client I came across the following error when I attempted to view the SQL Server logs… Read More »sp_readerrorlog – Msg 22004, Level 16, State 1, Line 0 – Failed to open loopback connection. Please see event log for more information.
Script all Agent Jobs Using SQL Server Management Studio
While doing a recent server move, I came across the need to script all agent jobs and save them to a file so that if we needed to reference what was there after the move we could get at the agent jobs without having to restart the old SQL Server.
It made me realize that sometimes what you want to do is available in SQL Server Management Studio, but that perhaps it is not always entirely obvious.
In the example below, where I have four jobs (imagine if it was 150 jobs), I want to script all of them out and save them for future use.
I could just right click on each one, choose “Script Job As, CREATE To, New Query Window”, which wouldn’t be that bad for 4 jobs, but assume you need to do this for 150 jobs, it could take you a while.
Read More »Script all Agent Jobs Using SQL Server Management Studio
SSMS Results In A Separate Tab
At the end of my SQL Saturday presentation today on Advanced Common Table Expressions, which is about the 12th time I have presented on CTEs,… Read More »SSMS Results In A Separate Tab
What twitter hash tags do you follow for SQL Server?
# The key to twitter is to follow the right hash tags. What hash tags do you follow related to Microsoft SQL Server? Here are… Read More »What twitter hash tags do you follow for SQL Server?
3 Steps to Work More Efficiently in SSMS.
Throughout my career I have worked with different programming and database tools. Thinking back the tools that I enjoyed using were the tools that were… Read More »3 Steps to Work More Efficiently in SSMS.
Whats your favorite SSMS time saving hotkey?
Recently I have been on the LEAN improvement quest to make a 2 second improvement in my process every day. Part of that improvement is… Read More »Whats your favorite SSMS time saving hotkey?