Kill a Connection, Session, or Command in Analysis Services
One of the useful features of the SSAS Activity Monitor is the ability to cancel sessions and queries. Though there is...
2017-10-10
3,195 reads
Blog Posts
Power BI Custom Visuals Class (Module 71 – Timeline Storyteller)
In this module you will learn how to use the Timeline Storyteller. The Timeline Storyteller is a great way to...
2017-10-10 (first published: 2017-10-02)
2,040 reads
Toolbox - Fix Your FILEGROWTH
One of the items we usually flag in reports is FILEGROWTH by percentage. It doesn't help that for most versions...
2017-10-10 (first published: 2017-10-05)
1,838 reads
Checking Out SQL Vulnerability Assessment
Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool...
2017-10-09 (first published: 2017-09-28)
1,597 reads
Microsoft Ignite US 2017 – Major Azure Announcements
[read this post on Mr. Fox SQL blog] Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major announcements across the entire solutions portfolio suite –...
2017-10-09
22 reads
Microsoft Ignite US 2017 – Major Azure Announcements
[read this post on Mr. Fox SQL blog]
Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major...
2017-10-09
456 reads
SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing
“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose...
2017-10-09 (first published: 2017-09-29)
2,327 reads
The evolution of SQL Server towards Digital Transformation challenges
SQL Server on Linux boosts the database market for Microsoft. Support of PolyBase (a feature to work with Big Data...
2017-10-09
367 reads
Using xp_delete_file
First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions,...
2017-10-09
1,258 reads
Failed SSIS Build – DtsRuntimeException
Hello!
I was helping a team debug a failed build today. Despite the fact that the build compiled on the devs...
2017-10-06
319 reads
Blogs
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....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Alamat BCA KCU PURWOKERTO Tlp:0817825533
WA CS 62817825533 Alamat Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim.,...
Alamat BCA KCU SOLO BARU Tlp:08217555651
WA CS 628217555651 Alamat Kawasan Terpadu The Park, Jl. Ir. Soekarno, Solo Baru, Madegondo,...
Alamat Kantor BCA KCU CILACAP Tlp:08218154374
WA CS 628218154374 Alamat Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers