The Heart of DevOps Webinar
One of the things that I think about DevOps is that it’s really hard to focus on the hard things...
2019-01-23
262 reads
State vs Migration for Database Source Control – decide based on one question
One controversial topic in database development is how to properly store and deploy database changes. This is generally described as choosing between two options, which are approximately as easy...
2019-01-23
36 reads
How does the buffer pool work?
Today we’ll begin taking a look at the buffer pool in SQL Server and how it’s normally used. Before we...
2019-01-23
217 reads
What’s the one thing you must do to win the trust of customers?
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit from the convenience of booking holidays and paying bills...
2019-01-23
55 reads
What’s the one thing you must do to win the trust of customers?
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit...
2019-01-23
231 reads
All Day, Training Day at SQLBits
It’s a somewhat late addition, but I have an all-day Training Day at SQLBits. It takes place on Thursday, February...
2019-01-23
247 reads
Rotating Expired SQL Server TDE Certificates
In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using...
2019-02-08 (first published: 2019-01-23)
1,847 reads
SQL Server Always On Read Only Routing Lists
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,704 reads
What’s a differential backup?
Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently...
2019-02-12 (first published: 2019-01-23)
2,172 reads
Scheduling things to Run in SQL Server
A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule...
2019-02-08 (first published: 2019-01-23)
2,760 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