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
749 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,088 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
706 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,372 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers