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
736 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,083 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,370 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers