- Easiest Rebuild Ever - Windows 7
I'm somewhat conservative with my machines. These days it's a tool for me, and I'm not looking for the coolest...
2009-08-31
1,670 reads
Blog Posts
Active August – Final Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-31
1,325 reads
Backing up to NUL vs Backup with Truncate only
Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...
2009-08-31
2,252 reads
Decompressing on Compression in SQL Server 2008....
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
2009-08-31
9,528 reads
Notes On the Jacksonville Code Camp
I drove up to Jacksonville Friday afternoon for the 2009 Jacksonville Code Camp led by my friend Bayer White. I...
2009-08-31
1,650 reads
Project Gemini
Dan English put up a blog post on his experiences with installing Gemini. His post is loaded with screen shots...
2009-08-31
1,367 reads
Scripting Server Side Traces
If you’ve never used SQL Server Profiler, you truly don’t know what your missing. And that statement has an intentional...
2009-08-31
1,649 reads
Setting Realistic Goals & Learning to Adjust
There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I...
2009-08-31
2,031 reads
SQL Lunch Calendar
We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am...
2009-08-31
1,721 reads
Submitted PASS Board Of Directors Application
Well after much deliberation I have decided to submit an application for the PASS Board of Directors. I embark on...
2009-08-31
1,417 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