Giving Your Best
It's easy to get into a rut at work, and easy to just attempt to get some minimum amount of work done each day. Steve Jones is inspired today to think about doing more.
2009-05-19
108 reads
It's easy to get into a rut at work, and easy to just attempt to get some minimum amount of work done each day. Steve Jones is inspired today to think about doing more.
2009-05-19
108 reads
Software maintenance is often required when purchasing software packages. But do the vendors deliver value for this charge? Steve Jones has a few thoughts on the subject.
2013-11-25 (first published: 2009-05-18)
137 reads
Tools expand, some might say bloat, at an alarming rate and it's often the case that, in amongst all the clutter, the most valuable features somehow elude us.
2009-05-18
80 reads
Feeling his age a bit, Steve Jones asks you about yours in this Friday's poll. Where do you think you are in your career as a technologist?
2009-05-15
107 reads
As we develop new applications and our computers gain new capabilities, what rights do our data include? Steve Jones explores a controversy with the Amazon Kindle.
2009-05-14
74 reads
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
2009-05-13
318 reads
How can you measure someone's DBA skills? Steve Jones comments on a new technique that someone suggested to him.
2013-11-19 (first published: 2009-05-12)
793 reads
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
2009-05-11
118 reads
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
2013-12-24 (first published: 2009-05-11)
507 reads
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
2013-11-26 (first published: 2009-05-08)
496 reads
This month’s invite is from Erik Darling, who invites you to make a video...
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
Comments posted to this topic are about the item Part-Time DBAs
Comments posted to this topic are about the item The Long String
Comments posted to this topic are about the item Level 5 of the Stairway...
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