(Pam Lahoud) One of the most confusing aspects of SQL Server configuration is often trace flags.
Tag: sql server
Installing and Using mssql-cli on Linux for SQL Server
(Rajendra Gupta) Microsoft recently released an interactive, cross-platform command line query tool called mssql-cli. My previous tip new interactive command line tool mssqlcli for SQL Server, shows the mssql-cli installation and features on the Windows OS.
Azure SQL DB VS SQL Server For the DBA
(blobeater) Being the start of the new year and with new projects most likely starting again I would like to share with you an article I wrote a while back, but still quite relevant.
https://itknowledgeexchange.techtarget.com/sql-server/when-is-the-right-time-to-look-at-new-services/
(Denny Cherry) Microsoft Azure is rolling out new features at a fantastic speed. But when is the right time to evaluate those new features? It might be right as the feature is released, it might be later in the lifecycle.
Changing SQL Dump file locations in SQL Server on Linux
(Rajendra Gupta) In this article, we will talk about SQL Dump files and the process to change the dump directory in Linux SQL Server.
SQL SERVER – Writing Your First Subquery From a Single Table
(Pinal Dave) My primary responsibility is to help different organizations with tuning their SQL Server Performance and here is the link to my most popular service SQL Server Performance Health Check.
Making Power BI Drillthrough Return The ‘Right’ Rows When You Use It With Complex Measures
(Chris Webb) When an end user sees a strange value in a Power BI report, their first reaction is usually to want to see the detail-level data from the underlying table.
Lesson Learned #53: Why do you need to use dm_operation_status dynamic management view?
(Jose M Jurado) This week I worked in a new issue that remembered me the importance to use the dynamic management view called dm_operation_status in every operation that I’m doing with any database either Azure SQL Database or Azure SQL Managed Instance.
Importing Enriched Data into Azure Data Lake Storage (ADLS) with PowerShell
(John Miner) The core idea behind a Modern Data Platform (MDP) design is the ability for different organizational groups to use the information stored in one central place in the cloud.
Running Azure Functions on Kubernetes like on Azure in the consumption plan
(Daniel Neumann) Azure Functions 2.0 introduced the capability to run Functions in a container.
