Redgate is joining forces with DevOps Research and Assessment (DORA), now part of Google Cloud, as a sponsor of the 2019 Accelerate State of DevOps Report, and we’re excited to see what the research uncovers.
This year, the survey’s focus areas include deployment toolchains, cloud, disaster recovery, the technical environment, how we work, and more. Take the survey to help us understand how to make the (software) world better.
2019-04-23
Learn how to create default database compression for your SQL Server databases.
2019-04-23
Building on the introduction to the SQL used by Cosmos DB in the first article in the series, here you will learn how to handle some of the more…
2019-04-22
The second part of this series focuses on the advantages of Service Broker over other messaged-based technologies to introduce asynchronous message processing into your database applications.
Working in a dedicated database model is the ideal. So, what does it take to move from shared development to a dedicated model? Infrastructure costs, merging multiple changes and maintaining an increased estate might be on your list of things to consider before committing to the switch. In this article we show how Redgate tools can ease the transition and new working approach.
2019-04-22
Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the security aspects of ERP systems and some of the techniques used to protect data.
2019-04-19
Whenever you’re ready to refresh a test cell with the latest database version, you need a safe way to drop the current set of clones, and the parent image, without losing any unsaved work. Phil Factor provides a PowerShell script that automates this process so it runs in the time it takes to grab a coffee, after which can quickly deploy the new clones.
2019-04-19
Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.
This week, Brent is demoing SQL Server 2019 features that he’s really excited about, and they all center around a theme we all know and love: parameter sniffing.
2019-04-18
Louis Davidson reveals some useful Prompt features for refactoring individual code blocks or modules during development, which will improve code quality, reduce tedium, make testing simpler, or sometimes all three.
2019-04-18
By damianwidera
It was an Easter Monday yesterday and I thought it was not a good...
By Angela-Henry
I am happy to announce that I will be speaking at SQL Saturday Raleigh...
(last updated: 2019-04-22 @ 13:00 EST / 2019-04-22 @ 17:00 UTC ) SQL Server...
Hi all I have the following SQL SELECT Account, LogDateTime, RowId, Cell, lag(LogDateTime) over...
I have an XML which Iam trying load with the following SQL code. But...
Comments posted to this topic are about the item Creating Statistics
Ask SSC