Carlos Robles

Carlos Robles is Microsoft Data Platform MVP also a very experienced multi platform DBA (MySQL, Oracle, SQL Server, SQL Azure) with over 10 years of experience in the database field.

He has worked in database support as a primary consultant and DBA manager for large national and international companies in the healthcare, finance and insurance, retail, food and energy industries.

International speaker, author, blogger, mentor, Guatemala SQL User group leader. If you don’t find him talking about geek stuff with his friends on twitter, it is very likely that he will be having a great time with his wife and daughter in the beautiful outdoors of Colorado.
  • Tagline: Just another witchcraft and wizardry site and DBA tips,
  • Interests: SQL Server, Linux, Databases
  • Blog: http://dbamastery.com

All authors

Blog Post

Availability group error message 19405

Availability groups (AG’s) is one of my favorite features of SQL Server, despite some DBA’s catalogue them as “too complex” to implement, configure, manage  and maintain … I just...

2019-05-13 (first published: )

750 reads

All authors

Blogs

Query to Email….Well Formatted Email

By

When I get alerts from SQL Server I want it to do three things...

Announcements from the Microsoft Fabric Community Conference

By

A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...

Why Your SQL Server Backups Aren’t Enough

By

SQL Server backups are database insurance – you don’t really appreciate them until disaster...

Read the latest Blogs

Forums

Runnng SSIS package from SQL Agent Job with Excel manipulation

By DanH1231

Good Day SQL Guru's, I have a problem I am hoping someone can give...

How to backup a specific table to an external folder?

By water490

Hi everyone My SS db has a bunch of tables that I don't use. ...

Manual AG Alter problems

By Brandie Tarvin

All, We have an environment where connecting to servers in SSMS requires an extra...

Visit the forum

Question of the Day

The Long String

I have a table (dbo.beer) with this data:

BeerIDBeerNamebrewerbeerdescription
-------------------------------------------------------------------------------------------------------------------------------------
1BecksInterbrewBeck'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
2Fat TireNew BelgiumToasty malt, gentle sweetness, flash of fresh hop bitterness. The malt and hops are perfectly balanced.
3Mac n JacksMac & Jack's BreweryThis 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.
4Alaskan AmberAlaskan BrewingAlaskan 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.
8KirinKirin BrewingKirin 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.
Here is the DDL For the table: 
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]
GO
I run this code: 
SET TEXTSIZE 20;
SELECT
  b2.BeerName
, b2.beerdescription
FROM dbo.Beer AS b2;
GO
What is returned?  

See possible answers

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy