(Hemant K Chitale) Continuing the previous post, what happens when there is an UPDATE to the source table ?
Community
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
(Pinal Dave) When I work with Comprehensive Database Performance Health Check, I get all sort of questions and I love answering them. Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.
Using JSON Based Entities for Caching Remote Data in C#
(honey the codewitch) Aside from a clean way to query remote JSON/REST based services, you usually need a way to cache and index the data you get back.
SQL Server Statistics and how to perform Update Statistics in SQL
(Rajendra Gupta) This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics.
Power Query/M Optimisation: Getting The Maximum Value From A Column, Part 2
(Chris Webb) In part 1 of this series – which I strongly recommend you read before reading this post – I showed how removing columns from a table can make a dramatic improvement to the performance of certain transformations in Power Query.
Delete Data Safely with SQL
(Hannes du Preez) You never know what can happen when you attempt to delete data. Some may argue that it is best to delete data through a client application, some may say it is better to do so through SQL Server itself, by using SQL code.
The Two Aspects of Db2 for z/OS Support for JSON Data
(Robert Catterall) JSON (JavaScript Object Notation) is a form of data representation that is popular with people who develop what you might call “very modern” applications, including those that are cloud-based and those that have a mobile front-end.
Avoiding bugs with data structures: using Sets in JavaScript
(Jack Franklin) Today we’re looking at how you can avoid bugs for free by picking the right data structures for what you’re working with.
Minimize new in Automated Tests
(Steve Smith) Automated tests have gained a lot of acceptance in recent years. Not long ago, many organizations bristled at the notion of having their expensive developers spend time writing code that wasn’t actually going to ship to production, but instead would just verify that the “real” code wor
Dependency Injection in Azure Functions
(Gunnar Peipman) Azure Functions V2 supports ASP.NET Core like dependency injection. It is specially good if we write functions that are wrappers for shared libraries and components we are also using in web and other applications of our solution.