SQL Server – How to get sizes of all databases on a server
To get database size information we can use sys.master_files catalog view. This view contains a row per file of a...
2013-06-10
1,278 reads
Blog Posts
SQL Server 2014 Announced
Introduction
A week late and more than a few dollars short, this blog post is focusing on a few of the features announced for SQL Sever 2014. I’ve watched the...
2013-06-10
7 reads
Time to Complete the 2013 BI Survey
It’s that time of year again… end of the school year, graduation, Fathers’ Day and of course; time to take...
2013-06-10
501 reads
Using the OVER clause
Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has...
2013-06-10
697 reads
Client Pressures and Code Quality
In my experience, code quality always trumps urgency because when code has been released that has questionable quality, it is...
2013-06-09
436 reads
PASS SQL Saturday Events : June 2013
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2013-06-09
937 reads
PASS Summit 2013
PASS Summit is the world's largest and most intensive technical training conference for Microsoft SQL Server and BI professionals. But more...
2013-06-09
679 reads
PASS Virtual Chapter Events : June 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-06-09
1,014 reads
Cumulative Updates - SQL Server 2012 SP1 CU4
As part of theirIncremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #4.http://support.microsoft.com/kb/2833645
To apply this cumulative update package, you must be running SQL Server...
2013-06-08
17 reads
Temporary Post Used For Theme Detection (a44a873d-b704-4244-9b75-dfa7037289c9 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (155546b7-60c9-4c5a-baba-268c38ebcf1a – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
You just finished reading Temporary Post...
2013-06-08
627 reads
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