Tracking Underlying Object Changes in Views
Views in SQL Server are used to simplify writing queries and managing security, but’s it’s easy for views to eventually get out of sync with the underlying tables. In this article, Edward Pollack shows how to overcome this problem.
A Data Science Approach in Product Analytics
A significant part of product development is A/B testing. Simply put, this is where companies and product managers test to see a new version of their product versus the older one to make sure it’s worth publishing their features to the entire user base. In order to do this, an A/B test needs to be set […]
Getting Started with CQRS – Part 3
Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source.
The SQL Community Steps up in Time of Need
Healthcare workers are some of the many heroes working bravely in the face of the Covid-19 pandemic. To protect themselves and their patients, they must wear face masks during their entire shifts. This causes a great deal of ear irritation, so a strap was designed to make wearing the masks easier and alleviate pressure on […]
SQL Server Rounding Tips and Tricks
This article shows different options to use the rounding functions in SQL Server.
The Conferences of the Future
With many conferences going virtual, Steve wonders what the future holds.
Updated First Responder Kit and Consultant Toolkit for March 2020
In the immortal words of “Orange” Julius Caesar as written by Shake’s peer, “Beware the bugs of March.” It took us 2,064 years, but we’ve finally fixed those bugs, plus added a couple of new features.
Helpful Unix Commands/Debugging made easy
The purpose of this document is to walkthrough helpful Unix commands that would help use Unix/Linux operating system, debug & resolve any issues in a more efficient and timely manner.
Blogs
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
PowerShell Strikes Back: Know Your Quotes, Young Padawan
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
A Redgate Data Modeler Gotcha with Relationships
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
Forums
BCA KCU PEKALONGAN NO TELPON 087781685658
WHATSAPP 087781685658 Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa Tengah 51116
Cara buka blokir bank jago terkunci
Cara buka blokir Bank Jago yang terkunci (akun/kartu) paling cepat adalah melalui fitur Lupa...
Bagaimana cara mengoreksi nama pada tiket AirAsia?
Untuk Koreksi Nama Tiket AirAsia Anda, dapat menghubungi saluran resmi Call Center AirAsia di...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers