Tag: SQL Server

19 Nov

SQL Database in Fabric – What, Why, and How?

by Nikola

11 Comments

Once upon a time, there was a SQL Server, an undisputed emperor of operational databases! In this article, we examine the key characteristics of the...

17 Jun

Direct Lake Lakehouse Microsoft Fabric SQL Server T-SQL

How to bring SQL Server data into Microsoft Fabric

by Nikola

4 Comments

Options, options...In this article, you'll learn what are the possibilities for bringing your on-prem SQL Server data to Microsoft Fabric

29 Mar

Databases Lakehouse Microsoft Fabric Relational Databases SQL Server

What is Mirroring in MS Fabric and why do I consider it the next big thing?

by Nikola

2 Comments

Mirroring was the missing puzzle in "One Copy for All Data" mantra! Now it's here, and it's amazing what you can do with it in...

15 Jan

Data Modeling Power BI Relational Databases SQL Server T-SQL

How to capture SQL queries generated by Power BI

by Nikola

3 Comments

Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!

09 Dec

Data Visualization SQL Server SSRS T-SQL

Write back to a database using SSRS!

by Nikola

3 Comments

Despite not being a best practice, this trick will enable you to solve some edge case challenges!

11 Aug

Databases Relational Databases SQL Server T-SQL

Rows or Columns – where should I put my index on?

by Nikola

No Comments

Choosing optimal indexing strategy for your SQL Server workloads is one of the most challenging tasks. Learn in which scenarios you can benefit from using...

14 Jun

Databases SQL Server T-SQL