SQL Homework – November 2019 – SSMS built in reports
Time for some homework again. I know Pass Summit is this week so you may be a bit busy but ... Continue reading
2019-11-04
33 reads
Blog Posts
SQL Server Stored Procedures vs Functions vs Views
Watch this week’s episode on YouTube. SQL Server has several ways to store queries for later executions. This makes developers happy because it allows them to follow DRY principles: Don’t Repeat Yourself....
2019-11-04 (first published: 2019-10-22)
3,036 reads
SQLSaturday Orlando Notes – Post Event Speaker Survey
One of the follow up items I have from the event was to poll speakers on what hotel they used (see my previous post). In jotting down some notes...
2019-11-04
29 reads
SSIS Scaleout: Cannot open certificate store on the machine
When attempting to connect a worker node to the current Master node of a SQL Server Integration Services (SSIS) Scaleout, for on-prem SQL Servers, if you receive the error:...
2019-11-04 (first published: 2019-10-22)
796 reads
Teams in SQL Clone and SQL Provision
SQL Clone v4 is out, and the big change is the addition of the Teams feature. I guess technically this is just for SQL Clone, which is included in...
2019-11-04
48 reads
You Are A Coder
So, you say you’re a DBA. I say you’re not. You say you’re a system administrator. I say you’re wrong. We are all coders now. Every single one of...
2019-11-04
38 reads
Last Week Reading (2019-11-03)
This week I’m offering you many posts about Cosmos DB, Azure Data Factory and how to design reliable Azure applications. Have a great week also for those of you...
2019-11-03
16 reads
SQLSaturday Orlando Notes – Designated Hotel
Almost every year we select an “official” hotel for the event. For those coming in who don’t know the area it’s a way to avoid figuring out what is...
2019-11-03
13 reads
Back to school
Hey, I realize that future we need to know Database system, No SQL and Big Data. with that as things are moving to machine learning and AI system which...
2019-11-02
17 reads
Why I’m Running For The PASS Board – Again
Hello, it’s amazing to me how fast the past couple of years have gone by as I’ve served on the PASS Board. It has been a journey that has...
2019-11-02
17 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers