03 December 2020
03 December 2020

Why it makes sense to monitor SQL Server deadlocks in their own Extended Events trace

2
We recently had customer ask why SQL Monitor creates an Extended Events session to capture deadlock graphs, when SQL Server has a built-in system_health Extended Events trace which also captures deadlock information? There are a couple of reasons why a dedicated trace is desirable for capturing deadlock graphs, whether you are rolling your own monitoring … Read more
19 November 2020
19 November 2020

Database DevOps Considerations for SQL Server Availability Groups

9
One question which comes up periodically from our Microsoft Data Platform customers is whether there is anything special that they need to do when implementing version control, continuous integration, and automated deployments for a production database which is a member of a SQL Server Availability Group.  The good news is that deployments are quite straightforward. … Read more
04 November 2020
04 November 2020

Unwrapping JSON to SQL Server Tables

8
If you know the structure and contents of a JSON document, then it is possible to turn this into one or more relational tables, but even then I dare to you claim that it is easy to tap in a good OpenJSON SELECT statement to do it. If you don’t know what’s in that JSON … Read more
26 October 2020
26 October 2020

Reordering Deployments in Database DevOps

5
We recently received an interesting question in our Redgate forums from Peter Daniels about altering the order of deployments in database DevOps. The question includes the following scenario: Developer A makes changes – feature 1.  This set of changes makes its way into the dev integration environment. Developer B makes changes – feature 2.  This … Read more
05 October 2020
05 October 2020

Data and Azure links you don’t want to miss

1
Browser tabs hold some similarities with tribbles in the way they multiply. Before you can notice, you have hundreds of them. However, in the same way tibbles are fluffy, browser tabs sometimes hold fluffy information as well, the kind of information you know you need but usually you are not sure where to hold it … Read more
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

7
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