Negative identity values don’t suck
A quick(er) post this week, in response to Greg Low’s blog post from a few weeks ago titled “Don’t start identity columns or sequences with… Read More »Negative identity values don’t suck
PASS Summit 2020 pre-con time
In 2018, I entered Speaker Idol at the PASS Summit, and because I forgot to start my timer I was disqualified for running over the… Read More »PASS Summit 2020 pre-con time
How SQL Server stores data types: dates and times
This post dives into how SQL Server stores date and time data types in memory and on disk. But first, a note about endianness: CPUs… Read More »How SQL Server stores data types: dates and times
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_
Join me (virtually) in Adelaide!
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!
Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance
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
sql2xls goes cross-platform
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
On the continuity of business
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
Join me in Victoria this Saturday
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
Deprecated and discontinued features in SQL Server
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
Join me at SQLBits 2020 (maybe)
(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)
Disaster recovery, tools edition
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
Dealing with rejection
“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
I’m a DBA. Do I really need to know Kubernetes?
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?
What is a strong password anyway?
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?