(Jack Vamvas) Question: I was looking through Programs installed on a server with SQL Server installed and noticed Visual Studio components installed.
Tag: sql server
Azure Data Catalog Register Data Source – Part 2
(Haroon Ashraf) As a Business Intelligence (BI) developer you just deployed a Data Model on Azure Analysis Services along with sourcing your Tabular Data Model through Azure SQL Database and your organization has now asked you to help them with data discovery assuming there are several data models t
Working with the IIF Statement in T-SQL
(Hannes du Preez) You can use the IIF statement to check quickly for conditions.
Indexed Views – Performance Panacea or Plight
(Jason Brimhall) An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view.
SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution
(Pinal Dave) Every time we talk about deadlock, you will see DBA frowning on this topic. DBA believes that Developers are creating the deadlocks and developers believe that DBA’s should be taking care of the deadlocks.
Measuring Latency in Complex PowerApps
(Steve Endow) I have created a PowerApp that has several dependencies, and I am concerned about latency, and how that will affect the delay that a user experiences when they use the PowerApp.
Database Fundamentals #21: Using the JOIN Operator, OUTER JOIN
(Grant Fritchey) The OUTER JOIN returns one complete set of data and then the matching values from the other set. The syntax is basically the same as INNER JOIN but you have to include whether or not you’re dealing with a RIGHT or a LEFT JOIN.
Power BI, Caching, Parallelism And Power Query Refresh Performance
(Chris Webb) Some time ago a customer of mine (thank you, Robert Lochner) showed me a very interesting scenario where a set of Power Query queries in Power BI Desktop refreshed a lot faster with the “Enable Parallel Loading Of Tables” option turned off.
Transform Data in Power BI with R and Python
(Siddharth Mehta) Power BI supports a large variety of connectors to data sources. It also supports a powerful query editor for editing a data model as well as data. But it does not have a library of functions for data science, statistics, NLP and many other areas.
AMD EPYC Processors in Azure Virtual Machines
(Glenn Berry) Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines.