SQL Server developers and database administrators have one last chance for a full day of free training and networking at SQL in the City 2012.
2012-11-02 (first published: 2012-10-25)
3,891 reads
Start the week in Seattle off with a free day of training on Nov 5, 2012 with SQL in the City. Grant Fritchey, Steve Jones and more will be talking SQL Server in the Pacific Northwest. Join us and debate and discuss SQL Server the Red Gate Way.
2012-10-16 (first published: 2012-09-13)
5,790 reads
A free day of training in Boston on Oct 8, 2012. Come join Grant Fritchey, Steve Jones and more to talk about SQL Server and how you can work more efficiently.
2012-09-21 (first published: 2012-08-31)
3,999 reads
A free day of training in Chicago on Oct 5, 2012. Join Grant Fritchey, Steve Jones and more to discuss, debate, ask questions, and learn about how to better run your organizations SQL Servers.
2012-09-20 (first published: 2012-08-30)
4,039 reads
The city by the bay welcomes Steve Jones, Grant Fritchey and more for a day of debate, discussion and learning about SQL Server. It's free. Just register and join us.
2012-09-19 (first published: 2012-08-29)
3,493 reads
SQL in the City the one day free SQL Server training event is back in London this July. Join fellow SQL Server professionals for 5 hours of technical presentations on key issues for SQL Server developers and DBAs delivered by top MVPs. The event also offers you the chance to network with users passionate about SQL Server and the chance to see the latest Red Gate tools and meet the developers who built them. Find out more and register today.
2012-06-04 (first published: 2012-03-09)
7,499 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...
This month’s invite is from Erik Darling, who invites you to make a video...
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