Articles

External Article

Optimizing Transaction Log Throughput

As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. This article demonstrates how this can have a significant impact on the performance of any SQL Server operations that need to read the log.

2014-05-27

3,916 reads

External Article

Do We Still Need Database Design in the Era of Big Data?

Many big data application implementations seem to begin with an existing data warehouse, one or more new high-volume data streams, and some specialized hardware and software. The data storage issue is often accommodated by installing a proprietary hardware appliance that can store huge amounts of data while providing extremely fast data access. In these cases, do we really need to worry about database design?

2014-05-26

5,297 reads

Blogs

Giving AI Agents Visibility Into SQL Server with MCP

By

I’ve been thinking a lot lately about what it actually takes to make an...

The Book of Redgate: Profits

By

Redgate is a for-profit company. We look to make money by building and selling...

Session Materials for Techorama & DataGrillen 2026

By

I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...

Read the latest Blogs

Forums

Stop Prompting Your AI Agent. Give It a Playbook.

By Kumar Abhishek

Comments posted to this topic are about the item Stop Prompting Your AI Agent....

Finish the quote

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finish the quote

Everything I Needed to Know Used to be Found in One Book

By Kathi Kellenberger

Comments posted to this topic are about the item Everything I Needed to Know...

Visit the forum

Question of the Day

Finish the quote

Finish this quote (for a fun Memorial Day question):

Do not try and bend the spoon. That's impossible. ...

See possible answers