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.
You Can Still Vote for PASS
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.
Ninja Immutable Databases
'Immutable' databases operate under the principle that data or objects should not be modified after they are created. Once again they hold the promise of providing strong consistency combined with horizontal read scalability, and built-in caching. Are Immutable databases a new idea? Are they different in any way from the mainstream RDBMSs?
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor Resmi BCA KCU MANADO Tlp:08218154393
WA:08218154393 Jl. Sam Ratulangi No.17-19, Wenang Utara, Kec. Wenang, Kota Manado, Sulawesi Utara 95111
Alamat Kantor Resmi BCA KCU PANAKKUKANG Tlp:08218154393
WA:08218154393 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan 90231
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers