Webinar next week on Database DevOps
Next week is my webinar on why the database is the heart of DevOps. You can still register today to...
2019-01-30
756 reads
Understanding and working with NULL in SQL Server
Graphic representation of the difference between 0 and NULL
Image taken from 9gag.comAccording to database theory, a good RDBMS must implement...
2019-01-30
1,471 reads
Speaking at SQLBits in March 2019
I have been selected to speak for a second time at SQLBits, which is being hosted in Manchester UK this...
2019-01-30
248 reads
2019-01-30
246 reads
Azure Advisor
Azure offers a lot of value-added services included with the price of what you pay . One of the things really,...
2019-01-30
324 reads
Azure Kubernetes Service Error – LoadBalancer type service external IP stays pending
Last week I was working on my Azure Kubernetes Service cluster when I ran into a rather odd issue. I’d...
2019-01-30
372 reads
Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. There is insufficient system memory in resource pool ‘internal’ to run this query.
Today my colleague had issue that SQL server...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-01-30
1,672 reads
Backing Up and Restoring Your On-Premise Databases To and From the Cloud
I’ve been meaning to start a series of posts on “Dipping your toes into the cloud” for a while now,...
2019-01-30
327 reads
Midlands PASS Meeting – February 5, 2019
Midlands PASS (Columbia, SC) will be hosting Shannon Lowder on February 5, 2019, from 5:30-8:00 PM. He will be speaking...
2019-01-29
152 reads
What a Software Evangelist Does – and Where the Job is Going (Dear SQL DBA Episode 67)
I’ve been working as an Evangelist at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software...
2019-01-29
36 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