T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT
Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.
Splitting Strings in SQL
A problem that has plagued SQL developers through...
2017-02-14
441 reads
Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.
Splitting Strings in SQL
A problem that has plagued SQL developers through...
2017-02-14
441 reads
Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data...
2017-02-09
658 reads
Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you...
2016-09-19
398 reads
With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review...
2016-05-11 (first published: 2016-04-28)
2,674 reads
Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see...
2016-04-20
720 reads
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-04-16
468 reads
I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were...
2016-04-11
421 reads
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2016-03-19
541 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2016-03-14 (first published: 2016-03-04)
1,714 reads
On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group. This session is based on...
2016-02-04
560 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers