Azure Database Migration Service (DMS)
As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that makes it easy to migrate from on-prem/RDS to Azure...
2018-09-26
50 reads
Azure Database Migration Service (DMS)
As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that...
2018-10-08 (first published: 2018-09-26)
2,761 reads
sqlhelp: limit the x-axis of a geometry line graph
I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide...
2018-09-26
385 reads
No More Mysterious Truncation
If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions...
2018-10-09 (first published: 2018-09-26)
3,374 reads
My Experiences Tech Editing Pro SQL Server on Linux
The Opportunity Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the email was “Tech edit a book” and he...
2018-09-26
20 reads
My Experiences Tech Editing Pro SQL Server on Linux
The Opportunity
Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the...
2018-09-26
287 reads
Data Types Word Search
Just for fun here is a word search with all of the data types available in SQL Server. Well, two...
2018-10-05 (first published: 2018-09-26)
1,843 reads
Cycle SQL Server Error Logs
I saw this again recently and see it too often in environments so wanted to take a second to remind...
2018-10-04 (first published: 2018-09-26)
2,747 reads
Coming Soon to Minnesota...Lincoln...and Seattle!!!
It's that time of year when SQLSaturdays start to slow down (in the U.S. anyway) as we march towards Summit...
2018-09-26
341 reads
Why you should always build an Azure based VM in a Resource Group
This blog post is based on conversations I witnessed between MVPs around commissioning and more importantly de-commissioning virtual machines (VMs)...
2018-09-26
769 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers