Getting started with ROUND() and Its Use Cases
Learn the basics of the ROUND() function in this article.
2022-12-02
2,667 reads
T-SQL
How to get IO statistics of SQL Server database files
This article shows how you can query your database files to get metadata about them and use that to get the reads, writes, and other IO statistics.
2022-11-18
5,190 reads
SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,090 reads
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
3,901 reads
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,070 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)
9,938 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
1,748 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
3,031 reads
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
Microsoft SQL over IPSEC VPN TPLink routers - 2 locations
Hi Experts. We recently set up a second location. our software at our first...
Trouble moving from a 2017 SQL Express DB on one HP laptop to another HP laptop
I am trying to migrate a DB from an old dying laptop to a...
Database copies (cross environment) and sizing strategies for 2019
I'm sure this has been asked many, many, many times and hoping several optimal...
Ask SSC