SQL
20 posts
Source: T-SQL Window Functions and Performance - Simple Talk ...
T-SQL Window Functions and Performance – Simple Talk
Terminology Check - What is a Power BI App? via SQLChick - Microsoft BI Blog (Melissa Coates) https://www.sqlchick.com/entries/ June 17, ...
Terminology Check – What is a Power BI App? | SQLChick – Microsoft BI Blog (Melissa Coates)
Source: SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database - Simple Talk ...
SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database – Simple Talk
Source: SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database - Simple Talk ...
SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database – Simple Talk
Source: SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database - Simple Talk ...
SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database – Simple Talk
Source: SQL Server Graph Databases - Part 1: Introduction - Simple Talk ...
SQL Server Graph Databases – Part 1: Introduction – Simple Talk
Source: SQL Server Graph Databases – Part 2: Querying Data in a Graph Database - Simple Talk ...
SQL Server Graph Databases – Part 2: Querying Data in a Graph Database – Simple Talk
Querying Data in Azure Data Lake Store with Power BI via SQLChick - Microsoft BI Blog (Melissa Coates) https://www.sqlchick.com/entries/ May ...
Querying Data in Azure Data Lake Store with Power BI | SQLChick – Microsoft BI Blog (Melissa Coates)
Source: SQL Server Graph Databases - Part 1: Introduction - Simple Talk ...
SQL Server Graph Databases – Part 1: Introduction – Simple Talk
Data Refresh Issues in the Power BI Service Due to Invalid Dates via SQLChick - Microsoft BI Blog (Melissa Coates) ...
Data Refresh Issues in the Power BI Service Due to Invalid Dates | SQLChick – Microsoft BI Blog (Melissa Coates)
Checklist for Finalizing a Data Model in Power BI Desktop via SQLChick - Microsoft BI Blog (Melissa Coates) https://www.sqlchick.com/entries/ December ...
Checklist for Finalizing a Data Model in Power BI Desktop | SQLChick – Microsoft BI Blog (Melissa Coates)
Zones in a Data Lake via SQLChick - Microsoft BI Blog (Melissa Coates) https://www.sqlchick.com/entries/ December 30, 2017 at 04:32PM ...
Zones in a Data Lake | SQLChick – Microsoft BI Blog (Melissa Coates)
Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices ...
SQL Code Smells – Simple Talk
The week in .NET – Rezoom.SQL, Protobuf in Orlando, and links! via .NET Blog https://blogs.msdn.microsoft.com/dotnet August 8, 2017 at 12:39PM ...
The week in .NET – Rezoom.SQL, Protobuf in Orlando, and links! | .NET Blog
How Microsoft brought SQL Server to Linux via TechCrunch https://techcrunch.com July 17, 2017 at 11:01AM ...
How Microsoft brought SQL Server to Linux | TechCrunch
New Whitepaper on Planning a Power BI Enterprise Deployment via SQLChick - Microsoft BI Blog (Melissa Coates) http://www.sqlchick.com/entries/ June 13, ...
New Whitepaper on Planning a Power BI Enterprise Deployment | SQLChick – Microsoft BI Blog (Melissa Coates)
Part 1 of the series here. Lot's of good here. A database team must be proactive when it comes to ...
The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects – Simple Talk
Microsoft launches Azure Database for MySQL and PostgreSQL via TechCrunch https://techcrunch.com May 10, 2017 at 03:02AM ...
Microsoft launches Azure Database for MySQL and PostgreSQL | TechCrunch
TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and ...
The Basics of Good T-SQL Coding Style – Simple Talk
Access on-premise SQL Server data from Azure Logic Apps via On-Premises Data Gateway via Saravana Kumar http://blogs.biztalk360.com January 26, 2017 ...