Domain Independent Cluster and Availability Group
What is a Domain Independent Cluster? Did you know that you can have a Windows cluster that is a domain independent cluster and run a SQL Server Availability Group...
2018-07-05
30 reads
Domain Independent Cluster and Availability Group
What is a Domain Independent Cluster? Did you know that you can have a Windows cluster that is a domain...
2018-07-05
545 reads
SQL Server Management Studio Tips & Tricks From Dr Greg Low
It’s been a bit slow in the US this week due to the American 4th of July holiday, but it’s...
2018-07-10 (first published: 2018-07-05)
3,483 reads
The Right to Be Erased is Coming to California, Along with Other Privacy Rights
In the last year, developers and DBAs have heard a lot about the General Data Protection Regulation (GDPR) law passed by the European Union. These regulations not only impact...
2018-07-05
20 reads
Testing BackBlaze Restores
The most important thing for a data guy is having a way to restore data. If security, performance, etc. are...
2018-07-13 (first published: 2018-07-05)
2,326 reads
Why Aren’t You Using SSMS 17?
Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server...
2018-07-12 (first published: 2018-07-05)
4,774 reads
Contained Database – No more need for Server Level Logins
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained...
2018-07-11 (first published: 2018-07-05)
2,935 reads
Community recognition
On the first day of January 2017, I was honoured to receive an email naming me as a Microsoft MVP...
2018-07-04
320 reads
Updating VSTS to SQL Change Automation
We (Redgate) released SQL Change Automation a few weeks back. This is the first stage to implementing a combined toolset...
2018-07-04
1,009 reads
Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,767 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