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.
When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.
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 resources in untrusted domains with windows authentication can be tricky. Here's how to make it easy.
Data analysis can save money and resources, but it will certainly transform our world.
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 popularity of SQL Server seems to be high, but there might be reasons to be concerned.
With the WMI Event Watcher Task in SSIS we can import files as soon as they arrive.
If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers