Other Dennes Torres in Other 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
Other Phil Factor in Other 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
Other Binny Joshi in Other 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
Other Louis Davidson in Other 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
Other Sameer Shukla in Other 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
Other Dennes Torres in Other 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
Other Louis Davidson in Other 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
Other Dennes Torres in Other 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
Other Mithun Gaur in Other 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
Other Louis Davidson in Other 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
Other Dennes Torres in Other 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
Other Dennes Torres in Other Start and stopping all Virtual Machines on a Resource Group Some tasks on azure are easier if we automate them. The Azure Portal provides us the cloud shell, which we... 10 August 2020 4 min read
Other Louis Davidson in Other How to modify a SQL Server Graph Edge with T-SQL As I have been writing a section on SQL Server graph tables in my Database Design book, (and prepping for... 10 August 2020 6 min read
Other Dennes Torres in Other How to not go mad with schema compare in SSDT SSDT (SQL Server Data Tools) is really great to manage database schema changes. However, due to a disappeared feature, SSDT... 03 August 2020 2 min read
Ben Rees How Mature is Your Database Change Management Process? How do you get your database schema changes live on your production system? As your team of developers and DBAs... 01 August 2020 8 min read
Other Dennes Torres in Other Extracting DACPAC even When SQL Server refuses to There are many situations when you need to extract a DACPAC from an existing database in a SQL Server. These... 27 July 2020 3 min read
Other Premanand Dheenadayalan in Other Batch Framework In SDLC (software development life cycle) process, creating a batch job is the last step. As the application maintenance grows... 08 July 2020 11 min read
Other Phil Factor in Other SQL Server JSON Diff: Compare JSON Documents in T-SQL Compare two JSON documents in SQL Server using a T-SQL table-valued function that returns row-by-row differences, matches, and missing properties... 06 July 2020 10 min read
Other Louis Davidson in Other The Pros and Cons of Virtual Conferences: Just My Opinions Before taking any time with the rest of my SQL Saturday Chattanooga, Home Edition teammates to discuss what went right and... 30 June 2020 12 min read
