DBA Skills: Striped Backup Video
Watch this short video on creating a striped backup for your database.
Application Containers For Cloud Computing
Containers promise to make applications more portable and efficient. The technology, originally based on Linux's cgroups, provides a way of running several applications as modular, platform-agnostic packages in isolation on the same server. Docker's open-source approach to containers has dominated the market, and Microsoft is producing its own equivalent Windows system. What next? Will Containers replace VMS? Robert Sheldon investigates.
SQL Injection, Still?
We still have problems with SQL Injection. Steve Jones has a few thoughts on why.
The Real World: Rebuilding Index - 1 Instance, 106 Databases
The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.
Automate SQL Server Express Backups and Purge Old Backups
SQL Server Express Edition does not include SQL Server Agent in order to schedule the SQL Server database backups. Here's how to automate the backups for SQL Server Express Edition and make sure the old backup files are deleted.
SQL Monitor Custom Metric: Tempdb Allocation Contention
If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Tempdb is shared by all databases and is used for many operations in a SQL Server instance, so it is common for tempdb to cause performance problems.
Salaries and Experience
Experience matters in setting your salary, but Steve Jones reminds us there are different types of experience, and there's more to life than money.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Saharjo Hubungi Cs.0851•8812•0691
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
Anda bisa menghubungi Call Center Batik Air Bebas Pulsa Melalui WhatsApp 0838 97 00...
BCA KCU MUARA KARANG TLP/WA 08216366654
Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers