Renaming a local windows login after SQL Server Computer Name Change
I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server...
2018-01-25 (first published: 2018-01-15)
7,292 reads
SQL Saturday Nashville 2018
I decided to go to the SQL Saturday at Nashville this year to get some good learning and networking in...
2018-01-15
450 reads
Steps to Configure SQL Server to Listen On A Specific TCP Port
Management of the database is very much essential in today’s date and for doing this, there is a need to...
2018-01-15
3,291 reads
Time to find a new place to live
Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the...
2018-01-15
278 reads
Linguistics Crisis In Microsoft Technology
With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product...
2018-01-24 (first published: 2018-01-15)
1,730 reads
Object Explorer Drag-N-Drop (Day 14)
Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can...
2018-01-14
320 reads
The SSMS Super Clipboard (Day 13)
We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it...
2018-01-13
406 reads
tsqlt Tests for Advent of Code 2017 Day 2
This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-13
890 reads
When it’s cold outside, perhaps Power BI heat maps can warm you up
(2018-Jan-13) You never know how the weather will behave itself, especially when the temperature gets dramatically changed from +10 to -10...
2018-01-23 (first published: 2018-01-13)
1,851 reads
Happy New Year… Late:)
Yeah I know its new year and i am back from quite some time. during these days i was learning...
2018-01-13
321 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
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