Articles tagged SQL Server

01 March 2024
01 March 2024

Friendly Deletes in SQL Server

0
0
One of the first things you learn when working with SQL Server, and other transactional based SQL systems, is that set based operations perform best. If you are querying data, a cursor pulling individual rows doesn’t perform as well as a single query. It doesn’t matter if that cursor is on the client side or … Read more
30 August 2021
30 August 2021

5 SSIS tricks you would like to know

0
4
How to make conditional decisions in a package It may seems strange the lack of a decision task for the control flow. However, there is a work around to allow us achieve the same effect we would have with a “decision task”. The precedence control between tasks can be based on an expression. Building the … Read more
15 June 2021
15 June 2021

Microsoft SQL Server to Oracle Database Connectivity from SSIS using Attunity Connector

0
11
Almost every environment now a days need to source data from different source system. Here is how you can establish connection using Attunity Connector from Microsoft SQL Server to Oracle Database  from SSIS. This method is extremely fast if you want to land millions and millions of records on the fly from Oracle to SQL Server. … Read more
26 April 2021
26 April 2021

Malta Data Saturday and Our New Era

0
1
The Malta Data Saturday is finishing. I still need to compile the numbers, but the comments and feedback are great. Let’s talk a bit about the story of this conference and I hope this story can provide it’s 2 cents to the build of our new era, at least starting many discussions about do’s and don’ts … Read more
29 March 2021
29 March 2021

Data Platform: Links to Study and Learn

0
2
Last Friday I appeared in the middle of a Brazilian Twitch live made by a friend and while they were talking and studying, I provided some links full of content to them. Nowadays, there are a lot of free content on internet. Not only free content, but also content well organized in a good sequence … Read more
03 August 2020
03 August 2020

How to not go mad with schema compare in SSDT

0
11
SSDT (SQL Server Data Tools) is really great to manage database schema changes. However, due to a disappeared feature, SSDT can make you go mad very easily. The schema compare has a lot of configurations. A really lot of configurations. You start the schema compare using the right-click on the SSDT project. Before starting the … Read more
01 August 2020
01 August 2020

Temporary Tables in SQL Server

Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They can improve your code's performance and maintainability, but can be the source of grief to both developer and DBA if things go wrong and a process grinds away inexorably slowly. We asked Phil for advice, thinking that it would be a simple explanation.… Read more