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,196 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
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
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
Power BI Custom Visuals Class (Module 72 – HTML Viewer)
In this module you will learn how to use the HTML Viewer. The HTML Viewer allows you to display the...
2017-10-17 (first published: 2017-10-09)
1,821 reads
SQL Server 2017 Encrypted Backups And Compression
Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...
2017-10-18 (first published: 2017-10-09)
3,111 reads
Small identity columns
We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small...
2017-10-17 (first published: 2017-10-09)
1,850 reads
Understanding ANOVA
ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze...
2017-10-16 (first published: 2017-10-09)
2,542 reads
SpeedPASS Download Naming Convention
This was the first time in a long time that I managed the check-in process of SQLSaturday Orlando and was...
2017-10-18 (first published: 2017-10-09)
1,522 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
Alamat Kantor BCA KCU Galaxy Tlp:(08218154374)
WA CS 628218154374 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya,...
Alamat Kantor BCA KCU Malang Tlp:(08217555651)
WA CS 628217555651 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa...
Alamat Kantor BCA KCU Rungkut Tlp:(0817825533)
WA CS 628217825533 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers