PowerShell–Don’t Use Write-Host
I’ve written a few scripts and programs lately, mostly just for fun. In those scripts, I’ve used Write-Host to return...
2016-03-04
1,638 reads
Excel Tip #30: Excel Services Visual Limitations – Displaying Images
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2016-03-14 (first published: 2016-03-04)
1,717 reads
Speaker of the Month: March 2016
I’m finally getting back out to community events so I should be able to avoid giving this gigantic honor to professional...
2016-03-04
409 reads
Backing up to URL container name – case is important
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name...
2016-03-11 (first published: 2016-03-03)
1,223 reads
Post Deploy Scripts In Composite Dacpac's not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
811 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy into a database as a whole. Even if you...
2016-03-03
6 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
46 reads
Post Deploy Scripts In Composite Dacpacs not deploying
Composite projects in SSDT are a really useful way to logically split databases up while still being able to deploy...
2016-03-03
38 reads
VMware CPU Co-Stop and SQL Server Performance
Not too many people know about the intricacies of virtualization CPU scheduling and its impact on the performance of the VMs,...
2016-03-09 (first published: 2016-03-03)
1,444 reads
How to Grant Permissions Only on the Replica in Database Mirroring and AlwaysOn AG
You work with Database Mirroring or AlwaysOn AG, and you want to make sure your end users work only on...
2016-03-03
310 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers