What’s New Type BlogEvents & Workshops The (real) difference between the ‘SELECT … INTO’ and ‘INSERT … SELECT’ statements Discover why ‘SELECT … INTO’ often outperforms ‘INSERT … SELECT’ in SQL Server, and how a simple locking hint can level the playing field. A Basic Overview of Locks in SQL Server Discover how SQL Server Locks work, why they matter, and how understanding them can prevent performance bottlenecks and data inconsistencies in your database. How to Prevent Robocopy from Hiding Your Files and Find Them When it Does. Learn how a hidden bug in Robocopy can make your folders vanish in plain sight—and discover the quick fix and key parameters to prevent it from happening again. SQL Agent history – A most confusing dialog box SQL Server’s default job history retention can cause performance issues due to contention on the history table; it’s better to disable automatic retention and use a custom cleanup job. Domain-Independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group Windows Failover Clusters evolved to allow domain-independent configurations, enabling flexibility for nodes across different domains or workgroups, particularly with SQL Server AlwaysOn Availability Groups. Inside the Transaction Log file using fn_dblog() and fn_full_dblog() This post explores how fn_dblog() reveals detailed transaction log activity and helps compare SELECT…INTO vs INSERT…SELECT performance. Azure Service Endpoints – how do they work? This post explains how Azure Service Endpoints let VMs securely access services like SQL and Storage through the Azure network instead of public IPs. Securing connections to SQL Server with TLS How to encrypt SQL Server connections using TLS to meet GDPR requirements, covering certificate setup, configuration for standalone and clustered environments, and tips for ensuring secure, validated connections. Using Date Pickers in Power BI Report Builder A quick walkthrough of how I used Power BI Report Builder and Date Pickers to build a paginated, filterable report from a Power BI Dataset. How to Generate your Power BI Reports with Power Automate Power Automate can schedule and export Power BI Paginated Reports to SharePoint, with email notifications on completion. How to Avoid These 5 Common Cloud Migration Challenges Discover how to overcome common cloud migration challenges and ensure a successful transition with expert tips and strategies—read the full blog now! Get The Most From Azure Cloud – A Practical Guide For Businesses Discover how Azure Cloud can help your business improve efficiency, control costs, and strengthen security with the right tools and strategies. Posts pagination << 1 2 3 … 5 >>
