Blogs Kendra Little in Blogs Database DevOps Considerations for SQL Server Availability Groups One question which comes up periodically from our Microsoft Data Platform customers is whether there is anything special that they... 19 November 2020 4 min read
Blogs Phil Factor in Blogs Unwrapping JSON to SQL Server Tables If you know the structure and contents of a JSON document, then it is possible to turn this into one... 04 November 2020 10 min read
Blogs Louis Davidson in Blogs Ignore the technology for a moment, let’s talk about the problem Twelve and a half years ago I wrote my largest hit count article of my writing career Ten Common Database... 26 October 2020 9 min read
Kendra Little in Blogs Reordering Deployments in Database DevOps We recently received an interesting question in our Redgate forums from Peter Daniels about altering the order of deployments in... 26 October 2020 17 min read
Blogs Kathi Kellenberger in Blogs What you’ll learn at my 2020 PASS Summit presentation T-SQL is my favorite aspect of working with SQL Server. The release of SQL Server 2005 coincided with the beginning... 22 October 2020 3 min read
Blogs Dennes Torres in Blogs Connecting to Log Analytics using Azure Data Studio and KQL Azure Data Studio is a great tool and supports way more than only SQL. Recently, Azure Data Studio included the... 20 October 2020 8 min read
Blogs Kathi Kellenberger in Blogs US Insurance Industry Data Security Regulations Over the past few years, several new regulations regarding the privacy of data have been enacted. Many of these, such... 19 October 2020 4 min read
Blogs Dennes Torres in Blogs Deploy Data Factory from GIT to Azure with ARM Template You may have noticed the export feature on Azure resource groups don’t like too much the Data Factory. We can’t... 12 October 2020 2 min read
Blogs Dennes Torres in Blogs Data and Azure links you don’t want to miss Browser tabs hold some similarities with tribbles in the way they multiply. Before you can notice, you have hundreds of... 05 October 2020 6 min read
Blogs Phil Factor in Blogs Converting Manually-Entered Strings to Dates Before computers, the British, US and Canadians all entered dates with the full month-name first, followed by the day number,... 17 September 2020 7 min read
Blogs Binny Joshi in Blogs Web Scrapping with Python using BeautifulSoap Today the internet is completely associate with large source of data. Inappropriately, the huge majority of it isn’t out there in... 16 September 2020 11 min read
Blogs Louis Davidson in Blogs SQL Server FileTables and FileStream: Managing Image Files with T-SQL and Windows Folders Use SQL Server FileTables to manage image files with both T-SQL queries and Windows folder access simultaneously. Walkthrough covers enabling... 16 September 2020 12 min read
Blogs Sameer Shukla in Blogs Understanding Data Modifications in Cassandra This article explains about how the data modifications is handled by Cassandra, to handle Update’s and Delete is effectively we... 15 September 2020 11 min read
Blogs Dennes Torres in Blogs Finding Unused SQL Server Indexes with sys.dm_db_index_usage_stats Identify unused SQL Server indexes using sys.dm_db_index_usage_stats and query plan XML analysis. Covers the XQuery expression fix for filtering update-only... 14 September 2020 9 min read
Jason Crease Database Continuous Integration with SQL CI and Jenkins Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated... 10 September 2020 3 min read
Blogs Louis Davidson in Blogs Weighted Randomization In T-SQL When I am not working on or writing about SQL, I am posting theme park pictures on Twitter of DisneyWorld... 02 September 2020 7 min read
Blogs Dennes Torres in Blogs Responsible AI news from Build Microsoft Build took place more than a month ago, but only now I’m writting about it. I’m facing the danger... 24 August 2020 4 min read
Blogs Mithun Gaur in Blogs Understanding digital transformation & how it transcends to driving organizational growth Introduction Digital transformation is the process of undergoing multiple internal and external changes by an organization leveraging digital technologies to... 21 August 2020 10 min read
Blogs Louis Davidson in Blogs Trigger Validations and Isolation Levels Writing data integrity code in TRIGGER objects is generally is pretty simple. Typically you write a query to see “is... 18 August 2020 9 min read
Blogs Dennes Torres in Blogs Data Warehouse Concepts and the mix of names and technologies Once upon a time, we got the Data Warehouse concept. A concept as great as difficult to implement. The definition... 17 August 2020 6 min read
