Connect to SQL Server
In this article we look at the different ways to connect to various SQL Server services using tools like SSMS, BCP, SQLCMD, PowerShell and more.
2021-02-12
ssas design
How to Resolve a Duplicate Key Error in SSAS
Learn how you can fix the duplicated key error in SSAS without editing the source data.
2020-05-05
7,868 reads
Introduction to Attribute Relationships in SSAS
In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.
2020-02-10
7,540 reads
Blogs
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I...
Forums
SQL Query Performance with Left Join
I have a query that is performing poorly It has a left join to...
The Long Running Backup
Comments posted to this topic are about the item The Long Running Backup
Interview Tips
Comments posted to this topic are about the item Interview Tips
Question of the Day
The Long Running Backup
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers