Additional 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

Technical 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?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2014-05-26

5,297 reads

External Article

Producing JSON Documents from SQL Server queries via TSQL

Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is in so much demand. Maybe, Phil Factor suggests, it is possible to leverage all that XML, and XPath, goodness in SQL Server to produce JSON in a versatile way from SQL Queries? Yes, it so happens that there are plenty of alternatives.

2014-05-22

8,456 reads

Blogs

How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents

By

Your AI is busy. But do you know what it's worth? Most companies can...

Speeding Up Patching – Beyond Patch Delivery

By

I wear many hats in technology, and one of those is as a (cyber)security...

Monday Monitor Tips: Query Recommendations

By

We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...

Read the latest Blogs

Forums

Alamat BCA KCP Raden Saleh +62 838-4945-0961

By Halo_BCA

Wa:083849450961 Jl. Raden Saleh Raya No.17A No. 13, 15, RT.1/RW.2, Kenari, Kec. Senen, Kota...

Azure SQL Hyperscale Unveiled

By Site Owners

Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled

What is the worst part about existing monitoring solutions?

By Evgenii Vaniukov

Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...

Visit the forum

Question of the Day

SQL Server Vector Support I

What are vectors in SQL Server 2025, as related to the new AI features?

See possible answers