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
Additional 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
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
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
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
Parameter Sniffing in SQL Server 2019: Adaptive Memory Grants
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
Refactoring a Batch or Object with SQL Prompt
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
Configuring Azure SQL Databases Using Azure Resource Manager Templates
Template-based provisioning simplifies deployment and promotes principles of DevOps and Infrastructure as Code, making it the recommended method for implementing cloud-based services. However, its benefits extend beyond initial implementation, since you can apply it to configuring and maintaining existing Azure SQL Database instances. In this article, you explore an example of this approach.
2019-04-17
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