SQL Server Database Users to Roles Mapping Report
In this tip we look at a SQL Server function that generates a report of all users and their assigned database roles.
2019-04-24
Articles
5 reasons why backup and restore doesn’t cut it in dev and test
The provisioning process is a critical part of database development. Redgate’s Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.
2019-04-24
Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
Its time to accelerate the State of DevOps
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
Compressed Microsoft SQL Server Backups by Default
Learn how to create default database compression for your SQL Server databases.
2019-04-23
Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS
Using Azure Feature Pack for Integration Services to access Blob storage from Azure into SSIS packages
SQL For Cosmos DB – Tips and Tricks
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
Service Broker Part 2: Why Service Broker
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.
Easing the transition from shared to dedicated database development
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 Considerations for ERP Applications
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
Blogs
CISA Accredited Trainer!
By Brian Kelley
My certification came in! I’m now accredited to provide training for the Certified Information...
Correlated Subqueries vs Derived Tables
By Bert Wagner
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However,...
Video – Creating Azure SQL Database
By Arun Sirpal
A quick 2 minute upload (with sound, my voice) showing you how easy it...
Forums
Can Azure Stack Reduce Software Development Costs?
Comments posted to this topic are about the item Can Azure Stack Reduce Software...
Splitting a multi-dimensional Array in SQL Server 2012
Hello, I have data from an Orders table has the following columns; OrderId (int)...
Ask SSC