Training To-Do List for New DBA
Are you an entry-level DBA, or looking to make the career switch? Feel like you are looking up from the...
2016-07-18 (first published: 2016-07-12)
4,947 reads
Will Assaf
SQLSaturday Baton Rouge 2016!
Free SQL Server, SharePoint and .NET training
SQLSaturday is a global event to bring Information Technology speakers and professionals together for...
2016-07-16
453 reads
SQL Server Admin Best Practices with DMV's at SQLSaturday Pensacola 2016
Great attendance and awesome questions from my 1130AM session on "SQL Server Admin Best Practices with DMV's". As promised, all...
2016-06-05
597 reads
SQLSaturday Pensacola Up Next For Me, Baton Rouge on the Horizon
Looking forward to the triumphant return of SQLSaturday Pensacola on June 4, thrilled that this start-of-summer tradition is back! This has been...
2016-05-20
369 reads
Hello SQLSaturday Houston!
I've been looking forward to speaking at SQLSaturday Houston again all year!
Big thanks to the organizing crew behind this great...
2016-05-13
482 reads
SQL Server 2016 at the BRSSUG Meeting on May 11
Looking forward to the BRSSUG/BRPBIUG meeting this Wednesday night May 11, I'll be giving a presentation all about SQL 2016!
This...
2016-05-09
377 reads
Columnstore Indexes: Finally Awesome in SQL 2016
Columnstore indexes are amazing for optimizing the performance of large rowcount queries that would otherwise look like a SCAN operation in...
2016-04-21
661 reads
SSRS 2016 then SQL Jeopardy! tonight at BRSSUG!
See you tonight for our special SQL Jeopardy! competition where I will be your Trebek and three lucky user group...
2016-04-13
411 reads
SQL Server PerfMon Counters Not Listed in dm_os_performance_counters
Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older...
2016-04-05
1,482 reads
Azure ML and R at This Week's BRSSUG/BRPBIUG
This Wednesday night, not only are we going to be showcasing the technology of the internet with an online presenter...
2016-03-07
458 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