Building Custom Reporting Services Reports for SQL Server Management Studio
Learn how to build Custom Reports, without installing Reporting Services, using a new feature found in Microsoft Service Pack 2 (SP2) for SQL Server 2005.
The Burden of Proof - iPod
Steve Jones asks about the disclosure of source code in legal proceedings.
The Burden of Proof - MP3
Steve Jones asks about the disclosure of source code in legal proceedings.
The Burden of Proof - WMV
Steve Jones asks about the disclosure of source code in legal proceedings.
The Data Stewardship Approach to Data Governance: Chapter 4
If you have considered deploying a Data Governance program at your organization, the chances are that you have asked the following question: "Where does Data Governance fit into the Organization?"
Feedback
Corporate management often asks for feedback and buy-in with their ideas and programs. Why don't they get it?
Generating Missing Dates and Numbers
Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.
Regular Expression Transformation
The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. If all columns selected pass their tests then rows are passed down the successful match output. Rows that fail to pass all tests are directed down the alternate output.
The Baker's Dozen: 13 Comparisons Between Crystal Reports and SQL Server Reporting Services
Explore how the rich reporting functionality in Crystal Reports XI and SQL Server Reporting Services 2005 works with common reporting requirements.
A Look at Log Explorer
Have you ever wanted to read your transaction log? Wonder what information is inside there? New author S. Srivathsani takes a look at one of the log tools out on the market, Lumigent's Log Explorer.
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
Forums
Compatibility levels on database changing them and impacts.
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers