How SQL Server stores data types: DATETIMEOFFSET
If you’d like to check out the previous instalment in this series on storing dates and times, click here. I avoided mentioning this data type because I didn’t think...
2021-06-16
25 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
Things to check when restoring a database
Whenever I restore a database — especially one I obtained outside of my regular environment (for example a customer database, a development database, or even a sample database like...
2021-06-09
39 reads
The curse of the blank page
Last week I wrote about recovering data after an unplanned outage, and this week I’m contemplating a thing that would be considered bad in those circumstances as well as...
2021-06-02
7 reads
A quick primer on binary and hexadecimal
A few years ago, I wrote that a CPU is “a hot mess of on-off switches.” There’s more to it than that when you get into the weeds of...
2021-05-31 (first published: 2021-05-19)
422 reads
How I tackle disaster recovery
One of my special interests as an autistic person is understanding mechanical components of a computer, both analog and digital. In the olden days, we had devices known as...
2021-05-26
21 reads
T-SQL Tuesday Retrospective #015: Automation
In February 2011, Pat Wright invited us to talk about Automation: So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or...
2021-05-12
9 reads
T-SQL Tuesday Retrospective #014: Resolutions
At the end of 2010, Sean McCown (blog | Twitter) invited us to talk about resolutions: Things like getting certified, or perfecting a process, or taking management classes, etc...
2021-05-05
10 reads
Ambling through undocumented DBCC commands may result in boredom
There comes a time when we heed a certain call. The call is to avoid dangerous undocumented DBCC commands in SQL Server, especially those that bypass built-in protections. I’m...
2021-04-28
12 reads
Calgary Data User Group with Deborah Melkin and Andy Yun
Next week on Wednesday is the Calgary Data User Group’s second event for 2021, and the second event as a member of Microsoft’s new Azure Data Community. Since last...
2021-04-21
9 reads
How does the buffer pool handle low memory conditions?
(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you...
2021-04-20 (first published: 2021-02-17)
538 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
Computer Algebra
Comments posted to this topic are about the item Computer Algebra
Renaming a Database
Comments posted to this topic are about the item Renaming a Database
A First Look at SSMS 21
Comments posted to this topic are about the item A First Look at SSMS...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers