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 to avoid switching to the mouse when you don’t have to. Here are some shortcut keys that I find very useful in SQL Server Management Studio, some of which I just discovered recently. Window + …
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 bad practice. Transcription: Steve Stedman 0:09Welcome to today’s training video. I’m Steve Stedman. I’m the founder of Stedman Solutions. Today we’re going to talk about one of the common items reported by the sequel daily …
Default Maintenance Plan Shrink Database – Video Tip Read more »
For years I have struggled to find a good way to do TSQL formatting. Here is a short video of how to simple TSQL cleanup and formatting using just SQL Server Management Studio (SSMS). This works on SSMS from SQL Server 2005, all the way up to the latest release of SQL Server Management Studio. It is not as nice …
Today at PASS Summit Microsoft announced a new SQL “Tool” for running queries against SQL Server, called the Microsoft SQL Operations Studio. So what is the Microsoft SQL Operations Studio This appears to be a new cross platform (Mac, Linux, and Windows) for running queries against SQL Server. Perhaps this is a replacement for SQL Server Management Studio, or may …
This weeks episode we are pleased to host Andy Leonard to discuss his thoughts on the catalog and how this feature provides some really interesting benefits for ETL architecture. Although the SSIS Catalog DB is created with management studio, it does not behave like other databases. Our conversation in this episode revolves around the catalog, SSIS packages, and some of the complexities of migrating …
Podcast Episode 79: SSIS Catalog with Andy Leonard Read more »
With the recent public availability of the SQL Server Linux release, I figured I should give it a try, and it went well. Here is all that it took. Download and install to a VM Ubuntu Linux Server 16.04. (1 hour) Allow port 22 through the firewall to be able to connect to the server with Putty. (1 min) Follow …
One of my favorite queries this week is the following query that creates a text based bar chart to quickly help visualize the VLF files on any database log file. In the last month I have given the “TempDB Do This and Don’t Do That” presentation twice, once at the Bellingham SQL Server users group, and another time at SQL …
In SQL Server there is a special connection that can be used to connect to the database, the remote Dedicated Admin Connection or (DAC). This is a special connection that allows the administrator to connect to the SQL Server even if something has occurred that is preventing connections on the normal port. One quick way to check if the DAC …
SQL Server – Dedicated Admin Connection (remote DAC) Read more »
So you are checking your database with DBCC CheckDB and of course if you are like me you use the WITH NO_INFOMSGS parameter. But it turns out that CheckDB is taking longer to run that you expected, and you want to check and see what table is currently being checked. Here is a quick SQL Script that I use to …
Statistics IO and Statistics Time are another SQL Server Performance Tuning Tip to help you better understand performance bottlenecks. Have you ever wanted to know exactly how long it took for a query to run? Have you ever wondered how many I/O reads or writes were caused by your query? With Statistics IO and Statistics TIME you can understand both …
Using Statistics Time for Performance Tuning in SSMS Read more »