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
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
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
Twelve and a half years ago I wrote my largest hit count article of my writing career Ten Common Database Design Mistakes. It currently shows as having over 1.2 million hits, despite having a misspelling in the first paragraph. After this length of time, you would think that things would have changed and we would … Read more
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
T-SQL is my favorite aspect of working with SQL Server. The release of SQL Server 2005 coincided with the beginning of my involvement with the community as a presenter and author. For a while, I would put together a “What’s new with T-SQL” session for each release. Eventually, the windowing functions were such a big … Read more
Azure Data Studio is a great tool and supports way more than only SQL. Recently, Azure Data Studio included the support to Kusto language, or KQL. Kusto is a query language used for massive amounts of streamed data, perfect for logs. That’s why Kusto was initially created for Azure Monitor and Azure Log Analytics. However, Azure … Read more
Over the past few years, several new regulations regarding the privacy of data have been enacted. Many of these, such as the GDPR (General Data Protection Regulation) and CCPA (California Consumer Privacy Act) cover private data based on citizenship. The GDPR, for example, protects the data of European citizens regardless of where the holder of … Read more
You may have noticed the export feature on Azure resource groups don’t like too much the Data Factory. We can’t completely export a Data Factory as an ARM template, it fails. Probably you know you don’t need to care about this too much. You can link the data factory with a github repo and get … Read more
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
Before computers, the British, US and Canadians all entered dates with the full month-name first, followed by the day number, followed by an ordinal suffix (1st, 2nd, 3rd and 4th etc) followed by the year. It was generally the full four-figure year. I know all this because I’ve just been converting many thousands of these … Read more
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
A feature I have never actually used professionally is filestream and filetable. We have a few file based solutions, but they are all packaged solutions. It is a feature that has intrigued me since it was released, but it has never been a fit for the kind of work I typically do (mostly transactions and … Read more
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
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
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
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
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
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
Writing data integrity code in TRIGGER objects is generally is pretty simple. Typically you write a query to see “is there a row in inserted/deleted that is not set up as desired for the current transaction?” and no bad data is found, keep moving. And because MOST of the time, you would only use a … Read more
Simple Talk Bloggers
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
