Last Updated on August 29, 2020 by John Morehouse In this post we’ll examine a quick and easy way to block all inbound connections to SQL Server. Sometimes the brilliance of a solution is lost in its simplicity. Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has […]
Azure SQL Database: Great Choice for Modern Cloud Applications
Microsoft offers several options for moving your SQL Server workloads to Azure. If you’re looking to host modern cloud applications, your best option is Azure SQL Database Service. For an overview of the business benefits of using data infrastructure services in the cloud, download “Future-Proof Your Data Infrastructure with Azure: […]
Finding Foreign Key Child Records In SQL Server
Foreign keys help to ensure referential integrity between tables. In other words, parent records cannot be deleted if there are child records present. This is a great thing and if you aren’t using foreign keys currently, you really should be. While very helpful with referential integrity foreign keys can introduce […]