Support The Boss
Providing support for your manager or boss in getting his or her job is a good thing. Steve Jones comments on what benefits you might get and why this could enhance your career.
Unwelcome posts on our forums
As you may have noticed, we have been suffering recently from increased spam posts on the forums. This is something we're currently working to resolve.
My month with Release!
Alex and his team are developing a game about software and some of the people who make it. He looks at how games affected his office culture, what he’s learned about designing games to do more than just be fun, and how his team are hoping to share their passion with the developer community.
Using DBCC DROPCLEANBUFFERS When Testing Performance
Over the years I've had many discussions with other SQL Server Database Administrators as to whether or not you should have the database buffer pool loaded with data pages or empty when testing queries for performance. This tip will take a look at the effects on query performance for both cases by using the DBCC DROPCLEANBUFFERS statement to empty the buffer pool.
Data Mining Introduction Part 9: Microsoft Linear Regression
This is an introduction to the SQL Server Microsoft Linear Regression Algorithm.
Data Mining Introduction Part 9: Microsoft Linear Regression
This is an introduction to the SQL Server Microsoft Linear Regression Algorithm.
Go to a User Group
Are you in a rut? Feeling a bit bored at work writing the same ole code? Or perhaps you need a job and only wish you could be bored "at work"!
PowerShell One-Liners: Accessing, Handling and Writing Data
In the grand finale to Michael Sorens' series of PowerShell one-liners, we come to the handling of data, reading it in and writing it out, whether by files; input/output streams or a database. It shows how it can be done in a variety of formats including CSV, JSON, and XML.
Cloud Storage Security: Are You Doing Your Part?
If the level cloud storage encryption are so high, then why is the cloud security industry experiencing such distrust?
Automated testing in Microsoft Azure
Matthew Flatt was trying to measure the performance of a tool interacting with Microsoft Azure, and had trouble getting a consistent test. His solution? Run the tests on VMs in Azure, housed in the same data center as the blob storage.
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers