A month of SSMS tips and tricks
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-26
713 reads
Working with Comments (Day 26)
We all know that we should liberally document our code with comments, so that others (and even yourself) will know...
2018-01-26
397 reads
Javascript Postback Download via Powershell
Recently, one of my clients had a need to automatically download a file from a public facing state government website. ...
2018-01-26
135 reads
Javascript Postback Download via Powershell
Recently, one of my clients had a need to automatically download a file from a public facing state government website. ...
2018-01-26
1,164 reads
Encrypting an existing database with TDE
As mentioned previously, the process of setting up TDE (Setting up Transparent Data Encryption (TDE)) is the same whether you’ve...
2018-01-26
1,216 reads
Setting up Transparent Data Encryption (TDE)
You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to...
2018-01-26
2,705 reads
What is Transparent Data Encryption?
Transparent Data Encryption (TDE) was introduced in SQL 2008 as a way of protecting “at rest” data. It continues to...
2018-02-07 (first published: 2018-01-26)
2,205 reads
Friday Reading 2018-01-26
It’s moving weekend! Hopefully two hard days and then I’ll be all settled in my new place. Cannot wait.
Inbetween packing...
2018-01-26
262 reads
Information Measurement with SQL Server, Part 2.5: Mutual, Lautum and Shared Information
By Steve Bolton
…………The sample T-SQL I posted in the last article wasn’t as difficult as it looked, considering that it...
2018-02-06 (first published: 2018-01-25)
1,183 reads
Guest Post at Pure Storage – VVols and SQL Server are a Game Changer
I’m thrilled to have contributed a blog post on how SQL Servers, VVols, and Pure Storage’s unique implementation of VVols...
2018-01-25
367 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