(Robert Sheldon) This article takes a conceptual approach to explaining core source control concepts, using diagrams and anecdotes as necessary to describe how all the pieces fit together.
Tag: sql server
SSRS Report Manager Configuration Wizard failed when Applying Connection Rights
(Samuel Lester) Error Message: Cannot alter the role ‘RSExecRole’, because it does not exist or you do not have permission.
Synchronizing SQL Server data using rowversion
(Sergey Gigoyan) For SQL Server database professionals a common task is synchronizing data between two tables. There are different ways of implementing a solution in SQL Server such as Change Data Capture or Change Data Tracking, replication, using triggers and so on.
5 Characteristics Every Leader Should Practice
(Chris Yates) The word leadership has many synonyms attributed to it. Something that can be learned early on in one’s career is that having a leader you can trust is very important. Trust is something that is earned; not given.
Looking at wait stats differently with SQL 2016
(Arun Sirpal) Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on sys.dm_os_wait_stats and/or sys.dm_os_waiting_tasks.
Automate Export Azure SQL DB to blob storage use Automation account
(Mohamed Ahmed Baioumy) I had a support case recently question how to automate Export Azure SQL DB to a storage account (Blob container) to .bacpac files. The first attempt was made to configure a PowerShell Script to Export Azure SQL DB to blob container and to .bacpac format from here . this was s
Multi-language support for SSAS Tabular Models
(Siddharth Mehta) Typically solutions used globally have the need for different language support. In SQL Server Analysis Services (SSAS) this is implemented by use of the translations feature. SSAS Multi-dimensional models have always supported this requirement, but SSAS Tabular models did not have
Does Query Store Pre-Allocate Space
(Grant Fritchey) I love the questions I get while I’m presenting because they force me to think and learn. The question in the title is one I received recently.
What Does ‘monitorLoop’ mean in the Blocked Process Report
(Michael J. Swart) Some trivia for your Friday. I recently got a question asking about what the attribute “monitorLoop” is in the blocked-process-report because it’s not really documented.
Managing Azure SQL Database Recovery
(Marcin Policht) Azure SQL Database offers a number of benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy.
