Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a regular basis. Unfortunately, cleansing and validating data is difficult with the native SQL Server toolset. How do we leverage the SQL Server tool set to achieve these goals?
2020-01-03
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that can create a window for a countdown timer.
2020-01-02
SQL Change Automation 4.1 now allows users to develop static data changes from SQL Server Management Studio.
2020-01-02
If you’re looking for SQL Server news, just skip this post. Brent talks about general business & capacity planning type stuff here today.
2020-01-01
In this article we look at different T-SQL examples to create a new SQL Server database.
2019-12-31
Khie Biggs, a software developer on the Data Masker team at Redgate, explains how a recent set of Data Masker improvements should make it significantly easier and faster both to determine what data needs to be masked, and then to apply the masking, to protect sensitive and personal data in the tables and columns of your SQL Server databases.
2019-12-30
Understanding all the storage options available to...
2019-12-30
The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.
2019-12-27
Automation of server builds minimizes human error, ensures that environments are identical, and saves time building servers. This article from Mircea Opera demonstrates provisioning one server or multiple load-balanced servers in AWS with code.
2019-12-26
Between the legislation over the years (HIPAA, GLBA, GDPR, CCPA, etc.) and data breaches from large organizations that seem to pop-up in the news on a monthly basis, SQL Server database encryption is critical for our industry. SQL Server ships with a few options for a native encryption implementation (Column Level Encryption, Transparent Data Encryption, Data Masking, Always Encrypted), that all provide value in particular situations, but none of the options all seem to address all of the needs. What is the best way to encrypt our SQL Server data?
2019-12-26
Your AI is busy. But do you know what it's worth? Most companies can...
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Comments posted to this topic are about the item MiniMax m3 and SQL Server
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers