(Thomas LaRock) Not enough people know about the Audit and Threat Detection feature in Microsoft Azure. So, I’m hoping to help spread the word today. I decided to write a post to help explain the Microsoft Azure Threat Detection types.
Tag: sql server
Process Azure Analysis Services objects from Azure Data Factory v2 using a Logic App
(Jorg Klein) In this blog post I will show how you can orchestrate processing of your Azure Analysis Services objects from Azure Data Factory v2. This makes it possible to process an Analysis Services model right after your Azure Data Factory ETL process finishes, a common scenario.
Isolating SQL Performance Issues due to slow Disk IO subsystem
(Don Castelino) In this blog, we are covering few checklists to identify and isolate disk IO subsystem bottlenecks causing SQL performance issues. The checklist can be used as reference while troubleshooting SQL Performance issues because of slow Disk IO subsystem.
What’s dbo?
(Kenneth Fisher) Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems to cause a great deal of confusion because of this.
Azure Functions v2 Now Uses ASP.NET Core Configuration and No Longer Supports ConfigurationManager
(Jon Gallant) You may have noticed that ConfigurationManager is not available in Azure Functions v2 .NET Standard projects. It’s no longer supported. AF v2 now uses ASPNET Core Configuration.
Data Virtualization vs. Data Movement
(James Serra) I have blogged about Data Virtualization vs Data Warehouse and wanted to blog on a similar topic: Data Virtualization vs. Data Movement.
SQL SERVER – Performance Observation of TRIM Function
(Pinal Dave) Earlier I wrote a blog post about how to remove leading and trailing spaces with TRIM function. SQL SERVER – 2017 – How to Remove Leading and Trailing Spaces with TRIM Function? After writing this blog post lots of people asked me its impact on the performance of SQL Server.
Getting Started in a SQL Server 2017 VM in Azure
(Grant Fritchey) You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!
How It Works: SQL Server DTC (MSDTC and XA Transactions)
(RDORR) I have found the term DTC is used in many ways so for the purposes of the discussion here are a few terms. When talking DTC, I am talking about the feature set, MSDTC as the OLE-TX implementation and XA for the X/Open XA implementation.
Different Ways to Connect to SQL Azure databases
(Vitor Montalvao) This is my fourth tip that is part of a tutorial to help people that are moving for the first time to SQL Azure. If you did not read my previous articles and want to learn how to create a database in SQL Azure and perform basic configurations, you can read them now and then return