2,560
Two Thousand Five Hundred Sixty. Seems like such a random and unassuming number, however, I can say this was the...
2012-10-23
1,441 reads
Kyle Neier
Vacation and SQLSat149
When I was considering submitting some sessions to SQL Saturday 149 in Minnesota I thought I would have a difficult...
2012-09-22
801 reads
T-SQL: Performance of SQL Agent Duration Calculations
In my article published yesterday on using Powershell for SQL Durations (Working with SQL Agent Durations), I proposed using a...
2012-08-24
1,614 reads
Nacho Mama’s Training Class
That is what I wanted to name the new training series that we developed at my employer, Perpetual Technologies (PTI.net)....
2012-08-09
1,017 reads
SQL Saturday 122: T-SQL 2012 presentation
This last weekend, I had the pleasure of being invited down to Louisville, KY to speak at SQL Saturday #122....
2012-07-24
990 reads
Speaking at SQL Saturday 122 - Louisville
It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been...
2012-07-09
866 reads
Powershell Add-Member: IsLogBackupAllowed ?
In my previous post, I shared some of the issues I had when attempting to get Add-Member to work with...
2012-07-05
1,495 reads
Powershell, SMO, and Add-Member - Not Always BFF
Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...
2012-07-04 (first published: 2012-06-28)
3,946 reads
Enumerating Index Fragmentation with Powershell and SMO
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,735 reads
Powershell Add-Type – Where’s That Assembly!
I’ve been working a lot lately with SMO and the differences between the various versions between SQL 2005, 2008, and...
2012-06-06
17,444 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers