Discover the latest market trends and assess your approach to test data management. For example, the Bloor analyst recognizes “…an increased emphasis on test data provisioning, as opposed to merely test data management.” The report also covers key capabilities offered by vendors in the market, including Redgate.
Establishing coding standards can help remove blockers to understanding code, improving quality and reducing maintenance. Faris Hilmi explains how having consistently formatted code plays a larger role in database development and how Redgate tools can best equip you for the task.
Kendra Little looks for a meaningful definition of automation as it applies to the software development process.
Steve talks about passwords and new guidance from Microsoft that short expiration periods are unnecessary and unhelpful.
Joining tables is a crucial concept to understanding data relationships in a relational database. When you are working with your SQL Server data, you will often need to join tables to produce the results your application requires. Having a good understanding of set theory, and the mathematical operators available and how they are used to join tables will make it easier for you to retrieve the data you need from SQL Server.
Adopting standardized processes in database development can free up the time of development teams for innovation and value adding work. Find out the 4 steps you can take to lay the foundations for standardized development in your team and pave the way for full automation.
In this tip we look at some of the advantages and disadvantages of using triggers in SQL Server.
Learn how you can ensure that scripts are executed in a specific order with Git and PowerShell for use in a Docker container.
Have you deleted a bunch of rows from a table that has an identity column value and now thins aren't working quite right? If so, read on...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Jl. Riau No.36, Tampan, Kec. Payung Sekaki, Kota Pekanbaru, Riau 28292
Jl. Imam Munandar No.312 C-D, Tengkerang Labuai, Kec. Bukit Raya, Kota Pekanbaru, Riau 28288
Jl. Jend. Sudirman No.448, Tanah Datar, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau 28115
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers