You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a small change, such as an alteration to the network topology, means that they all need to be altered with the correct connection details. Perhaps you should consider creating design patterns for all the standard components of integration tasks in BIML, and generating the SSIS packages from these? Amarendra walks you through the process.
Redgate is hiring someone to manage Simple Talk, a job just like the one Steve has with SQLServerCentral.
Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server.
This level of the stairway details the creation of a relational database, as well as filling in some of the history of the relational database model.
Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.
In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse
There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Absolute and Relative References
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I