Checking SQL Server Agent jobs using Windows PowerShell
Checking for SQL Server Agent jobs and their status is part of your daily task as a DBA. How do we use Windows PowerShell to check for SQL Server Agent jobs?
SQL Server 2008 Learning Guide
This guide provides an in-depth look at SQL Server 2008, with information on upgrading, overviews of the most important new features, and details on future releases.
Virtualization Hints
More and more people are looking at virtual servers, but it's not as simple as just installing the software. Steve Jones has a few comments about virtual database servers and what you can do for a successful project.
Virtualization Hints
More and more people are looking at virtual servers, but it's not as simple as just installing the software. Steve Jones has a few comments about virtual database servers and what you can do for a successful project.
Virtualization Hints
More and more people are looking at virtual servers, but it's not as simple as just installing the software. Steve Jones has a few comments about virtual database servers and what you can do for a successful project.
Celko's Summer SQL Stumpers: Prime numbers
Our first Stumper sees Joe Celko providing a conundrum with a prize for anyone who can come up with a better solution than he can.
Does Maturity Make a DBA?
Brad reflects on the characters of the DBAs he's met in his life, and suggests a common thread running through them all.
Exploring packages in code
This post builds on some of the previous code and shows how you can explore all objects inside a package. I took the sample Task Search application I’d written previously, and came up with a totally pointless little console application that just walks through the package and writes out the basic type and name of every object it finds, starting with the package itself e.g. Package – MyPackage .
Obtaining data changes with Change Tracking in SQL Server 2008
Yan Pan illustrates how to obtain data changes using the CHANGETABLE function and presents two algorithms that you can implement in your .NET application using Sync Services.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Sumatera CSTelpon : 0853-73737551
Jl. Aiptu K.S. Tubun No.46, Pandau Hulu I, Kec. Medan Kota, Kota Medan, Sumatera...
Tips baru Cara mengatasi transaksi pending di bank permata
Mengatasi transaksi pending di PermataBank (saldo berkurang namun transfer/pembayaran belum berhasil) dapat dilakukan dengan...
BCA KCU MANGGA DUA RAYA Telpon/wa.085373737699
BCA KCU MANGGA DUA RAYA Telpon/wa.085373737699.Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers