For this month’s T-SQL Tuesday Steve Jones asks us to talk about our experiences with Triggers:
https://voiceofthedba.com/2018/09/03/t-sql-tuesday-106-trigger-headaches-or-happiness/
In my post I’m going...
2018-09-12
272 reads
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-09-25 (first published: 2018-09-12)
2,115 reads
This post is part of #tsql2sday event 🙂
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...
2018-09-11
24 reads
Thanks to the full room of SQL enthusiasts who joined me today for the September Houston SQL Server UG Group Meeting! What a great crowd that enjoyed the hospitality...
2018-09-11
16 reads
Hello! The webinar I was going to give this coming Thursday with MSSQLTips.com has been postponed. When we have a...
2018-09-11
242 reads
Azure VMs
Usually you should convey to developers and testers to shut down the VMs manually when they are not using non production virtual machines. Also there some ways to...
2018-09-11
44 reads
Are you looking to do a major update to your data warehouse or looking to modernize? Many technologies have come...
2018-09-27 (first published: 2018-09-11)
3,079 reads
Introduction
In this blog post, I would like to explain what a columnstore segment elimination is and how to load data...
2018-09-11
202 reads
This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...
2018-09-11
560 reads
I love New York. Every time I get to travel to the city, I get excited and look forward to...
2018-09-11
320 reads
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
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...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item 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