Data Mining Part 18: Excel and Data Mining
In this new article, we will introduce you to Microsoft Excel and Data Mining.
Data Mining Part 18: Excel and Data Mining
In this new article, we will introduce you to Microsoft Excel and Data Mining.
Backup and Restore Strategies in SQL Server – Part 1
You need to set up backup and restore strategies to recover data or minimize the risk of data loss in case a failure happens. In this article series, Arshad Ali discusses backup and restore strategies in SQL Server.
Solving Kerberos Issues in SSRS When Running Beside IIS
When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.
Improving the Quality of SQL Server Database Connections in the Cloud
To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile. TDS is still used to connect to databases in the cloud, but you need to use a combination of the new features such as connection pools and idle connection resiliency to make applications faster and more reliable. Edward Elliott shows you how.
Connecting to Analysis Services in Another Domain
Connecting to resources in untrusted domains with windows authentication can be tricky. Here's how to make it easy.
Saving Hard Dollars
Data analysis can save money and resources, but it will certainly transform our world.
SQL Server Reporting Services (SSRS) Log Files for Troubleshooting
Your SQL Server Report Server service will not start or you keep getting an error when you navigate to the SSRS URL? What logging tools are available to assist you with diagnosing SSRS problems, issues, or errors? Check out this tip to learn more.
The Decline of SQL Server
The popularity of SQL Server seems to be high, but there might be reasons to be concerned.
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 Pecenongan Tlpn/wa:085373737551
Jl. Pecenongan No.86, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
BCA KCP Raya Serpong,Telp/Wa 0821.3111.159
Jalan Raya Serpong 06, RT 008 RW 02, Pondok Jagung, Serpong Utara, Kota Tangerang...
BCA KCP Senayan City Tlpn/wa:085373737551
Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot 19, Daerah Khusus Ibukota Jakarta...
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