Louis Davidson discovers the joy of using SQL Prompt code snippets to remove repetition from a variety of tasks, from inserting comment headers, to creating tables, to executing useful metadata queries.
2020-02-20
Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.
2020-02-19 (first published: 2013-08-28)
105,836 reads
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 to determine what data needs to be masked, implement a masking plan, and then to apply the masking operation, to protect sensitive and personal data in all the tables and columns of your SQL Server databases.
2020-02-19
While writing T-SQL code, sometimes it is necessary to divide the retrieved data into categories and perform specific operations based on their category.
2020-02-19
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
4,685 reads
Five years ago, there were a limited number of ways to deploy and use the SQL Server engine in the Azure Cloud. Today, there are many different services available.
2020-02-18
The fourth annual State of Database DevOps report is now available for download. Kendra Little announces the launch in her latest blog. Check out the first high level findings of the report here.
2020-02-18
When the database design is not great, you may have to write some creative queries to get what you need.
2020-02-17
2,930 reads
Floating point datatypes accommodate very big numbers but sacrifice precision. They are handy for some types of scientific calculations, but are dangerous when used more widely, because they can introduce big rounding errors.
2020-02-17
Dr. Dallas Snider, a MSSQLTips author, mentioned that SQL Server RAND() function could generate random values uniformly distributed from 0 through 1, exclusive. He generated random numbers from the normal distribution with a specific mean and standard deviation.
2020-02-17
By Brian Kelley
I recently received the news that I’ve been renewed as a Friend of Red...
I’ve been very blessed to be able to work for Redgate Software. We’ve done...
Extended Events can do things that simply are not possible with Profiler and another...
I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...
Hi, I want to run the below query to get information about the tables...
Hello SSC, I am looking for a simplified way to track which user created...
Ask SSC