Additional Articles

Benefits and Limitations of SCHEMABINDING Views in SQL Server

by Additional Articles

MSSQLTips.com

SQL Server

The tip, Views in SQL Server, explored the purpose of views, creating views examples, and benefits of views. A view is a virtual table that references the actual database tables stored in the database. What if someone changes the underlying table structure, such as renaming the column, adding a new column, or dropping the table? What is the impact of changing schema on views? How can we stop any schema changes if the view references the schema?

2023-05-08

Redgate opens the doors to cross-database DevOps Test Data Management

by Additional Articles

Redgate

Vendors/3rd-party Products

Redgate’s new DevOps test data management tool, Redgate Clone, provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases.

2023-05-08

Cheat Sheet for SQL Server DBA Daily Operations

by Additional Articles

MSSQLTips.com

Database Administration

This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.

2023-05-05

Finding External References in Database Deployments

by Additional Articles

Redgate

Vendors/3rd-party Products

This article outlines the syntax of the three and four dot references that usually denote external database references, demonstrates how to find them either from a live database or by using a text search of a script, and explains some of the complicating factors that can lead to 'false positives'.

2023-05-05

PASS Data Community Summit registration is open!

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.

2023-05-03

PostgreSQL Basics: Object Ownership and Default Privileges

by Additional Articles

SimpleTalk

PostgreSQL

Understanding how roles and privileges work in Postgres is key to understanding the next, and often more confusing part of security, object ownership.

2023-05-03

How to Slice Data by Week in a Calendar Table using DAX

by Additional Articles

MSSQLTips.com

Judging from my experience working with business stakeholders across several organizations, slicing data by current week, previous week, two weeks ago, and so on has become a requirement for reporting. I will demonstrate a simple approach to achieve this requirement.

2023-05-01

Working with Flyway And Entity Framework Code First: An Overview

by Additional Articles

Redgate

Vendors/3rd-party Products

This article presents an approach to database development and deployment that combines the strengths of Entry Framework Code First for .NET-driven development with the control and database versioning provided by Flyway's SQL migrations. It allows every database change to be reviewed and tested for integrity, performance, and stability in the same way as any application change. It should make a Database CI process much easier to sustain.

2023-05-01

How to Automate Cross-Platform Database Development

by Additional Articles

Redgate

Vendors/3rd-party Products

In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.

2023-04-28