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.
Using the WMI Event Watcher Task in SSIS to Process Data Files
With the WMI Event Watcher Task in SSIS we can import files as soon as they arrive.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
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