Deploy Dacpacs With PowerShell
Final Addendum – use dbatools!
Addendum – There is a repo on GitHub which I wrote and recommend using for build/deployment of DACPACs....
2017-09-26
7,465 reads
Policy Based Management and Powershell
Introduction
Policy Based Management (PBM) can be used to inform DBAs when an incorrect setting is being used on a SQL...
2017-10-04 (first published: 2017-09-26)
2,014 reads
DELETE data on SQL Server HEAP table - Did you know...
Before I complete my question let me provide context.
I’ve received an alert saying that a specific database could not allocate a new page (disk was full)
The message that you...
2017-09-26
24 reads
Query Azure CosmosDB from a SQL Server Linked Server
[read this post on Mr. Fox SQL blog] Recently I had a requirement to combine data that I already had in SQL Server (2016) with JSON document data already stored in...
2017-09-25
32 reads
Query Azure CosmosDB from a SQL Server Linked Server
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to combine data that I already had in SQL Server...
2017-10-02 (first published: 2017-09-25)
3,870 reads
Don’t forget to drop your views
I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created...
2017-10-02 (first published: 2017-09-25)
2,794 reads
SSIS Package Execution in Azure is Out Now
It’s been a long time coming, but now SQL Server Integration Services is in Public Preview on Azure!
I’ve written about...
2017-09-25
396 reads
Adding a Replica back into a SQL Server Availability Group
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-29 (first published: 2017-09-25)
2,814 reads
Oct 2, 2017 is the GA date for SQL Server 2017
Announced today at Microsoft Ignite, the general availability date is Oct 2, for Windows, Linux, and Docker. Time to get...
2017-09-25
499 reads
Sign up for Game Night
This year PASS is hosting Game Night as an official event, providing the room and support. Kevin Hill (b | t)...
2017-09-25
410 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers