Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.
Building a strong team is hard, and it takes work. A few thoughts today from Steve on how you can do this.
In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.
Learn about the Azure PowerShell cmdlet for Azure Blueprints in Azure Resource Manager framework and how to export, import, publish, and assign Azure Blueprints with PowerShell cmdlets.
A letter to a past self from Pamela Mooney that might help a more junior DBA get up to speed quicker.
Steve talks a bit about the new challenges of working in a different environment and the challenges you might face.
Data Masker for SQL Server now integrates with SQL Data Catalog (seamlessly with our new GUI) to let you fully automate your data privacy and protection process, from data classification through to masking.
When you run a query, how does SQL Server estimate the number of rows? I’ll explain in this half-hour video demo using playing cards, then showing the same issues in SQL Server Management Studio.
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
By gbargsley
Happy Tuesday everyone… Today I am honored to have my first article published on...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Returning Python Dictionary Values
Comments posted to this topic are about the item The Habits of Better Teams
We are looking to move the SQL server to different datacenter. Since it's a...
Ask SSC