Where Have all the DBAs and DB DEVs Gone?
Last week the SQL community and in particular the blogosphere, was buzzing with interest noise following the Microsoft Learning site...
2012-04-17
889 reads
How to use Report Builder 3.0
I did a webinar during the 12 days of 2012 on how to use Report Builder 3.0. In this webinar...
2012-04-16
1,464 reads
Creating a User without a Login – Contained Databases
In SQL Server 2012, we have a new feature: partially contained databases. In a previous post, I showed how to...
2012-04-16
12,431 reads
SQL Saturday #111 Atlanta recap and links and stuff and things….
I particularly enjoy SQL Saturdays in Atlanta for a few reasons. It gives me an excellent excuse to come out...
2012-04-16
699 reads
SQLSaturday in Houston
I will be speaking at the Houston SQLSaturday this upcoming Saturday (April 21st). Below is info on my session, which...
2012-04-16
631 reads
Three Mistakes Managers Make
I suppose there is an almost limitless number of mistakes that managers can do and do make, it’s the nature...
2012-04-16
1,019 reads
10 must follow blogs that might not be in your list
There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday)....
2012-04-16
1,789 reads
SQLSaturday #151 Announced–Orlando!
Just got the email, Orlando will be having its sixth annual SQLSaturday this year on September 29th, 2012, at Seminole...
2012-04-16
570 reads
Script to analyse space usage by your Service Broker
I believe that service broker is one of the best features from SQL server 2005, well along with the xml...
2012-04-16
2,500 reads
Instant File Initialization Security Risk
A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...
2012-04-16
953 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