Become the captain of your SQL Prompt ship by embarking on a voyage of discovery through the hidden treasures of the tool. You'll uncover features of the unknown that will enable you to write, format, analyze and refactor your SQL effortlessly. Join this webinar on December 16th to find out more.
2020-12-15
To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In this article, Joe Celko reviews normalizing databases including commonly used normal forms.
2020-12-15
Email based validation is more than just a simple RFC check, this is where Melissa's Global Email Verification with a web-based API and SSIS delivers valuable data to SQL Server Professionals.
2020-12-14
A data catalog allows an organization to discover and record the facts about its data, where that data is held and how it used. William Brewer explains the details.
2020-12-14
Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update.
2020-12-11
SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features of SQL Developer that can make you more productive.
2020-12-11
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-10
Join Microsoft MVP Grant Fritchey and Redgate's Owen Standage on a journey through the hidden treasures of SQL Prompt. Discover features of the unknown that will enable you to write, format, analyze and refactor your SQL effortlessly.
2020-12-10
There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come up with a plan that protects the organisation’s data. In this article, Pamela Mooney explains service level agreements, recovery models, and some strategies to ensure that the data can be restored quickly.
2020-12-09
It's your last chance to take part in the 2021 State of Database DevOps survey! If you or your organization uses databases, we want to hear from you! Complete the survey for advance access to the final research report, and to be entered into a prize draw for a $500 Amazon voucher. Plus, for each submission we receive, we’ll donate $1 to the World Health Organization’s COVID-19 Solidarity Response Fund. Take the survey here.
2020-12-09
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Hey, I've not done a cube for many years but I find myself supporting...
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers