SQL

20 posts

Source: T-SQL Window Functions and Performance - Simple Talk ...
Read More
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, ...
Read More
Terminology Check - What is a Power BI App? | SQLChick - Microsoft BI Blog (Melissa Coates)

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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
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 ...
Read More
Querying Data in Azure Data Lake Store with Power BI | SQLChick - Microsoft BI Blog (Melissa Coates)

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 ...
Read More
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) ...
Read More
Data Refresh Issues in the Power BI Service Due to Invalid Dates | 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 ...
Read More
Checklist for Finalizing a Data Model in Power BI Desktop | SQLChick - Microsoft BI Blog (Melissa Coates)

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 ...
Read More
Zones in a Data Lake | SQLChick - Microsoft BI Blog (Melissa Coates)

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 ...
Read More
SQL Code Smells - Simple Talk

SQL Code Smells – Simple Talk

/ / Link, Professional Reading, SQL
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 ...
Read More
The week in .NET – Rezoom.SQL, Protobuf in Orlando, and links! | .NET Blog

The week in .NET – Rezoom.SQL, Protobuf in Orlando, and links! | .NET Blog

/ / Link, Professional Reading, SQL
How Microsoft brought SQL Server to Linux via TechCrunch https://techcrunch.com July 17, 2017 at 11:01AM ...
Read More
How Microsoft brought SQL Server to Linux | TechCrunch

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, ...
Read More
New Whitepaper on Planning a Power BI Enterprise Deployment | SQLChick - Microsoft BI Blog (Melissa Coates)

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 ...
Read More
The Basics of Good T-SQL Coding Style - Part 2: Defining Database Objects - Simple Talk

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 ...
Read More
Microsoft launches Azure Database for MySQL and PostgreSQL | TechCrunch

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 ...
Read More
The Basics of Good T-SQL Coding Style - Simple Talk

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 ...
Read More
Access on-premise SQL Server data from Azure Logic Apps via On-Premises Data Gateway | Saravana Kumar

Access on-premise SQL Server data from Azure Logic Apps via On-Premises Data Gateway | Saravana Kumar