Database Fundamentals #24: More Filtering Data
In this Database Fundamentals post we continue discussing the functionality of the WHERE clause. We started with the basics of the logic using things like AND, OR and LIKE...
2020-05-04
106 reads
Blog Posts
Decoded Statistics Names and More
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we...
2020-05-04 (first published: 2020-04-17)
613 reads
Improved Windows Terminal Setup
I’ve long been a Cmder/ConEmu user for Windows as it’s provided a much-needed improvement of the standard Windows terminal.
I’ve started trying to use the newer Windows Terminal project to...
2020-05-04 (first published: 2020-04-20)
356 reads
SQL Homework – May 2020 – Forum Lurking.
A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among ... Continue reading
2020-05-04
23 reads
Stairway to Microsoft Azure SQL Database Part 2 : Purchase Models DTU vs vCore
In the last post, we have discussed about different deployment options available with Azure SQL server. I hope you got a good understanding of various deployment models. In this...
2020-05-03
694 reads
Stairway to Microsoft Azure SQL Database Part 2 : Purchase Models DTU vs vCore
In the last post, we have discussed about different deployment options available with Azure SQL server. I hope you got a good understanding of various deployment models. In this...
2020-05-03
8 reads
ASF 031: Paul Andrew interview
Introduction Paul Andrew. Principal consultant and architect at Altius specialising in big data solutions on the Microsoft Azure cloud platform. Data engineering competencies include Azure Data Factory, Data Lake,...
2020-05-02
2 reads
Data Community #DataWeekender Europe 2020: Ethics in Modern Data
On Saturday May 2 Christine and I are presenting at the Data Community #DataWeekender Europe 2020 online conference, an all-online free virtual popup Microsoft Data Conference hosted by various professionals...
2020-05-02
15 reads
Be warned: The way I’m feeling right now I might actually give you sysadmin when you ask for it.
You want sysadmin permissions in production? And your manager has approved it so I shouldn’t have any problems giving it ... Continue reading
2020-05-01 (first published: 2020-04-20)
692 reads
Coding Standards Gone Bad in SQL Server
Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I...
2020-05-01 (first published: 2020-04-21)
1,039 reads
Blogs
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
The Roundup for T-SQL Tuesday #192
By Steve Jones
Last week I asked you to write about SQL Server 2025 and what things...
Writing Better Dynamic SQL
By SQLPals
Writing Better Dynamic SQL This updated and "sort" of a style...
Forums
Don't Create Workslop
Comments posted to this topic are about the item Don't Create Workslop
What is the original database name?
Comments posted to this topic are about the item What is the original database...
The DBScan algorithm tutorial
Comments posted to this topic are about the item The DBScan algorithm tutorial
Question of the Day
What is the original database name?
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers