Change Tracking Inserts Require SELECT Permission
I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions...
2018-12-13
213 reads
Things I Learned at Summit v20 - Visual Studio Code
Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this post we'll...
2018-12-13
265 reads
Setting up SQL Server replication in containers
Last week I saw a thread on twitter about how to get replication setup for SQL Server running in a...
2018-12-13
864 reads
The Default Frame for Window Functions
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-13
913 reads
Naming Convention Hall of Shame
Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation,...
2018-12-13
224 reads
The Eleven Days of Festivus 2018
It’s that time again! My Eleven Days of Festivus blogging extravaganza is now in its third year, and I’m happy...
2018-12-13
180 reads
SSMS – Docker SQL Server
once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server...
2018-12-13
257 reads
Some differences with SQL Server when running on AWS RDS
If you plan on using Amazon Web Services (AWS) to host your SQL Server based applications in the cloud, then...
2018-12-12
913 reads
Some databases may show a NULL collation in the sys.databases DMV
While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the...
2018-12-12
242 reads
Bulk insert and an identity column
TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file...
2018-12-12
1,118 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