15 June 2021
15 June 2021

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

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
08 June 2021
08 June 2021

How Essential Are Azure Policies

0
1
Policies in Azure are like Wally. They are there, but not obvious to find, hidden in the middle of many services, waiting for someone recognize their importance. Why do we need Policies Billing The billing control in Azure has by itself many different reasons to enforce policies. You, with your single Azure subscription, may think … Read more
08 June 2021
08 June 2021

Convert from XML

0
3
I have to deal with XML data with PowerShell. That’s fine, but I always find myself sighing when I need to read an XML object. I have a copy of ‘XML in a Nutshell’. It is over six hundred pages of essential information on XML. Some nutshell. XML is, I believe, a way of representing … Read more
01 June 2021
01 June 2021

What Counts for a DBA – Deadlines

Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline, they work like fury. If we didn’t have deadlines, we’d stagnate. ― Walt Disney I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild … Read more
01 May 2021
01 May 2021

Saving money with Log Analytics

0
1
Azure Monitor and Log Analytics are a very important part of Azure infrastructure. In my opinion, the adoption of these tools should start before a company starts its migration to azure. Using these tools over on premises servers can generate a performance baseline to be used when migrating the servers, ensuring the environment will be … 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
19 April 2021
19 April 2021

Denormalization in Production: Common Problem and Solution

0
3
After a young developer (or database developer) learns about normalization, the quality of his databases increases a lot, there is no doubt about that. However, sometimes we need some denormalization, even in production databases. I faced some experienced developers that, although, they would agree this should be analyzed in a case-by-case scenario, they never saw … 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
15 March 2021
15 March 2021

Count Distinct and Window Functions

0
2
Or: How to make magic tricks with T-SQL Starting our magic show, let’s first set the stage: Count Distinct doesn’t work with Window Partition Preparing the example In order to reach the conclusion above and solve it, let’s first build a scenario. Using Azure SQL Database, we can create a sample database called AdventureWorksLT, a … Read more
12 March 2021
12 March 2021

Ways to get and deal with invalid node identifiers in SQL Server Edge references

One of the weirder things about graph tables in SQL Server is the mysterious backend implementation. The values you see when working with these objects look like this: {“type”:”node”,”schema”:”dbo”,”table”:”Node1″,”id”:0}, but when you get errors, you don’t see the json, you see what this represents (two integers for the object_id and unique id in the graph … Read more
08 March 2021
08 March 2021

The Game Changed: Power BI Premium per User

0
4
Until now, one common knowledge about Power BI was how Power BI Premium subscription is expensive. We, regular mortals, could only dream with the full set of features offered by Power BI Premium. The new announcement is a complete game changing for the enterprise self-service BI technology: Power BI Premium per User will be available … Read more