Expose Multiple Docker Ports
I was working with containers recently with Jenkins. I didn’t want the server process running on my machine all the time, but I did need to allow some communication....
2019-08-21 (first published: 2019-08-07)
394 reads
Blog Posts
Temporary stored procedures
tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) ... Continue reading
2019-08-21 (first published: 2019-08-07)
918 reads
7th Anniversary
7 years ago today I posted my very first blog post and I’ll tell you it’s been a heck of ... Continue reading
2019-08-20
20 reads
A Memory-Optimized Roundup – T-SQL Tuesday #117
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was scrambling a bit, but since I’ve worked with a few customers in the last year...
2019-08-20
24 reads
How do you debug your spark-dotnet app in visual studio?
When you run an application using spark-dotnet, to launch the application you need to use spark-submit to start a java virtual machine which starts the spark-dotnet driver which then...
2019-08-20
7 reads
How do you debug your spark-dotnet app in visual studio?
When you run an application using spark-dotnet, to launch the application you need to use spark-submit to start a java virtual machine which starts the spark-dotnet driver which then...
2019-08-20
34 reads
July 2019 – New Microsoft security update for Spectre variant
If you remember the flurry of news from the beginning of 2018 about side channel attacks called Spectre and Meltdown, Microsoft has included in its July update a patch...
2019-08-20 (first published: 2019-08-07)
361 reads
My Preferences for SSIS Design
Lately, I have been using SSIS execution frameworks and Biml created by other people to populate data marts and data warehouses. It has taught me a few things and...
2019-08-20 (first published: 2019-08-08)
1,166 reads
5 Things You Need To Know When Reading SQL Server Execution Plans
Watch this week’s episode on YouTube. 5 Things You Need To Know When Reading SQL Server Execution Plans In the first part of this series I explained what an execution...
2019-08-19 (first published: 2019-08-06)
1,311 reads
Azure DevOps: How to Set a Custom Release Branch Folder Filter in Build Pipeline Triggers (video)
This is the first in a series of posts about simple things that I had a hard time figuring out in Azure DevOps services. It can be very useful...
2019-08-19
64 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers