Custom SSMS Shortcuts for ETL Developer. Part 3: Source-Target Mapping
Provides a SQL code that generates a source-target transformation query and can be helpful at several stages of data warehouse development lifecycle.
2011-09-29
3,680 reads
Provides a SQL code that generates a source-target transformation query and can be helpful at several stages of data warehouse development lifecycle.
2011-09-29
3,680 reads
With the following technique, you can quickly read information stored in the extended properties of a SQL Server table.
2011-09-27
4,560 reads
This is the first of three tips on how ETL Developers can be more productive by applying custom SSMS shortcuts to the most often used tasks.
2011-09-22
6,387 reads
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
Hi all, First I want to ask just a generic question. Does RLS in...
Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...
I have installed the SSIS extension for VS 2022 community. When I go into...
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers