Data Lineage Scripts for Microsoft SQL Server and Azure SQL
Learn how you can easily analyze the data lineage in your SQL Server database.
2022-10-19
7,441 reads
T-SQL
Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
3,620 reads
Manage Your Business Rules in T-SQL Query
Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses. And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]
2022-10-18 (first published: 2022-09-02)
10,815 reads
Different ways to Convert a SQL INT Value into a String Value
In this article we cover different ways to convert a SQL Server numeric value into a string value.
2022-07-08
Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,273 reads
Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data
In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.
2022-03-07
SQL Server Monitoring Using Free Tools
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
5,661 reads
Quantifier predicates
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
2022-01-14
Performance Tuning Using Free Tools, Part 2
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
5,244 reads
How to Create a FOR Loop in SQL Server
Learn different ways to create FOR Loops using T-SQL such as using WHILE loops, cursors, tally tables and more.
2021-12-31
Blogs
How to give developers access to Query Store
Let’s have devs look at their own query performance. Yes, please, sign me up...
Sharpen Your SQL Skills: June’s Challenge Awaits!
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
Denver Dev Day – Best Practices for Database Deployments Resources
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
Forums
The name of column index 9 is empty ADF
Hi I am brand new to Data Factory I am getting the following error...
How to set execution timeout in SSMS for SQL Server Programmatically
I want to set the execution timeout in SSMS Connection properties on the 'Connect...
The SQL Assessment API
Comments posted to this topic are about the item The SQL Assessment API