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 manufactured by Intel and...
2020-04-22
158 reads
Erik Darling, of Erik Darling Data (blog | Twitter) recently posted a very interesting video (my YouTube playlist is all Erik Darling Data videos and Honest Trailers). In this...
2020-04-15
20 reads
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 be 9pm on April...
2020-04-08
55 reads
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 jail time as well....
2020-04-01
47 reads
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 Server and get the...
2020-03-25
58 reads
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 up to handle this...
2020-03-18
6 reads
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 my favourite SQL Saturdays...
2020-03-11
9 reads
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 or two. At the...
2020-03-04
92 reads
The SQLBits conference is taking place in London again this year, between March 31st and April 4th, and I’ll be there. I will not be presenting this year, but...
2020-02-26
10 reads
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 Recovery Time Objective (how...
2020-02-19
38 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers