SQL Homework – March 2019 – Reconfigure tempdb
You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor...
2019-03-15 (first published: 2019-03-04)
2,421 reads
Blog Posts
Azure Data Explorer
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data analytics service for near real-time analysis on large volumes...
2019-03-14
298 reads
Azure Data Explorer
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data...
2019-03-14
2,272 reads
Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when I was trying to build a Power BI demo...
2019-03-14
70 reads
Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when I was trying to build a Power BI demo...
2019-03-14
14 reads
Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when I was trying to build a Power BI demo...
2019-03-14
231 reads
Git, GitHub, GitLab, BitBucket, What’s the difference?
I was watching Brent’s webcast session on GitHub recently. I’ve struggled to explain this to users in the past, and...
2019-03-14 (first published: 2019-02-25)
3,661 reads
Scalar UDF Inlining in SQL Server 2019
How does Scalar UDF Inlining affect the performance of scalar functions?
SQL Server 2019 introduces a new feature called “Scalar UDF...
2019-03-14 (first published: 2019-02-25)
3,270 reads
SQL Server – max server memory
Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...
2019-03-14
495 reads
#ITechDay in Warsaw
We were enjoying Thursday on conference in Warsaw. We have arrived pretty lately but easily saw the awesome atmosphere there....
2019-03-13
256 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
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