What do you think the top 10 Database DevOps trends in 2021 are? Redgate has condensed 3,200 survey responses from IT professionals worldwide into a handy infographic. Discover insights such as the top challenge in improving software delivery performance and the correlation between DevOps adoption and high-performing teams.
Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.
Both Python and R have become very popular languages in the last few years, especially among data professionals. Which should you learn or use? Steve has a few thoughts.
Always Encrypted is a new security feature which was introduced in SQL Server 2016. Always Encrypted is a technology to ensure the data stored in a database remains encrypted at all times during SQL Server query processing. Always Encrypted allows clients to encrypt sensitive data, such as credit card numbers and national identification numbers, inside the […]
How to write idempotent DDL scripts that Flyway can run several times on a database, such as after a hotfix has already been applied directly to the production database, without causing errors.
Edward Pollack demonstrates how SQL Server plan cache mining can uncover a wealth of information to help with troubleshooting performance issues.
I want to show you how two common operators can deceive you into believing you have constructed a proper SQL statement for your solution. We may want to filter results in a table by using using a IN/NOT IN or a INNER JOIN/LEFT JOIN to another table. There are a couple of hidden dangers here […]
Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL and NoSQL databases.
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers