External Article

Managing Test Data as a Database CI Component - Part 1

Constructing a test environment for your databases can be a difficult task at the best of times. Once you’ve actually acquired the hardware needed and architected the environment, you still have to arrange and securely transport the data. And with the rising demand for fast feedback and continuously integrated processes, having all of this automated and operating at speed is a challenge all of its own.

External Article

Bowled Over by SQL Window Functions

What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic function, as well as how to pivot rows into columns using a crosstab query? Create the SQL code to score Ten-pin Bowling, of course. Dwain Camps explains the how, what and why.

Blogs

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

By

Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...

Future IT Roles – Agentic Architect and AI Boom!!

By

These days everything is changing to AI World, IT roles are getting changed and...

Free Webinar about Columnstore Indexes

By

I’m doing a small series on indexing basics for SQL Server, and on May...

Read the latest Blogs

Forums

BCA KCP Saharjo Hubungi Cs.0851•8812•0691

By vitaminaal

BCA KCP Saharjo Hubungi Cs.0851•8812•0691 Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet,...

Call Center Batik Air 24 jam Bebas Pulsa

By robert.m.ramus

Anda bisa menghubungi Call Center Batik Air Bebas Pulsa Melalui WhatsApp 0838 97 00...

BCA KCU MUARA KARANG TLP/WA 08216366654

By ASAPRoofing

Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers