For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does.
Steve Jones comments on a few pieces of interesting SQL Server news this week, including Service Pack 3.
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
Implementing a dialog between two services residing in a distributed environment requires the presence of an authentication mechanism. Windows-based Kerberos protocol limits the scope of systems participating in a Service Broker dialog to those residing in the same or trusted Active Directory domains. This article provides an overview of how to eliminate this limitation by employing certificates.
Microsoft updates SQL Server on a pretty regular basis. Its newest version, SQL Server 2008, includes some new features not found in older versions. Here's a list of some of them
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about.
Things on the ranch inspire Steve Jones in the rest of his life. He's one you might not have thought about.
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers