Save the Connection String Parameters in SSMS – AlwaysOn
In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...
2018-08-10 (first published: 2018-07-26)
2,598 reads
In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...
2018-08-10 (first published: 2018-07-26)
2,598 reads
It’s been a couple of weeks now since I took the plunge and bought myself a Dell XPS 13 running...
2018-08-10
312 reads
EDIT – 2018-10 – ACR Build is now known as ACR Tasks
In Part One I detailed how we can use ACR Build...
2018-08-09 (first published: 2018-07-25)
1,535 reads
I have recently started as an author for MSSQLTips.com website, this is an excellent site where you can start writing...
2018-08-09
196 reads
At this year’s TechnoSecurity and Digital Forensics Conference I gave a 1 hour presentation on auditing SQL Server. There were...
2018-08-09
270 reads
Follow a few of the SQL Family on Twitter and you’ll mostly see one view regards SQL Profiler, and it’s...
2018-08-09 (first published: 2018-07-25)
2,273 reads
This is my first installment in (I hope) a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the...
2018-08-08
13 reads
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...
2018-08-08 (first published: 2018-07-25)
2,043 reads
I am very excited about my upcoming IEAzure class being held in London, September 10th and 11th at the Marriott in Kensington (London).
This...
2018-08-08
373 reads
I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is...
2018-08-08
483 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