Blogs Dennes Torres in Blogs Power BI reading Parquet from a Data Lake Data Lakes are becoming more usual every day and the need for tools to query them also increases. While writing... 18 January 2021 8 min read
Blogs Dennes Torres in Blogs PASS is Dead – Long Life to SQLFamily This new year start with the death of PASS, the professional association that for so many years supported the SQLFamily... 04 January 2021 4 min read
Blogs Kathi Kellenberger in Blogs Security is hard work I was once a database administrator in charge of several SQL Servers hosting the databases of vendor apps. Right after... 22 December 2020 2 min read
Blogs Ajay Patel in Blogs Performing seed data to database from JSON using reflection We can work with two approaches in Asp.Net MVC i.e., DB first approach and Code first approach. Apart from that,... 17 December 2020 6 min read
Blogs Kendra Little in Blogs Predictions for Healthcare and Database Infrastructure in 2021 Grant Fritchey, Kathi Kellenberger, and I recently collected our ideas and predictions about how the healthcare sector will evolve in... 07 December 2020 4 min read
Blogs Kendra Little in Blogs Why it makes sense to monitor SQL Server deadlocks in their own Extended Events trace We recently had customer ask why SQL Monitor creates an Extended Events session to capture deadlock graphs, when SQL Server... 03 December 2020 4 min read
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 Filetables, Great For Business, Great For Hobbyist A feature I have never actually used professionally is filestream and filetable. We have a few file based solutions, but... 16 September 2020 11 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 Index Usage: finding indexes not being used I wrote before about how to check index usage on the database, in that article I wrote about exploring query... 14 September 2020 9 min read
