SQLSaturday Houston 2017 - I'll be there, will you?
Looking forward to combining a work trip with a SQLSaturday trip to Houston this week!
Will be happy to see the...
2017-06-12
379 reads
Will Assaf
SQLSat Pcola 2017 Security Principals and Permissions
Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo...
2017-06-05
276 reads
SQLSaturday Pensacola 2017
It's the start of a SQLSat summer for me, with Pensacola this weekend on Saturday June 3, then Houston two...
2017-05-30
548 reads
Why SQLSaturday? A SQLSat Career Case Study
We all know that SQLSaturday events are good for career networking, professional development, and technical education. Sometimes the perfect story...
2017-04-10
486 reads
Return to Birmingham for SQLSaturday Bham 2017!
It's been 2.5 years since I last spoke atSQLSaturday Birmingham, and I'm eager to make a return, this time with...
2017-03-16
291 reads
Actual Chats: RIGHT OUTER joins in the wild
Colleague:
I think I just encountered my first Right join
*shocked* Me:
huh. weird.
a rare Right Join has appeared!Colleague:
catch it!Me:
You use ON. It's...
2016-12-22 (first published: 2016-12-06)
2,891 reads
SQL SSRS Express Edition Cannot Connect to Azure SQL Databases
This has bit a couple of clients recently, figured I'd put out a PSA.
Express editions of SQL Server Reporting Service,...
2016-10-04 (first published: 2016-09-25)
2,158 reads
"SQL Server Permissions and Security Principals" at SQLSaturday #560 Charlotte 2016
I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by...
2016-09-17
365 reads
"SQL Server Permissions and Security Principals" at SQLSaturday Charlotte This Weekend!
I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.
As a SQLSat...
2016-09-15
380 reads
SQL UG Leaders: Reach Out to Your .NET Friends
In Baton Rouge we make no secret that our user groups and our578-personSQLSaturday combines the volunteers and attendees of our...
2016-08-09
600 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