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
662 reads
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
662 reads
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,210 reads
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,052 reads
Note this was during earlier beta usage, so some of the UI and other features will have been updated more....
2017-02-27
703 reads
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...
2017-01-23
219 reads
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...
2017-01-23
468 reads
I created this small snippet to allow a list of values from a json file be turned into variables to...
2016-12-05
276 reads
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,067 reads
This is just a quick look. I plan on diving into this in the future more, as I'm still working...
2016-11-16
214 reads
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,170 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers