SQL Server Service Broker Security
Arshad Ali examines the different types and different layers of security that SQL Server Service Broker provides during communication and while accessing Service Broker objects.
Sabbaticals
This editorial was originally published on Oct 25, 2005. Steve Jones talks about the idea of a sabbatical from work and the problems that might ensue if you haven't properly planned it.
SQL Overview Part 1
Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.
SQL Server 2008 and 2008 R2 Integration Services - FTP Task
FTP Task lets you copy files across distributed, frequently incompatible systems.
A Little Interviewing Advice
This editorial was originally published on October 20, 2005. It is being reprinted as Steve is on vacation. I know there was a great uproar over the interview piece at the beginning of this week and I received lots of opinions on various parts of the article, good and bad to go over. But one […]
First Normal Form
Learn the basics of first normal form and what that means to a database designer from Tom Thomson.
SQL Server Central Management Server Security
I have seen several tips on SQL Server Central Management Server and I want to implement the technology for my team. The only thing holding me back is security. Can you explain how security works with Central Management Server? What security access is needed to manage CMS? How about connecting to CMS? How about running a query using CMS? Check out this tip to answer these questions.
Changing the Oil In Your Server
Today we have a guest editorial from Andy Warren. We have regular maintenance that needs to be performed on our cars, and also regular maintenance that needs to be done on our servers. Andy points out that companies need to understand this and make sure these regular activities are performed.
Identify Local Administrators on a SQL Server box using PowerShell
I want to determine who the local administrators are on each of my SQL Servers. Basically, I'd like a nightly job to run against each of my SQL Servers and produce a list of admins for each server for my review. How can I do this?
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