ANTS Performance Profiler for the SQL Server Dev

• by Sheldon Hull

• Sheldon Hull

There are a few .NET tools that until recently I haven't had the chance to work with as much, specifically...

2017-07-21

974 reads

Update SSMS With PS1

• by Sheldon Hull

• Sheldon Hull

With how many updates are coming out I threw together a script to parse the latest version from the webpage,...

2017-07-12 (first published: 2017-07-03)

1,602 reads

External Tool VSCODE called from SQL Management Studio

• by Sheldon Hull

• Sheldon Hull

Previous Related Post:
Split personality text editing in SSMS with Sublime Text 3
In this prior post I wrote about how...

2017-06-26

399 reads

Powershell Module Improvements for SQL Server in 2017

• by Sheldon Hull

• Sheldon Hull

simple setup
A major improvement that seems to have quietly slipped into the sql developers world is an improved SQLServer powershell...

2017-06-19 (first published: 2017-05-31)

2,181 reads

Best Practices: Defining Explicit Length for Varchar/Nvarchar

• by Sheldon Hull

• Sheldon Hull

SA0080 : Do not use VARCHAR or NVARCHAR data types without specifying length. Level: Warning
When using varchar/nvarchar it should be explicitly...

2017-06-07

537 reads

Setting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev

• by Sheldon Hull

• Sheldon Hull

InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...

2017-05-29 (first published: 2017-05-17)

3,750 reads

Red Gate SQL Clone (#1) - Initial Setup

• by Sheldon Hull

• Sheldon Hull

Note this was during earlier beta usage, so some of the UI and other features will have been updated more....

2017-02-27

695 reads

Bad Idea Jeans: Query Optimization Through Minification

• by Sheldon Hull

• Sheldon Hull

SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...

2017-01-23

408 reads

Bad Idea Jeans: Query Optimization Through Minification

• by Sheldon Hull

• Sheldon Hull

SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...

2017-01-23

217 reads

Dynamically Set Powershell Variables from json

• by Sheldon Hull

• Sheldon Hull

I created this small snippet to allow a list of values from a json file be turned into variables to...

2016-12-05

262 reads