Handling Data Integrity Issues in Analysis Services 2005
Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.
Tame Your Software Dependencies for More Flexible Apps
Few would disagree that striving for a loosely coupled design is a bad thing. Unfortunately, the software we typically design is much more tightly coupled than we intend. How can you tell whether your design is tightly coupled?
Dynamic Connection Strings in Reporting Services 2005
Reporting Services is one of the most popular features of SQL Server 2005 and there have been a tremendous number of enhancements to this subsystem. New author Bilal Khawaja brings us a look at dynamic connection strings and how you can have one report pulling data from different servers.
Transactions in Transactional Replication
SQL Server MVP Paul Ibison takes a look at how transactions are handled in replicated environments and the implications of rollbacks.
Find blocking processes using recursion in SQL Server 2005
Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This can create a daisy-chain of processes waiting to complete their work.
Implementing Error Handling with Stored Procedures
A look at how you can implement error handling in your stored procedures.
SQL Server Index Checklist
Indexing a SQL Server database in some respects is considered both an art and a science. Since this is the case, what are some considerations when designing indexes for a new database or an existing one in production? Are these the same types of steps or not? Do any best practices really exist when it comes to indexing? Where does indexing fall in the priority list from an application or production support perspective?
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers