T-SQL query to get the latest available backup chain
T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.
2019-10-30
3 reads
SQL Server Carpenter
T-SQL script to purge all the tables including foreign key references
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and...
2019-10-30
6 reads
T-SQL script to purge all the tables including foreign key references
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and...
2019-10-30
7 reads
T-SQL query to copy data from one database to another database
T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in...
2019-10-30
13 reads
T-SQL query to copy data from one database to another database
T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in...
2019-10-30
10 reads
2019-10-10
30 reads
2019-10-10
6 reads
Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
758 reads
Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
77 reads
Leveraging WHILE LOOP
WHILE LOOP can be used for batch processing and can be helpful if you are dealing with huge data processing. Recently I did an analytics project where I had...
2019-10-09
8 reads
Blogs
Article: SQL Server Sample Databases
By Brian Kelley
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases...
PostgreSQL 17: A Deep Dive into New Features, Benefits, and Enterprise Impact
By Rohit Garg
PostgreSQL 17 introduces a new era of innovation in open-source database technology. This release...
The Evolution of Data: From Databases to Spark to Lakebases
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS
Comments posted to this topic are about the item Unlocking Interoperability: A Guide to...
Disaster Recovery for Azure SQL
I am creating a Disaster Recovery plan for Below Data pipeline. I need to...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers