Managing Logins and Users Across An Availability Group
What’s the deal with logins and availability groups?
I’m sure that we all, when creating a login that accesses a database...
2018-12-26 (first published: 2018-12-05)
2,302 reads
What’s the deal with logins and availability groups?
I’m sure that we all, when creating a login that accesses a database...
2018-12-26 (first published: 2018-12-05)
2,302 reads
Yesterday I posted about journaling with my goal being to track the time I spend on SQLOrlando (I’ll exclude time...
2018-12-24 (first published: 2018-12-05)
1,644 reads
Many of you (including me) wonder about it. Namely: Is it possible to move my ETL process from SSIS to...
2018-12-05
240 reads
Advent of Code 2018 – Day 2
As I explained in yesterday’s post, I’m participating in this year’s Advent of Code challenge,...
2018-12-21 (first published: 2018-12-04)
1,858 reads
Next Wednesday, Dec 12, I’ll be back in the UK with Kathi, Kendra, and Grant for SQL in the City...
2018-12-04
806 reads
The business critical tier for Azure SQL Database Managed Instance is now available. Customers needing a higher level of high...
2018-12-04
59 reads
SQL date format functions like the DateDiff SQL function and DateAdd SQL Function are oft used by DBAs but many...
2018-12-04
671 reads
Building on the work of these three fine individuals, here comes the difficult task. You have been the benefactor of some awesome help from somebody else. You even wrote...
2018-12-04
10 reads
How have you impacted somebody in the community?
It has now been 28 months since the last time I hosted a...
2018-12-04
233 reads
Watch this week’s episode on YouTube.WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005. So why...
2018-12-04
244 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