Multiple Regression Model Enhanced with Bagging
This article explains what bagging is relative to a basic decision tree model and demonstrates how to apply bagging for better multiple regression model fits to data from SQL Server.
2021-01-20
Additional Articles
DAX financial functions: Depreciation calculations
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.
2021-01-19
Ten Reasons your SQL Server Monitoring will Scale
This article explains ten ways that SQL Monitor tackles the problem of scaling out the coverage of a single, lightweight monitoring system, and so allows your teams to maintain the health and performance of larger collections of databases and higher numbers of monitored SQL servers.
2021-01-19
SQL Server Monitoring for all Availability Groups
In this article we present a PowerShell script that can help you monitor all of your SQL Server Availability Groups in your environment.
2021-01-18
Azure Blob Storage Data Upload with SSIS
In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.
2021-01-15
Using SQL Compare and SQL Data Compare within a PowerShell Cmdlet
SQL Compare and SQL Data Compare can be used together, from the command line, to provide a complete build process, or to script out changes to both the database and its development data. For doing this routinely, I find it easiest to script the operation using PowerShell.
2021-01-15
Dynamic Power BI Slicer Using DAX Logic
Learn how to create dynamic data slicers in Power BI with this step by step example to show how this can be done.
2021-01-14
Getting your SQL Server Development Data in Three Easy Steps
Phil Factor takes a staged approach to generating development data, creating one project that simply copies data from an existing database, another that copies most data but generates any personal or sensitive data, and a third that starts from 'anonymized' data and then generates other columns entirely and increase the number of rows for testing.
2021-01-14
Optimize SQL Server estate monitoring with Redgate's SQL Monitor
How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?
2021-01-13
How to Check SQL Server Version When Service is Not Running
In this article we look at several ways to find the version of SQL Server that is installed when the SQL Server service is not running.
2021-01-12
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kas Meruyung No.Telp:087757645171
Whatsapp:087757645171 Jl. Cinere Raya Jl. Meruyung Raya No.45 H, Rangkapan Jaya Baru, Kec. Pancoran...
BCA KCP Gresik telp:cs.083188951403
Whatsapp:083188951403 Jl. Dr. Soetomo No.48, Ngipik, Karangpoh, Kec. Gresik, Kabupaten Gresik, Jawa Timur 61111
Kantor BCA KCU Bekasi Telp/wa 085169998765
BCA Bekasi Telp/wa 085169998765 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel.,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers