This post is a response to this month's T-SQL Tuesday #114 prompt by Matthew McGiffen. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-05-14
23 reads
Quite a significant change has taken place within the Azure SQL Database space, more specifically the development of Azure SQL Database Serverless. Currently in preview mode this “compute” tier changes...
2019-05-14
340 reads
Today it was a workshop day at SQLDay. Five workshops (one unfortunately has been cancelled). I think at least 300-350 people have attended the conference during the first day....
2019-05-14
37 reads
I’ve had this code in a snippet for a long time: I appreciate the markup to prevent SQL Prompt from doing this, which used to always happen. I can’t...
2019-05-13
141 reads
In my role I am still on-call several times each month, and many of the escalations that come are simply things that newer DBA's and Help Desk staff have...
2019-05-23 (first published: 2019-05-13)
472 reads
I spend a lot of time showing how to use tools to automate database deployments in support of DevOps. However, the one message that I always try to deliver...
2019-05-24 (first published: 2019-05-13)
305 reads
Hello folks! One week passed, another one almost began. And that will be a crazy week on two conferences. Today, I’m in Wroclaw (Poland) where we’re prepping SQLDay conference...
2019-05-13
28 reads
If you are like me and were unable to get away from the office to attend Microsoft Build 2019 you will be glad to know that Microsoft has published...
2019-05-10
107 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Which of these is more complex? GRANT SELECT...
2019-05-23 (first published: 2019-05-10)
613 reads
If you haven’t read the proposed changes yet you should do that first and form your own opinion before reading mine. Thoughts here are high level, not a line...
2019-05-10
111 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Kawasan Terpadu The City Center, Gedung Perkantoran Tower One, Ground Floor, Jl. K.H....
WhatsApp:0817819444 Jl. Raya Laswi No.212 A, Majalaya, Kec. Majalaya, Kabupaten Bandung, Jawa Barat 40382
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