Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
793 reads
Weekly reading #28
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-10
29 reads
Weekly reading #28
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-10
74 reads
How to Reduce the Risk of SQL Database Corruption
Introduction:
Today we are going to learn how to prevent SQL database corruption. Let’s start with some facts about how database corruption can occur actually. The SQL database corruption could...
2019-10-09
375 reads
I’m Speaking at Microsoft Ignite 2019
I’m happy to be speaking at Microsoft Ignite this year. I have an unconference session and a regular session, both focused on accessibility in the Power Platform. The regular...
2019-10-09
53 reads
Speaker at SQL Saturday# 908 – Denver 2019
I’m very happy to announce that this will be my second time participating as speaker at the SQL Saturday# 908 in Denver! Here are the details of the session...
2019-10-09
64 reads
Just Getting Specific Files in PoSh–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Just a quick one today, but a tip...
2019-10-18 (first published: 2019-10-09)
245 reads
Leveraging WHILE LOOP
WHILE LOOP can be used for batch processing and can be helpful if you are dealing with huge data processing. Recently I did an analytics project where I had...
2019-10-09
40 reads
Using indexed views? Don’t forget this important tip.
Today after fighting with designing a view that let me create a clustered index on it (indexed views — also known as materialized views — are awesome in the right context!),...
2019-10-09
60 reads
SQL Server Virtual Machines in Azure
Let’s create a virtual machine in Azure that has an imaged copy of SQL Server on it. I want to do this because down the line I want to...
2019-10-09
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