CROSS JOIN for fun
My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts...
2018-02-17
1,120 reads
dbatools and Orphaned Users
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-02-16
807 reads
Black Panther is Going to Change Superhero Movies
Hello Dear Reader! Sorry it has been so long, I've been blogging over on the MSDN site about technology. I'll have a Twitter Sentiment update for Black Panther later...
2018-02-16
17 reads
Black Panther is Going to Change Superhero Movies
Hello Dear Reader! Sorry it has been so long, I've been blogging over on the MSDN site about technology. I'll...
2018-02-16
420 reads
Backup & Restore Script with a Move
Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life...
2018-03-01 (first published: 2018-02-16)
2,358 reads
TDE and backup compression – still not working?
Until SQL 2016 if you used TDE (Transparent Data Encryption) you couldn’t use backup compression.
In 2016 Microsoft changed this, but...
2018-03-01 (first published: 2018-02-16)
2,405 reads
A Guide for Decrypting SQL Server Database Objects
Overview
The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from...
2018-02-28 (first published: 2018-02-16)
4,686 reads
"What's New in SQL 2017?" at the Baton Rouge SQL Server UG meeting
We had a great joint meeting tonight of the Baton Rouge SQL and .NET User Groups at the Louisiana Tech...
2018-02-15
558 reads
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level
Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...
2018-02-28 (first published: 2018-02-15)
2,668 reads
Enabling Guest in a Database–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-02-15
1,415 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