Tag: SSMS

Microsoft SQL Operations Studio

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,

Tagged with: ,

Podcast Episode 79: SSIS Catalog with Andy Leonard

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

Tagged with: , , , , ,

Getting Started with SQL Server on Linux

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

Tagged with: , , ,

Visualizing Log File VLF Sizing

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

Tagged with: , , , , , , ,

SQL Server – Dedicated Admin Connection (remote DAC)

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

Tagged with: , , , , , ,

Status of DBCC CheckDB

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

Tagged with: , , ,

Using Statistics Time for Performance Tuning in SSMS

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

Tagged with: ,

Using the TSQL CHOOSE Function

Here is a short video tutorial that shows how to use the CHOOSE function in T-SQL on SQL Server 2012, SQL Server 2014 or Newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here

Tagged with: , , , , , , ,

Executing a TSQL batch multiple times using GO

Using the GO commend in TSQL to run a batch of code multiple times is something that I commonly do in demo’s and training’s.  What amazes me is how many people after the training will tell me that they didn’t know

Tagged with: , , , , , , ,

A great day at SQL In The City by Redgate

Friday I had a great day at Redgate’s SQL In The City presentation by Steve Jones (@way0utwest). There were three sessions presented which are summarized below. Session 1 – Team-based Database Development with Version Control I thought that this session was

Tagged with: , , , , , , , ,
Top