Laptop to Build Hyper-V Test Lab - Part 1
This is the first Video of the series, will show you how to configure Hyper-V and then create several VM’s to configure AlwaysOn
2020-07-14
29 reads
On Dynamic Ports, Named Instances, and Firewalls
Recently I had a client and their vendor trying to configure a firewall for a new installation of SQL Server 2019 on Windows Server 2019.Connections to the SQL Server...
2020-07-17 (first published: 2020-07-13)
1,295 reads
Daily Coping 13 Jul 2020
I’ve 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...
2020-07-13
26 reads
The SSIS Catalog: Install, Manage, Secure, and Monitor your Enterprise ETL Infrastructure
I’m happy to announce the publication of my latest book. The SSIS Catalog: Install, Manage, Secure, and Monitor your Enterprise ETL Infrastructure is now available on Amazon in both...
2020-07-13
51 reads
Big Data Storage in Microsoft Azure
Azure storage is a Microsoft solution designed to store your data on it with different models (Blobs, Tables, Queue, File Shares, and Disks) to know the differences, usage, High...
2020-07-12
23 reads
Last Week Reading (2020-07-12)
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions. Simplifying declarative deployments in Azure The power of What-If within ARM Template deployments. Collecting custom...
2020-07-12
68 reads
Daily Coping 10 Jul 2020
I’ve 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...
2020-07-10
47 reads
BBQ Time in Texas
My first go at smokin’ a brisket is documented below. It is summertime and we are stuck at home in isolation, might as well find a new hobby. I...
2020-07-09
13 reads
Daily Coping 9 Jul 2020
I’ve 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...
2020-07-09
43 reads
Refreshing a Power BI Dataset in Azure Data Factory
I recently needed to ensure that a Power BI imported dataset would be refreshed after populating data in my data mart. I was already using Azure Data Factory to...
2020-07-21 (first published: 2020-07-09)
427 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers