Promised Links from SQL Saturday 119 Presentations
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,126 reads
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,126 reads
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...
2011-05-27
719 reads
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem...
2011-05-26
757 reads
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,427 reads
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
691 reads
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
866 reads
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
717 reads
A week or so ago Aaron Nelson (Blog|Twitter) put out a call for help on Twitter looking for anyone that...
2011-01-20
13,580 reads
Last week Jonathan Kehayias (Blog|Twitter) used his blog to publicly call out Thomas LaRock (Blog|Twitter). I am not going to...
2011-01-11
655 reads
Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL...
2010-12-20
762 reads
By SteveHood79
When I get alerts from SQL Server I want it to do three things...
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Kevin3NF
SQL Server backups are database insurance – you don’t really appreciate them until disaster...
In my SSIS package I have a Data Flow with a XML Source with...
Hello all. Trying to measure the time in days between to dates excluding weekends....
Kind of a DML question - but specific to an AG instance running on...
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