Two Weeks to #sqlinthecity Streamed
It’s just two weeks until the SQL in the City Streamed starts up again in 2019. I’m ready to travel...
2019-03-20
448 reads
Delete activity in Azure Data Factory - Cleaning up your data files
(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that...
2019-04-09 (first published: 2019-03-20)
4,577 reads
Generating a Jupyter Notebook for Glenn Berry’s Diagnostic Queries with PowerShell
The March release of Azure Data Studio now supports Jupyter Notebooks with SQL kernels. This is a very interesting feature...
2019-04-08 (first published: 2019-03-20)
702 reads
The free SQL to Excel Export tool
Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....
2019-03-20
686 reads
Sizing your Azure SQL Database
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
676 reads
Women in Tech Talk Tech
March is Women’s History Month, to celebrate the PASS Women in Technology Virtual Group (@PASS_WIT) held a webcast featuring prominent...
2019-04-09 (first published: 2019-03-20)
1,049 reads
SheLeadsTech Community
ISACA, which is primarily an Audit and Compliance professional organization, has recently started an initiative with the following purpose:
ISACA’s SheLeadsTech...
2019-03-20
341 reads
Mixed feelings over the new truncation error
As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error....
2019-04-05 (first published: 2019-03-20)
2,052 reads
The Curiously Large CASE Statement
A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to "transform" data per business rules to help better understand the data...
2019-03-20
23 reads
The Curiously Large CASE Statement
A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to “transform” data...
2019-04-08 (first published: 2019-03-20)
4,069 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