In this article, I explain how to convert a list of Excel files to CSV and move them to a separate folder with a Data Factory pipeline in Fabric's Data Lake.
When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place for that data to reside. It is column-based, highly compressed, and supports a wide variety of optimizations for both reads and writes. When analytic data is stored in files, such as for use in Azure Data Factory, Synapse,...…
The post Reading and Writing Parquet Files in SQL Server appeared first on Simple Talk.
Learn how to create a microservice application with Azure container apps and Dapr using Bicep to develop infrastructure code and deploy templates.
This article explains how to aggregate data for Power BI reports and provides examples of running totals, running averages, min, max, and more.
When you think of how to store data in a database, you think of data types. A data type represents a method of how some bit of data is stored internally. Whether it’s numbers, text, dates, or even more complex structures like JSON or geometric shapes, there is an internal format and a method to...…
The post MySQL vs PostgreSQL: Numeric Datatype Comparison appeared first on Simple Talk.
Learn how to use production-like data for testing and development, but mask sensitive data quickly and efficiently with DataVeil.
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions (SCD Type 2) versus overwriting tables.
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
This tip explores leveraging existing SQL Server stored procedures within the Microsoft GraphQL API.
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is where we find the data types, constraints, references and other structures that have to do with how the data stored . The DML (Data Manipulation Language) uses those declarations to change their contents or to...…
The post Data Control Language (aka Security) appeared first on Simple Talk.
In this article, we look at how to use Apache Kafka and Zookeeper to process and load streaming data.
In this article, we combine multiple columns from an SQL Server table into one column using three different methods to see the most efficient approach.
In this article, we look at using SQL Server metadata to better manage SQL code for things like stored procedures, user-defined functions, views, and more.
In this article, learn how to build a Power BI report from start to finish with a real-life example using COVID-related data.
In this article, we look at how to build an Azure streaming data collection and analysis process to analyze and predict stock prices.
This tip covers executing a Microsoft Fabric query using GraphQL API from an external application, introducing opportunities for data sharing, and exposing data through custom code.
This article examines SQL Server Reporting Services security and what you should know from the Configuration, Web Service, Folder, and Report Level.
Learn some tips and tricks when working with AI/virtual recruiters during the recruitment process and things you should know.
Check out this structured reference guide to just about anything you want to know about Power BI and Power BI report development.
This tip introduces some basic text preprocessing and cleaning techniques with Python that can be used before feeding the data to a machine-learning model. 
This article will explain Change Management, how DBAs are involved and can benefit from implementing standard processes for all database changes.
Check out this SQL Server stored procedure and function to auto-generate SQL variable coding syntax for many different programming languages.
Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.
Learn how to implement MySQL on the Azure platform in this step-by-step article using an Azure Database for MySQL flexible server deployment.
Learn how you can export millions of rows of data out of Power BI to either a CSV or Excel file.
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
Working with XML and T-SQL could be a challenge if you do not know how to access the XML data. In this article, we look at what you need to know to work with XML data in SQL Server.
Learn how to share data currently stored in a Microsoft Fabric warehouse using a GraphQL API along with the steps to set this up.
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.Learn about the purpose of Change Advisory Boards (CAB) to support a Change Management team by advising on requested IT changes.