Row Level Security is one of many new features in SQL Server 2016. It provides a much easier, consistent, and maintainable solution for row-based security rules. In this blog post, Data Platform MVP Steve Jones introduces this new feature, and walks through how Redgate SQL Compare can safely and reliably handle RLS changes.
U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.
Tim Smith shares some ideas about how to handle and alert on irregular data coming from APIs when loading your database.
Protecting the keys used for encrypion can really matter for companies, and in today's complex world, that can be difficult. Monitoring becomes important to helping here.
Read about the Restore Genie and the new support for fork points, Azure and Multiple Concurrent Restores.
Power BI allows you to connect directly to the data just as if it were a “standard” connection, and modify and extend the data to support analytics. By using DirectQuery, you can build reports based on extremely large datasets where re-importing data not a practical solution. It also allows you to do data aggregations on the server. There are, of course, restrictions as well but it is nevertheless a worthwhile technique to use where appropriate. Adam Aspin explains all.
this article describes about creating partitions on our existing Tables and also gives details about how to create rolling partition to support new data
Steve Jones thinks version control is important, even for databases.
To survive the inevitable downturns in the IT industry, Phil Factor argues that a IT manager needs to take time to maintain technical skills. It is not enough to understand development; you have to be able to do it.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers