16 September 2020
16 September 2020

Web Scrapping with Python using BeautifulSoap

1
Today the internet is completely associate with large source of data. Inappropriately, the huge majority of it isn’t out there in handily organized CSV files for download and analysis. If you want to capture data from several websites, you’ll have to be compelled to strive web scraping. It helps them to learn about operational activities, also … Read more
15 September 2020
15 September 2020

Understanding Data Modifications in Cassandra

3
This article explains about how the data modifications is handled by Cassandra, to handle Update’s and Delete is effectively we need to first understand the Write Path and the Read Path in Cassandra. The Write Path When a write request (insert) is received is by Cassandra, the data will be stored in Memtable & Commit … Read more
14 September 2020
14 September 2020

Index Usage: finding indexes not being used

4
I wrote before about how to check index usage on the database, in that article I wrote about exploring query plans. However, another reason to check index usage would be to drop indexes not being used. Every index create some level of impact on changes (INSERT/UPDATE/DELETE) and if an index is not being useful, it … Read more
10 September 2020
10 September 2020

Database Continuous Integration with SQL CI and Jenkins

6
Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated regularly and tested by an automated build system. Code changes are checked into source control, triggering an automated build with unit tests and providing early feedback in the form of errors returned. Potential problems with … Read more
02 September 2020
02 September 2020

Weighted Randomization In T-SQL

0
When I am not working on or writing about SQL, I am posting theme park pictures on Twitter of DisneyWorld (@DisneyPicADay) and Dollywood (@DollywoodP). The fun part of it is taking the pictures. The HARD part is deciding what to post every day. So instead of picking things from my head, I decided to harness … Read more
24 August 2020
24 August 2020

Responsible AI news from Build

1
Microsoft Build took place more than a month ago, but only now I’m writting about it. I’m facing the danger of being nicknamed as one famous Brazilian formula 1 pilot. Internal Brazilian joke. Build is a historical mark among community events. It implemented many new techniques to make an online event closer to an in-person … Read more
21 August 2020
21 August 2020

Understanding digital transformation & how it transcends to driving organizational growth

2
Introduction Digital transformation is the process of undergoing multiple internal and external changes by an organization leveraging digital technologies to become more agile, optimized and efficient in its business operations. Dynamic IT environment, the urge to leverage emerging technologies, and the unpreparedness to function at scale in throes of the global pandemic are driving increased … Read more
03 August 2020
03 August 2020

How to not go mad with schema compare in SSDT

3
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

How Mature is Your Database Change Management Process?

6
How do you get your database schema changes live on your production system? As your team of developers and DBAs work on changes to the database to support your business-critical applications, how do updates wend their way through dev environments, possibly to QA, hopefully through pre-production and eventually to production in a controlled, reliable and … Read more

Batch Framework

33
In SDLC (software development life cycle) process, creating a batch job is the last step. As the application maintenance grows over period of time and new component added to the overall process can make over batch support complicated. This article provides guidelines to create batch jobs that can be well supported in future. Though this … Read more
04 June 2020
04 June 2020

Using Azure Data Studio with SQL Prompt

2
One of the coolest and most useful features of Azure Data Studio (ADS) is SQL Notebooks. If you haven’t seen them, notebooks allow you to combine text with markdown and runnable code in the same document, and they are shareable. Notebooks might be used for teaching, documentation, or runbooks among other uses. I recently heard … Read more