Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the...
2018-09-05
265 reads
Born SQL with Randolph West
Repair Visual Studio for Mac: Extension node not found in path
A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start....
2018-08-30
345 reads
A software architect replaces a relational database with a relational database
Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is...
2018-08-29
308 reads
Relational databases aren’t the problem
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is...
2018-09-10 (first published: 2018-08-22)
3,150 reads
Do you even PowerShell, bro? An ode to dbatools and dbachecks.
Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose...
2018-08-15
321 reads
Why you should not use SELECT *
A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we...
2018-08-08
469 reads
Don’t do these things in SQL Server
Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored...
2018-08-01
511 reads
Repair SQL Server on Linux after an Ubuntu distribution upgrade
SQL Server 2017 is supported on Ubuntu 16.04 LTS (Long-Term Support), however that version of Ubuntu Linux is now more...
2018-07-25
346 reads
Data lakes and swamps, oh my
I was lamenting to my friend and fellow MVP Shamir Charania (blog | Twitter) that I didn’t have a topic for...
2018-08-01 (first published: 2018-07-18)
2,974 reads
Performance as a feature, software developer edition
Relational database management systems (RDBMS) like SQL Server and Azure SQL Database are very good at managing normalized data. Efficient...
2018-07-11
324 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers