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,231 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
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
764 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,101 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
707 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
490 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
222 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,091 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,378 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
230 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers