Articles

External Article

SQL Server 2008 and 2008 R2 Integration Services - Managing Local Processes Using Script Task

SQL Server 2008 R2 Integration Services includes a number of predefined tasks that implement common administrative actions to help with data extraction, transformation and loading (ETL). While in a majority of cases they are sufficient to deliver required functionality, there might be situations where an extra level of flexibility is desired.

2011-03-17

3,010 reads

External Article

Lipoaspiration in your SQL Server Database

Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.

2011-03-16

4,312 reads

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

There's Too Much to Learn

By Steve Jones - SSC Editor

Comments posted to this topic are about the item There's Too Much to Learn

How to Calculate Distance Between Coordinates in SQL Server

By Imran2629

Comments posted to this topic are about the item How to Calculate Distance Between...

SSoL Support on the OS

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SSoL Support on the OS

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