How to use tSQLt unit test framework with a SQL Server database in a docker container
This blog post describes how to add the tSQLt unit testing framework to a database running in a docker container....
2018-12-29
1,474 reads
This blog post describes how to add the tSQLt unit testing framework to a database running in a docker container....
2018-12-29
1,474 reads
This blog post describes how easy it is to install the tSQLt framework.
Don’t know much about tSQLt? If you are...
2018-12-29
521 reads
Recently I have had a number of customers looking for a high availability solution for MaxDB on Windows in the...
2018-12-28
472 reads
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly larger and I didn’t have much space on the...
2018-12-28
26 reads
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly...
2018-12-28
1,016 reads
On January 17, 2019, I will be giving a webcast with MSSQLTips on data modeling best practices. It’s scheduled for...
2018-12-28
1,343 reads
I like participating in the Advent of Code each year, though my participation often varies wildly as life gets in...
2019-01-09 (first published: 2018-12-28)
2,160 reads
Azure offers a lot of features that enable IT professionals to really enhance their environment. One feature that I really...
2019-01-08 (first published: 2018-12-28)
2,510 reads
Very much like what you may find with the airline industry, the black box recorder in SQL Server is not just a single method (device) implemented to capture all of...
2018-12-28
25 reads
Across many professions and industries there is often a need to have some sort of device that “audits” everything that...
2018-12-28
279 reads
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
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