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

Easy Permissions Audit

Something I have written about more than a handful of times is the need to audit. When people think about audits, the first thing that comes to mind is most likely the IRS and taxes. More than taxes are audit-able. Despite that tendency to first think taxes when somebody says “audit”, I am not writing about […]

By |February 13th, 2017|Security, SQL Group, SQL Server|0 Comments

Security Configuration for Linked Servers

A few years ago I published an article about how to use linked servers to avoid performance issues. I wanted to follow up on that with a discussion of linked server security configuration because this is another big issue I see all too often with linked servers.

The first thing to understand is that all linked […]

By |October 4th, 2016|Security, SQL Group, SQL Server|0 Comments

Working with the registry in SQL Server

There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the registry within your T-SQL scripts. As it turns out, there are several undocumented extended stored procedures in SQL Server that do just this. A listing of these procedures are:

Regular
Instance-Aware

sys.xp_regread
sys.xp_instance_regread

sys.xp_regenumvalues
sys.xp_instance_regenumvalues

sys.xp_regenumkeys
sys.xp_instance_regenumkeys

sys.xp_regwrite
sys.xp_instance_regwrite

sys.xp_regdeletevalue
sys.xp_instance_regdeletevalue

sys.xp_regdeletekey
sys.xp_instance_regdeletekey

sys.xp_regaddmultistring
sys.xp_instance_regaddmultistring

sys.xp_regremovemultistring
sys.xp_instance_regremovemultistring

 

As you can see, there are two […]

By |August 2nd, 2016|SQL Group|0 Comments

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

Technical Debt, Database Design and the Days of Reckoning

No one who has been around this planet for more than a few decades is unaware of the saying, “You can pay me now, or you can pay me later.” And yet, almost universally, when someone is presented with the choice of paying now or paying later, they invariably choose to pay later. There are […]

By |May 24th, 2016|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

SQL Server ’16 helps you meet Best Practice

In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need to follow. The SQL Health Check that you can have us perform on your  instances looks at many of these. SQL Server 2016, which at the time of this writing is in a Release Candidate […]

By |March 15th, 2016|SQL Group|0 Comments