Restoring Backups from Azure Blob with dbatools
Recently I needed to write a PowerShell script that could build a backup set from a collection of backups stored in Azure Blob Storage without any backup history available...
2019-09-15
45 reads
Blog Posts
Good to see you at Houston Tech Fest 2019!
It was awesome to see a great crowd at the triumphant return of Houston Tech Fest 2019. This year's event was hosted at the beautiful Microsoft Office in Houston....
2019-09-14
18 reads
Using kubectl logs to read the SQL Server Error Log in Kubernetes
When working with SQL Server running containers the Error Log is written to standard out. Kubernetes will expose that information to you via kubectl. Let’s check out how it...
2019-09-14
230 reads
Using kubectl logs to read the SQL Server Error Log in Kubernetes
When working with SQL Server running containers the Error Log is written to standard out. Kubernetes will expose that information to you via kubectl. Let’s check out how it...
2019-09-14
3 reads
Using kubectl logs to read the SQL Server Error Log in Kubernetes
When working with SQL Server running containers the Error Log is written to standard out. Kubernetes will expose that information to you via kubectl. Let’s check out how it...
2019-09-14
11 reads
Moving to Azure SQL Database Serverless
In a previous post, I discussed the public preview of Azure SQL Database Serverless. This is a newer product released from Microsoft for the Azure ecosystem. Moving to this...
2019-09-13 (first published: 2019-08-30)
962 reads
New Pluralsight Course – Managing Kubernetes Controllers and Deployments
My new course “Managing Kubernetes Controllers and Deployments” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! This course offers practical tips from my...
2019-09-13
90 reads
New Pluralsight Course – Managing Kubernetes Controllers and Deployments
My new course “Managing Kubernetes Controllers and Deployments” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! This course offers practical tips from my...
2019-09-13
3 reads
New Pluralsight Course – Managing Kubernetes Controllers and Deployments
My new course “Managing Kubernetes Controllers and Deployments” in now available on Pluralsight here! Check out the trailer here or if you want to dive right in go here! This course offers practical tips from my...
2019-09-13
1 reads
Quick Blog: Clone Power BI Workspace Permissions
However, one detail they left out of that post is how to clone the users & groups, and their respective permissions from one Workspace to another. It's a pretty...
2019-09-13 (first published: 2019-09-03)
248 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
SQL Server Auditing: Track Changes by Specific Users on Specific Database Tables
Hello Everyone! My organization is looking to implement a solution in SQL Server (2019...
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers