SQL Server Lock Escalation
Introduction Relational databases follow the ACID properties in how they implement transactions –...
4 Out-of-the-Box SQL Data Conversion Methods and Use Cases
First of all, you can’t do without them, right? SQL data conversions or, more specifically, data type conversions are an essential part...
Formatting Data in Power BI Desktop Visualizations
Microsoft’s Power BI is a data analytics tool that can be used for interactive data visualization, using data from various sources such...
Data Visualization in Microsoft Power BI
Contents Introduction. How to create a table. How to create a Power BI pie chart. Creating a line...
How to Load and Manage Data within Microsoft Power BI
Contents: Introduction Importing data from Excel, SQL Server, and the Web. Importing data from Excel into Power BI. Importing websites into...
Storing XML data in SQL Server
When working on the release of dbForge Transaction Log, among other tasks, our team had to puzzle out how to properly store typed XML data....
Dynamic Data Masking in SQL Server for Advanced Users
This article gives a high-level understanding of dynamic data masking in SQL Server along with its...
Collation in SQL Server
Introduction You must have already heard the term “Collation” in SQL Server. Collation is a configuration that determines how character...
Dynamic Data Masking in SQL Server for beginners
The article introduces the basics of dynamic data masking (DDM) in SQL Server along with its overview supported by a simple example...
Learn Basic Data Analysis with SQL Window Functions
This article is about T-SQL (Transact-SQL) Window functions and their basic use in day-to-day data...
