Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and Governance are muttering about transactionality and data transfer between systems. Do you restrict your developers from rapidly-evolving the data design for their domain or do you embrace the joys of NoSQL unconditionally? If you accept a polyglot database environment, where the NoSQL lambs coexist with the relational lions, how do you provide tools and common database concepts that everyone can use and understand?

Change Integer to BigInt on a Very Large Table

by Nisarg Upadhyay

SQLServerCentral.com

Data Types

This article will show how to change the data type of a column when the table contains more than 1 billion records.

Introverted vs Extroverted

by Ben Kubicek

SQLServerCentral.com

Editorial

A lot of us are introverted, so is there anything that can be done about it?

How to Do a SQL Server Architecture Review

by Additional Articles

Brent Ozar Blog

Architecture

How do you get management to help you figure out if a cluster or an AG is right for you? In this post, Brent Ozar explains the steps involved when doing a review of your SQL Server architecture.

Should We Move to Azure?

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones asks about moving to the cloud and how interesting that might be to the community?

SQL Server R Services: Working with Data Frames

by Additional Articles

SimpleTalk

R Services

Although you can get started with R in SQL Server without understanding data frames, they are a key structure of the R language that are the equivalent of SQL Server table variables. They give you many ways of manipulating and analyzing data and passing it between R and SQL Server. For a database professional, they provide a clear and familiar concept when getting to grips with integrating R into the database.

Protecting SQL Server Data

by John-Magnabosco

Redgate

books

This book holds the key to "encryption without fear". In it, John Magnabosco sweeps away some of the misconceptions surrounding SQL Server's encryption technologies, and demonstrates that, when properly planned and implemented, they are an essential tool in the DBA's fight to safeguard sensitive data.

Software Patents

by Steve Jones

SQLServerCentral.com

Editorial

Patents are one way that governments can spur innovation. However many people think software patents should be eliminated. Steve Jones doesn't think so, but would like reform.

What are you worth?

by Steve Jones

SQLServerCentral.com

Editorial

When negotiating your salary, it helps to know what the ranges are for your experience and area. Steve Jones gives a little advice today.

Dynamic Data Masking on Azure SQL Database

by Additional Articles

Database Journal

Azure SQL database

Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application. Read on to learn more.

Mixing MongoDB and Relational Databases in the Enterprise

Change Integer to BigInt on a Very Large Table

Introverted vs Extroverted

How to Do a SQL Server Architecture Review

Should We Move to Azure?

SQL Server R Services: Working with Data Frames

Protecting SQL Server Data

Software Patents

What are you worth?

Dynamic Data Masking on Azure SQL Database

Blogs

Five Ways Redshift Serverless Quietly Eats Your Budget

A Career of Memories

Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

Forums

Midjourney, Healthcare?

Changes, Happiness, and a Few Tears

BCP on Linux

Question of the Day

BCP on Linux