Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.… Read more
I first touched a SQL Server instance back in 1998 during a SQL Server 6.5 course. I hadn’t planned to take the class except that the small company I worked for had a remaining credit with one of the local training organizations. My manager thought it might be a good fit for me, but I … Read more
Video games would not be much fun without animation. In this article, Lance Talbert demonstrates Unity state machine behaviours to define code running during specific animation states.… Read more
Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.… Read more
After resisting learning Python for years, assuming it was just another object-oriented programming language, Andy Brown now gets what the fuss was about: Python really does make coding quicker. This article lists 10 reasons why Python is better than C# and will make your programming life easier (and two reasons, in fairness, why it might not).… Read more
SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.… Read more
Microsoft announced at the Ignite conference that SQL Server 2022 is on the way, and several significant new features should convince many organizations to upgrade soon after it’s available. It’s been three long years since SQL Server 2019 arrived, so these announcements are exciting to hear. Microsoft will announce details and additional features over the … Read more
Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware and what needs to be done to protect against it.… Read more
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
Last week, Steve Jones (@way0utwest), Grant Fritchey (@GFritchey), and I spent a few days at the Redgate Headquarters in Cambridge. Meeting at the office would not be unusual except for the times that we live in right now, as we typically get there about once a quarter. This is the first time that we’ve all … 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
It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates how to collect extended event data.… Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
