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

A Front Door for the DBA Team – AgentDBA UI

By

AgentDBA began as a command line. That suits one DBA on one server, but...

Cleaning Up Azure MS Defender Billing

By

I have a few Azure subscriptions, which are fairly small and not used that...

Installing and Configuring containerd as a Kubernetes Container Runtime

By

This post shows you how to install containerd as the container runtime for Kubernetes...

Read the latest Blogs

Forums

Alamat Telp BCA KCP Siliwangi (+62) 838-4945-0961

By layanan 24jam BCA

Wa:083849450961 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141

Alamat Telp BCA KCU SIDOARJO (+62) 838-4945-0961

By m4l4mt194

Wa:083849450961 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...

Layanan BCA KCU TASIKMALAYA Telp:0817°82°5533

By R4nt4u

Telp/Wa 62817825533 Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kota Tasikmalaya, Jawa Barat 46124

Visit the forum

Question of the Day

SQL Server Vector Support II

With regard to SQL Server 2025's Vector support, what is an embedding?

See possible answers