I’ve just finished watching Gems to Help You Troubleshoot Query Performance by Pedro Lopes in the GroupBy Channel on YouTube (training resources for SQL Server don’t come much better, and it’s free – go check it out). Pedro works in the
I wanted to write a blog post which involved using the Microsoft AventureWorks sample database, but then I realised I didn’t know how to transfer the MDF file to Docker or even if I could attach the file using SQL
Although I love attending the SQLBits SQL Server conference, I always come away with a list of weekend projects and new things to learn. One thing I noticed in almost every session I attended was the demos were mostly in
I was shocked when Microsoft first announced in July last year that they were releasing SQL Server for Linux, and my first question was – why? But after my recent visit to SQLBits SQL Server conference, I think I now have
Following my last post (Setting up Database Mail to use my Gmail account) where Database Mail was set up to send to a GMail account, this post looks at how to send reports in HTML direct to a mailbox using just
This week I had to setup a sandbox environment to test sending some HTML reports (created by a SQL Server stored procedure, more on this next week) I’d prepared for a client, and wanted delivered to my mailbox each morning.
Recently encountered an issue on a client site where they have automatic Database Mirroring failover but when it came to failing over it didn’t work! (the automatic failover of the database worked but the website couldn’t connect).This quickly becomes a