What’s New Type BlogEvents & Workshops 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. 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. 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. 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. 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 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. Empowering Analytics with Microsoft Fabric – Our Evolution of Velox The arrival of Microsoft Fabric has opened new opportunities for our solutions accelerator, Velox, allowing us to enhance our architecture by migrating it into the Fabric ecosystem. Fabric combines several... A First Look at Fabric Mirroring for SQL Managed Instance A public preview of Fabric Mirroring for SQL Managed Instance was announced at Ignite 2024. This brings together 2 of my favourite technologies and allows customers to make the most... Our Journey to Becoming One of the UK’s Best Workplaces in Tech 2024 Find out what makes Coeo a standout workplace in tech, where growth, inclusivity, and collaboration drive success and inspire our team every day! My First Weeks at Coeo: Mark Beaumont, Data Platform Senior Engineer Mark Beaumont shares his first few weeks at Coeo as a Senior Data Platform Engineer, including exciting technical challenges and a welcoming company culture with office dogs, social events, and... Posts pagination << 1 … 4 5 6 … 8 >>
