Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool to get into, write queries, do some monitoring, tuning,...
2018-06-28
795 reads
Power BI Custom Visuals Class (Module 109 – as Timeline)
In this module you will learn how to use the as Timeline visual. The as Timeline is a Gantt chart...
2018-07-03 (first published: 2018-06-28)
2,878 reads
Tools to connect to a SQL database
Today I'm getting back to basics, whether you are new or veteran with the database engine you need a tool...
2018-06-27
1,740 reads
Update your production servers and stop making excuses about it
Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am...
2018-06-27
379 reads
SQL Puzzle – FizzBuzz3d
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case...
2018-07-04 (first published: 2018-06-27)
2,178 reads
Alter Multiple Databases at Once
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2018-07-03 (first published: 2018-06-26)
2,528 reads
Login Failed – Token-based server access validation failed for SQL Server
Login failures are a common item to troubleshoot with SQL Server. Out of all of the possible log failure reasons...
2018-06-26
211 reads
Query Store Error State
We recently discovered some of our databases in an Error State for SQL Server. Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup. They...
2018-06-26
10 reads
Query Store Error State
We recently discovered some of our databases in an Error State for SQL Server. Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup. They...
2018-06-26
11 reads
Query Store Error State
We recently discovered some of our databases in an Error State for SQL Server. Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup. They...
2018-06-26
14 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