Power BI – Problem, Design, Solution (Folder Source Option for JSON files)
Hello Everyone! In this episode of the “Problem, Design, Solution” series we will be talking about the “Folder” option inside...
2017-12-18
619 reads
Connect is dead! Long live feedback.azure.com!
After years of having to deal with Connect – the feedback platform of Microsoft – it is announced a successor has been...
2017-12-18
1,148 reads
SQL Server DBCC CHECKDB – Going Parallel
DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...
2017-12-18
321 reads
When do usernames and passwords belong in connection strings
tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your...
2017-12-18
715 reads
My SQL Server Management Studio Setup
We’re all creatures of habit, and work more efficiently when we know exactly where to find the tools we need....
2017-12-18
341 reads
The Fine Art Of Translation
I remember being thoroughly baffled in grade school by word problems. How in the world was I supposed to translate...
2017-12-18
360 reads
T-SQL Tuesday #97 Roundup: Learning goals for 2018
T-SQL Tuesday is a monthly blog party started by respected SQL Guru Adam Machanic. I was honored with hosting this...
2017-12-18
826 reads
SQL Server 2016 – How to use Dynamic Data Masking (DDM)?
Dynamic Data Masking (DDM) is new feature of SQL Server 2016. DDM helps in preventing unauthorized access to sensitive data....
2017-12-18
1,016 reads
Some Thoughts on Community, Leadership, and Continuous Improvement
The SQL Server community is just awesome. I can’t say that enough. I may sound like a broken record when...
2017-12-17
380 reads
Attempting to Run SQL on Linux Inside Windows Subsystem for Linux
Shawn Melton MVP and dbatools contributor last week had an issue running SQL Server on Linux inside of Windows Subsystem for Linux.
Error trying to configure #sqlLinux on the openSUSE...
2017-12-16
15 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers