Data Mozart

Tag: T-SQL

08 Sep
Azure Mastering DP-500 SQL Server Synapse Analytics T-SQL

Mastering DP-500: Synapse Serverless SQL and file types – the ultimate guide!

by Nikola
2 Comments
CSV? Parquet? Delta? Which file format should you use to get the best out of Synapse Serverless SQL pool? Let's demistify pros and cons of...
01 May
Data Visualization Learning Mastering DP-500 Synapse Analytics T-SQL

Mastering DP-500 Exam: Explore and Visualize Data using Synapse SQL pane

by Nikola
No Comments
Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!
05 Sep
Data Modeling Databases Power BI Relational Databases T-SQL

3 reasons to use views instead of tables in Power BI!

by Nikola
7 Comments
When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the...
25 May
Data Modeling Power BI SQL Server T-SQL

Solved! Query folding for native SQL in Power BI

by Nikola
3 Comments
Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...
14 Mar
Data Modeling Power BI T-SQL

Query folding – tricks, lies & ultimate performance test!

by Nikola
3 Comments
In the final part of the Query folding series, learn more tricks, find out when the View Native Query lies, and finally spot the difference...
15 Jan
Data Modeling Power BI Relational Databases SQL Server T-SQL

How to capture SQL queries generated by Power BI

by Nikola
No Comments
Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!
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

Azure Data Studio or SSMS – which should I use?

by Nikola
2 Comments
Azure Data Studio or SSMS? Why can't be Azure Data Studio AND SSMS? Check how you can take the best from both worlds
05 Jun
Databases SQL Server T-SQL

How (not) to kill your SQL Server performance with implicit conversion

by Nikola
No Comments
Learn how to avoid performance killer and help SQL Server choose optimal execution plan for your queries
28 May
Data Modeling Databases Relational Databases SQL Server T-SQL

Datetime2 – Why you should (not) use it

by Nikola
5 Comments
Choosing right data type is not so straightforward as you might think at first sight