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
39 reads
Blog Posts
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)
799 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
62 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
46 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
17 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
23 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
27 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
21 reads
#PowershellBasics: Get-Help -Online
One of the other things I learned from the Powershell class I’m taking this week is that there is an ... Continue reading
2019-11-01 (first published: 2019-10-21)
473 reads
Good Resume Examples
I talk about resumes, enhancing your career, and finding your dream job at various events. This might be one of my most popular talks, and I’ve been lucky enough...
2019-11-01
347 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers