Office 365 Essentials - Subscriptions and Licenses
Should you be planning to move from Exchange to Office 365? If so, why? What sort of license should you get, and should you use cloud identities or federated identities for your users?
Stairway to T-SQL DML Level 12: Using the MERGE Statement
The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.
Yet Another Attack Vector
The lack of progress in amending our laws to handle the digital revolution in our leaves may leave us open to unexpected attacks.
Quickly Investigating What's in the Tables of SQL Server Databases
From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.
How to configure SSL encryption in SQL Server
Tibor Nagy explains how to configure Secure Sockets Layer (SSL) encryption on our SQL Servers, with a trusted certificate.
SQL Monitor Custom Metric: Out of memory errors
The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there.
Automate Your Central Management Server Registrations
Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.
Disconnecting Auditing
Currently we have system administrators responsible for securing our systems, including the auditing capabilities. However that's not the best way to ensure that we can protect our systems.
The Broad View
An ingenuous use of existing data leads to the thought - when are we so deep in our work that we can't see how to improve?
Common database deployment blockers and Continuous Delivery headaches
Deployability is now a first class concern for databases, so why isn’t it as easy as it should be? Matthew Skelton explores seven of the most common challenges which will bring your database deployments to their knees.
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