SQLPSX 1.6.1 Release
I completed a maintenance release of SQL Server PowerShell Extensions, which address all known open issues. This release is still...
2009-09-02
635 reads
Blog Posts
SQLSaturday #21 Schedule Announced
Jack Corbett sweated over the schedule, not easy to decide what sessions to use and where to put them, but...
2009-09-02
328 reads
Thinking on Business Cards & Connecting
I’ve been thinking about the problem of connecting people at events for a while – what could we do to make...
2009-09-02
1,442 reads
TSQLScripts.com and IE 8
Wow, I just got an email from a registered member of www.tsqlscripts stating that it is not compatible with IE...
2009-09-02
588 reads
Tulsa TechFest to be Held November 7, 2009
The next annual Tulsa TechFest will be held on Saturday, November 7, 2009, at the Tulsa Community College in Tulsa,...
2009-09-02
545 reads
Use the Best Tool for the Task
Last February I wrote an article for Simple-Talk called Let PowerShell do an Inventory of your Servers . This script was...
2009-09-02
364 reads
24 Hours of PASS Tonight
For those of you who may have missed it, the 24 Hours of PASS conference starts tonight at 8pm EDT!...
2009-09-01
430 reads
Building a Pipeline
While I try to write most days, I don’t always podcast, and I only schedule things a day or two...
2009-09-01
390 reads
Indexing HierarchyID
The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...
2009-09-01
3,744 reads
Keeping a Low Profile
I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly...
2009-09-01
567 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Two queries work until compared with EXCEPT statement
I've got multiple databases on 2 SQL 2019 CU32 servers , all using the...
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers