To demonstrate that dynamic modules in PowerShell can be used to easily create objects with methods and properties, Phil Factor implements an expression analyser written in PowerShell, using a variation of Dijstra's Shunting Algorithm.
Data Science is a hot area and one to which quite a few people would like to move. Steve Jones has some thoughts on trying to get certified in this area.
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
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
I’ve been looking into ways to improve the connection between a website and its...
Comments posted to this topic are about the item When And How to Automate?
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers