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.
Security Basics: Physical Security
In IT security, we spend so much time trying to protect servers and computers on the wire (or on wireless) that we look at OS patches, firewalls, anti-malware, etc., to protect our systems. We typically assume our physical security is sufficient. But...
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers