SQL Server Agent is a Microsoft Windows service that allows a DBA to automate administrative tasks. SQL Server Agent can run jobs, monitor SQL Server, and process alerts. The SQL Server Agent service must be running before any jobs scheduled to execute automatically can be run
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.
While writing T-SQL code, sometimes it is necessary to divide the retrieved data into categories and perform specific operations based on their category.
Gouri Shankar provides an overview of normalizing a database.
Today, Julia Hayward explains how Redgate is leveling up core skills.
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.
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.
When the database design is not great, you may have to write some creative queries to get what you need.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
J & K, Jl. Caman Raya No.17, RT.003/RW.003, Jatibening, Kec. Pd. Gede, Kota Bks,...
Whatsapp 083831618865 Komplek, Kopo Mas Regency, Blok 09C, Margasuka, Kec. Babakan Ciparay, Kota Bandung,...
Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1, 9...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers