Managing SQL Prompt Code Analysis Rules
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2018-02-08 (first published: 2018-01-29)
1,619 reads
No Default CONTEXT_INFO()
I was doing a little testing of Row-Level Security (RLS) for the stairway, and one of the ways that some...
2018-01-29
516 reads
Presenting with SSMS (Day 29)
If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are...
2018-01-29
881 reads
SQL Undercover Podcast – Feb 2018
The first SQL Undercover podcast where Adrian introduces the Undercover Inspector, David releases sp_restorescript 1.2 along with a bit of...
2018-01-29
458 reads
Power BI Data Security – Sharing
Microsoft recently added more sharing capabilities that may change my view on sharing within the enterprise. As with all things...
2018-02-06 (first published: 2018-01-29)
1,655 reads
Youtube Channel Update
Hello,
I just wanted to take a moment to promote the work I’ve been doing with the YouTube Channel.
I’ve published four...
2018-01-29
295 reads
Deleting Azure SQL Database VNETs
This is quite a new feature (currently in preview) but an important one where we now have the ability to...
2018-02-07 (first published: 2018-01-29)
1,043 reads
How To: Install SQL Server on an Azure VM
Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is...
2018-01-29
634 reads
Managing SQL Server Transaction Log File
Overview
In our previous section we have discussed how to create an audit trigger in SQL Server and how it helps...
2018-01-29
1,764 reads
Speaking at PASS Summit and why you need to think about submitting….
This post is about the honor and experience of speaking at PASS Summit not once (2016) but twice (2017).
I recently...
2018-01-29
399 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