Configure SQL Server 2019 Multi-Subnet AlwaysOn Setup - Part 12

Daily Coping 12 Nov 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

PASS 2020 Board of Director Endorsements

The election for the next PASS Board of Directors starts today, with a slate of 7 for three spots. I asked them for their vision last week, I’ve read...

PASS Summit 2020 Precon – Scripts and Links

An attendee at my PASS Summit precon on virtualized SQL Server performance tuning on Monday asked a great question. “Do you have a list of the tools and scripts...

Vote in the PASS Election

If you login to pass.org AND have previously met the criteria to vote this year, you’ll see this. Click the button and you’ll be off to the voting page...

Daily Coping 11 Nov 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Deploy SSRS Projects with Two New PowerShell Commands

I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig & Publish-RsProject. While the Write-RsFolderContent...

External tables vs T-SQL views on files in a data lake

A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between using an external table versus...

Notes on the 2020 PASS Virtual Summit – Part 3

Tuesday notes! Today I’m in Execution Plans in Depth by Hugo Kornelis. Notes: Today the presenter is using the Cadmium/EventScribe platform instead of GotoWebinar Started off with a lot...

T-SQL Tuesday #132 - Coping With the Pandemic

This week is a double-whammy of activity - T-SQL Tuesday and PASS Summit 2020. T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month,...