The Troubleshooting List
SQL Server guru Andy Warren brings us a list of things that he considers when things go wrong. Read about some of the common sense approaches to solving performance and other problems.
The Value of Information
If I have accomplished anything, it is because I have stood on the shoulders of giants.
Half a Million
We crossed the 500,000 member mark last week and we're looking to give away some prizes!
Seamless Upgrade
One of the things mentioned in a keynote at the recent PASS conference was the idea that SQL Server 2008 would be a seamless upgrade. Or maybe I misunderstood and it will seem less like an upgrade 🙂
SQL Server and SOX
The Sarbanes-Oxley act has changed many IT jobs, usually requiring more work and documentation. Johan Bijnens brings us a list of some things his team has had to do to comply with SOX regulations.
BULK recovery mode and DBCC DBREINDEX
Will changing to bulk recovery mode before running DBCC REINDEX help you avoid large log files? András investigates
Data Warehouse Quality Assurance Best Practices
Collaboration between IT and the business will help identify the reasonable issues versus the issues that cannot be resolved for the current release of the data warehouse.
Compliance
The Sarbanes-Oxley act has become a four letter word to many IT people in the US. Thankfully I only had to deal with it for about 9 months before I left to go work on my own, but it was a long 9 months. Especially since I did half the work with JD Edwards and then did it again with Peoplesoft 🙁
Working Your SOX Off
The Sarbanes-Oxley act has drastically changed the jobs of many DBAs with the audit and reporting requirements this act entails. Brandie Tarvin brings us some hints about how you can go about complying with the new requirements.
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers