Date Fun with SQL Server
I saw a people discussing date formats on Twitter after PASS put out an advertisement for a webinar with a...
2018-04-03
400 reads
Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
55 reads
Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
292 reads
Why Projects Fail...Free Session, Free Beer and Free Food
Why Projects Fail...Free Session, Free Beer and Free Food
Mark Williams and myself will delivering a seminar called #Not the GDPR news in...
2018-04-03
324 reads
Azure SQL Database – Failed to Delete Database Nightmare
After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....
2018-04-03
375 reads
Remembering Robert Davis, aka @SQLSoldier
I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...
2018-04-03
46 reads
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Watch this week’s episode on YouTube.
In this week’s video with Power BI expert Eugene Meidinger, we’re in the kitchen learning...
2018-04-10 (first published: 2018-04-03)
2,038 reads
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...
2018-04-03
15 reads
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...
2018-04-03
10 reads
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...
2018-04-03
570 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