Understanding the Metadata Function DATABASEPROPERTYEX()
Learn how to use the DatabasePropertyEX() function to query your database for settings.
2022-08-29
1,842 reads
Learn how to use the DatabasePropertyEX() function to query your database for settings.
2022-08-29
1,842 reads
A stored procedure to search database objects (triggers, scalar functions, table valued functions, views and stored procedures) for a user defined string.
2022-04-04 (first published: 2022-03-28)
675 reads
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
3,027 reads
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
4,486 reads
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
2021-08-27
In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server
2021-03-10
This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]
2021-01-26
4,130 reads
2020-02-27
19,702 reads
Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of integers? They are lists or arrays consisting of integers. The number of […]
2020-02-13
5,911 reads
Learn how to use the PIVOT operator in SQL in a step-by-step manner.
2020-02-06
11,108 reads
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Hello everyone. I don't post here often even though I am constantly on the...