PowerShell ISE Crashes
Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh version, the more efficiently you will be able to...
2018-11-19
30 reads
PowerShell ISE Crashes
Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh...
2018-11-19
585 reads
Happy Thanksgiving Readers!
I wanted to take a moment and wish an easy week in the office and a Happy Thanksgiving to everyone!
The...
2018-11-19
242 reads
Fun with PowerShell: I made a game
So we got to playing around with PowerShell last week – one son is making a game hack, and the other...
2018-11-19
232 reads
Query Store and Plan Cache Plans Compared
Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...
2018-12-03 (first published: 2018-11-19)
2,026 reads
SQL Live Conference – December 2-7 in Orlando
I am proud to contribute to this year’s Live360 conference, to be held in Orlando Florida at the Royal Pacific...
2018-11-19
178 reads
Running SQL Server with Docker on the Mac
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-12-03 (first published: 2018-11-19)
2,709 reads
Dealing with multiple AD accounts
To help promote the seperation of duties one of the things my company has done is to divide our permissions...
2018-11-29 (first published: 2018-11-19)
2,415 reads
What is the SQL Server Trustworthy database property?
I ran across an interesting property set in a SQL Server database for a customer, the property is called “Trustworthy”. ...
2018-11-29 (first published: 2018-11-19)
26,787 reads
2018-11-19
19 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
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