You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-09 (first published: 2020-01-03)
961 reads
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
23 reads
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-08-02 (first published: 2019-07-15)
512 reads
SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...
2019-07-16 (first published: 2019-07-05)
928 reads
Notebooks are a functionality available in Azure Data Studio, that allows you to create and share documents that may contain text, code, images, and query results. These documents are...
2019-05-07
106 reads
Using Azure Feature Pack for Integration Services to access Blob storage from Azure into SSIS packages
2019-04-23 (first published: 2019-03-26)
975 reads
Azure Database is the PaaS solution for SQL Server databases, on a previous post we have discussed how to create one.On this post, I want to show you how...
2019-04-11
4,432 reads
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis,...
2019-03-13
1,087 reads
Access OS event viewer and read it from a SSIS package using WMI Data reader task
2019-03-05
693 reads
If you have SQL Server Integration Services installed on your server, and you left the default configurations a table named...
2019-02-26 (first published: 2019-02-11)
2,928 reads
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
How to update status with conflict data where chemical temp table have same chemical...
I'm reading file from BLOB through ADF and I would like to pass the...
Hi. I'm working through the official exam reference book for 70-764 by Isakov and...
Ask SSC