Redis is an in-memory NoSQL data store. Memory is faster than disk, but there are still ways to improve performance. In this article, Camilo Reyes compares caching strategies.… Read more
SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.… Read more
It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares several query methods to see which one performs the best.… Read more
GraphQL is a platform-independent, language-neutral query language and may be used to run queries and retrieve data. Joydip Kanjilal explains how to use GaphQI in an ASP.NET Core 5 app.… Read more
Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data. … Read more
SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.… Read more
I recently became a certified Professional Scrum Product Owner (PSPO). As of today, there are less than 110,400 of us in the world. When a colleague asked me what I had learned, I prattled off the usual salient features of what it means to be a PSPO. The same evening, however, the question returned to … Read more
The 2002 movie Minority Report is about a police unit called PreCrime, which can predict when people will commit a crime so they can be arrested before it happens. Things go awry when a team member played by Tom Cruise is himself “pre-accused.” To make predictions, they use technology and the special abilities of the … Read more
The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works.… Read more
I am trying so hard not to roll my eyes right now. I re-read the sentence. “Cherish criticism instead of getting offended by it!” says the feedback in bright, breezy tones with a liberal dollop of self-righteousness. Try as I might, I cannot keep the patronising tone out of my head. I give up, and … Read more
Jamstack is not a toolset; it’s a development methodology that can improve performance, productivity, and flexibility while keeping maintenance simple. Julio Sampaio explains what it is and why you might want to use it.
… Read more
No one is good at something right when they start. When starting something new, it’s normal to feel terrified or have “imposter syndrome.” You’ll constantly be rubbing shoulders with people that are more experienced, more talented, or seemingly more confident. It takes a long, long time to get good at something. Of course, there are … Read more
Changing the UI in games makes the games more fun to play. Lance Talbert demonstrates how to use post-processing effects in Unity to change the game.… Read more
DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to enable SQL Server trace flags.… Read more
Monads elevate basic C# types and unlock functional patterns, similar to containers. In this article, Camilo Reyes explains functional monads in C#.… Read more
Many of you know that Redgate purchased some of the assets of PASS, namely session recordings, domain names, and trademarks. Shortly after that purchase, we began talking about what it would take to put on an event to revive PASS Summit. The first step was to survey to find out what people liked and wanted … Read more
Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres demonstrates how to do that and also asks why.… Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
