Blog Posts

Expose Multiple Docker Ports

• by Steve Jones

• The Voice of the DBA

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)

7 reads

Temporary stored procedures

• by Kenneth Fisher

• SQLStudies

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)

21 reads

7th Anniversary

• by Kenneth Fisher

• SQLStudies

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

4 reads

A Memory-Optimized Roundup – T-SQL Tuesday #117

• by Steve Jones

• The Voice of the DBA

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

4 reads

How do you debug your spark-dotnet app in visual studio?

• by Ed Elliott

• Ed Elliott's Sql Developer Blog

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

2 reads

July 2019 – New Microsoft security update for Spectre variant

• by Brian Kelley

• Databases – Infrastructure – Security

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)

254 reads

More PowerShell Remoting coverage in dbatools

• by Cludio-Silva

• Cláudio Silva

Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use of PowerShell Remoting. Which commands? Commands like Get-DbaComputerCertificate, Get-DbaPrivilege, Get-DbaClientAlias, just to mention a few...

2019-08-20

7 reads

My Preferences for SSIS Design

• by Meagan Longoria

• Data Savvy

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)

586 reads

5 Things You Need To Know When Reading SQL Server Execution Plans

• by Bert Wagner

• Bert Wagner

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)

812 reads

Actual Kubernetes

• by Steve Jones

• The Voice of the DBA

This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). I completed the first 3 sections (Days...

2019-08-19

12 reads