Best Practices: Defining Explicit Length for Varchar/Nvarchar
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
743 reads
Sheldon Hull
Powershell Module Improvements for SQL Server in 2017
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,220 reads
Setting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
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)
4,086 reads
Red Gate SQL Clone (#1) - Initial Setup
Note this was during earlier beta usage, so some of the UI and other features will have been updated more....
2017-02-27
705 reads
Bad Idea Jeans: Query Optimization Through Minification
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...
2017-01-23
220 reads
Bad Idea Jeans: Query Optimization Through Minification
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...
2017-01-23
479 reads
Dynamically Set Powershell Variables from json
I created this small snippet to allow a list of values from a json file be turned into variables to...
2016-12-05
302 reads
Attaching Database Using SMO & Powershell
Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...
2016-11-18
1,082 reads
Parallel Powershell for Running SQL
This is just a quick look. I plan on diving into this in the future more, as I'm still working...
2016-11-16
219 reads
Parallel Powershell for Running SQL
This is just a quick look. I plan on diving into this in the future more, as I'm still working...
2016-11-16
3,371 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers