Level 5 of the Stairway to Synapse Analytics: create and use Delta Lake - Part 2
This next article in the Stairway to Synapse looks at Delta tables and processing streaming data.
Killing a SPID and Checking Rollback progress in SQL Server
From time to time, I encounter blocking situations where I end up issuing a SQL KILL command against the blocking SPID. When I run sp_who2, I can see the killed SPID is in a ROLLBACK state. Is there any way I can get an idea of how long the rollback for the SPID will take?
Stairway to ColumnStore Indexes Level 7: Optimizing Nonclustered Columnstore Indexes
In this level, we will focus on optimization techniques to apply while building the nonclustered columnstore index, which is available in all versions of SQL Server from 2012 up.
Create Raw Zone Tables using Generative AI: The Fabric Modern Data Platform
In this first article on the Fabric Modern Data Platform, we look at how to use Generative AI to build tables.
More Linux than Windows
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
The Changing Nature of Data
The way we look at data is changing, especially when data privacy and protection is considered. Today Steve has some thoughts on address data and the implications for cities as well as databases.
Understanding UNION and UNION ALL in SQL Server
A short look at the differences in UNION and UNION ALL in a SELECT query.
Upgrading Your OS
Windows 7 support is ending, but Microsoft doesn't have a good plan for home users. Steve notes that the OS upgrade treadmill ought to come to an end soon.
Using Feature Flags
Feature flags are being used in modern software development. Steve thinks these should also be a staple of database changes.
Blogs
T-SQL Tuesday #185: Video
This month’s invite is from Erik Darling, who invites you to make a video...
T-SQL Tuesday #185–Being a Video Star
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
Building Resilience: Leadership Insights from Sports
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
Forums
Part-Time DBAs
Comments posted to this topic are about the item Part-Time DBAs
The Long String
Comments posted to this topic are about the item The Long String
Level 5 of the Stairway to Synapse Analytics: create and use Delta Lake - Part 2
Comments posted to this topic are about the item Level 5 of the Stairway...
Question of the Day
The Long String
I have a table (dbo.beer) with this data:
| BeerID | BeerName | brewer | beerdescription |
| ----------- | -------------------- | -------------------- | ---------------------------------------------------------------------------------- |
| 1 | Becks | Interbrew | Beck's is a German-style pilsner beer known for its golden color, full-bodied taste, and a crisp, clean finish with floral and fruity hop aromas, brewed according to the German purity law |
| 2 | Fat Tire | New Belgium | Toasty malt, gentle sweetness, flash of fresh hop bitterness. The malt and hops are perfectly balanced. |
| 3 | Mac n Jacks | Mac & Jack's Brewery | This beer erupts with a floral, hoppy taste, followed by a well rounded malty middle, finishing with a nicely organic hop flavor. Locally sourced two row grain and a blend of specialty malts give our amber its rich taste. |
| 4 | Alaskan Amber | Alaskan Brewing | Alaskan Brewing Amber Ale is an "alt" style beer, meaning it's fermented slowly and at colder temperatures, resulting in a well-balanced, richly malty, and long-lasting flavor profile with a clean, pleasing aftertaste. |
| 8 | Kirin | Kirin Brewing | Kirin Ichiban is a Lager-type beer, which means it is fermented at low temperatures and offers a light and refreshing texture with a smooth and balanced flavor. |
CREATE TABLE [dbo].[Beer] ( [BeerID] [int] NOT NULL IDENTITY(1, 1), [BeerName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [brewer] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [beerdescription] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GOI run this code:
SET TEXTSIZE 20; SELECT b2.BeerName , b2.beerdescription FROM dbo.Beer AS b2; GOWhat is returned? See possible answers