New Features in SSMS 17.3

SSMS 17.3 SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention: Import Flat File Wizard XEvent Profiler Import Flat File Wizard If you’ve worked with SQL Server for very long, you have most likely needed to import flat files from time to time. SSMS 17.3 utilizes […]

The post New Features in SSMS 17.3 appeared first on Wayne Sheffield.

By |October 11th, 2017|SQL, SQL Group|Comments Off on New Features in SSMS 17.3

Stop waiting for SQL Server Service Pack 1 before upgrading!

It’s not stable until Service Pack 1… Are you at a company that doesn’t install a new version of SQL Server until Service Pack 1 (SP1) has been released? Well, you need not wait for SP1 any more. Because there’s not going to be any more service packs. Microsoft just announced their “Modern Servicing Module […]

The post Stop waiting for SQL Server Service Pack 1 before upgrading! appeared first on Wayne Sheffield.

By |September 29th, 2017|SQL, SQL Group|Comments Off on Stop waiting for SQL Server Service Pack 1 before upgrading!

Working with SQLSaturday SpeedPASSes

SQLSaturday SpeedPASSes I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every year, I end up blogging something new. Frequently, this ends up being a script of some kind to help me out. This post follows this theme by introducing a script for working with SQLSaturday […]

The post Working with SQLSaturday SpeedPASSes appeared first on Wayne Sheffield.

By |March 9th, 2017|SQL, SQL Group|Comments Off on Working with SQLSaturday SpeedPASSes

sp_server_diagnostics – Black Box Recorder

A few months back I began a series about the SQL Black Box Recorder, that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore, there was a brief introduction into the three components […]

By |July 26th, 2016|Extended Events, SQL, SQL Group|0 Comments

SQL Black Box Recorder part II

A few months back I began a series, about the SQL Black Box Recorder that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore, there was a brief introduction into the three components […]

By |April 6th, 2016|Extended Events, SQL, SQL Group|0 Comments

Indexed Views – Performance Panacea or Plight

Indexed View(s)
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many times we see that an indexed view would be created to help improve performance. Far too often, an indexed view is created without consideration for the […]

By |January 28th, 2016|SQL, SQL Group|2 Comments

Disk Space and SQL Server

Disk Space in SQL Server
One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a production outage, the need exists.

As a hard working DBA, you want to make sure you hit all of the notes to make […]

By |January 21st, 2016|SQL, SQL Group|2 Comments

SQL Black Box Recorder

Across many professions and industries there is often a need to have some sort of device that “audits” everything that happens with a device or process. We are probably all quite familiar with the infamous black box recorders used by the passenger airline and train industries. It is also quite possibly fairly common knowledge that […]

By |January 12th, 2016|Extended Events, SQL, SQL Group|0 Comments

FreeCon, October 27, 2015 Seattle

The company that I work with, SQL Solutions Group, is conducting a free community event. The week of the PASS Summit, on Tuesday, we will be hosting a day of free training. This is an event for all data professionals who happen to be in the Seattle area the days leading up to Summit but […]

The post FreeCon, October 27, 2015 Seattle appeared first on Wayne Sheffield.

By |September 23rd, 2015|SQL, SQL Group|Comments Off on FreeCon, October 27, 2015 Seattle

What Sessions are Deployed?

As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying to figure things out for yourself. It may even be very common to feel the icy pain of the development cold shoulder (intentional or not) as you go about doing your duties to protect the […]

By |September 1st, 2015|Extended Events, SQL, SQL Group|0 Comments