Remember this if you want to use sp_
Erik Darling, of Erik Darling Data (blog | Twitter) recently posted a very interesting video (my YouTube playlist is all Erik Darling Data videos and… Read More »Remember this if you want to use sp_
Erik Darling, of Erik Darling Data (blog | Twitter) recently posted a very interesting video (my YouTube playlist is all Erik Darling Data videos and… Read More »Remember this if you want to use sp_
I will be presenting a session to the Adelaide SQL Server User Group on April 15th, 2020, and if you’re awake at that time (it’ll… Read More »Join me (virtually) in Adelaide!
WARNING: This post contains information that can get you fired if you use it without express written permission. In some jurisdictions it might get you… Read More »Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance
Last year I released sql2xls, a free open-source tool which lets you throw a bunch of scripts into a folder, run them automatically against SQL… Read More »sql2xls goes cross-platform
With entire countries shutting their borders, and people being forced to stay home and isolate themselves for as long as possible while health departments ramp… Read More »On the continuity of business
I will be presenting a new session, “Database administration through the ages,” at SQL Saturday #950 in Victoria this coming weekend. This is one of… Read More »Join me in Victoria this Saturday
My co-authors and I recently wrapped up the book SQL Server 2019 Administration Inside Out, which should be hitting the shelves in the next week… Read More »Deprecated and discontinued features in SQL Server
(Last edited on March 11, 2020) The SQLBits conference, which was to take place in London between March 31st and April 4th, has been postponed… Read More »Join me at SQLBits 2020 (maybe)
I just completed a chapter for another book where I spoke about the Recovery Point Objective (how much data you are prepared to lose) and… Read More »Disaster recovery, tools edition
“Dear speaker This serves as notice that your session submission was not selected for our upcoming event. We had a lot of sessions to sort… Read More »Dealing with rejection
Welcome to February 2020. It’s the second month of the year 2020! I remember sitting at a server with SQL Server 6.5 installed on it,… Read More »I’m a DBA. Do I really need to know Kubernetes?
Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have I Been Pwned (HIBP) for a number of years now. For… Read More »What is a strong password anyway?
That aging hippie (he likes Apple products and has a goatee) known as Brent Ozar wrote a post recently about his home office studio setup,… Read More »My home office setup
Here’s something that seems to keep coming up, but not frequently enough for me to write a blog post about until now: You should not… Read More »Don’t install SQL Server from a mounted ISO
In August last year I posted about a command line parser problem I ran into with AzCopy, which I eventually resolved by writing a batch… Read More »The curious case of the sqlcmd password