Looking to attend a security summit in cooler weather that will benefit students? Applachian State holds an annual cybersecurity summit and this year it is scheduled for September 8,...
2023-08-17
27 reads
In the last post I hadn’t found the breakdown of questions for the exam. The Open Group does publish the TOGAF 9 Certified Study Guide (link goes to the...
2023-03-06
46 reads
When I teach the ISACA Certified Information Systems Auditor (CISA) course, one of the things I walk candidates through is how the test is structured and how much each...
2023-03-06 (first published: 2023-02-28)
275 reads
The Open Group Architecture Framework (TOGAF) is one of the most well-known architectural frameworks in our industry. TOGAF is a framework that helps organizations implement enterprise architecture as a...
2023-02-27
107 reads
I was reading Seth Godin today and he makes this claim: If 2% of a population takes coordinated action, it makes a difference. If 5% do, it can change...
2022-06-03 (first published: 2022-05-12)
293 reads
In IT, we have to read a lot. For instance, understanding how to set something in Azure or Okta or vSphere may mean we are consuming 5 or more...
2022-03-18 (first published: 2022-03-07)
305 reads
In IT, commonality is an accelerator. When I say commonality, I mean commonality of: Components, like libraries Object models Interface definitions Tools Let me give you an example. Imagine...
2022-03-02
153 reads
When I was younger, I always wanted the perfect solution to an IT problem. I remember getting into argument after argument trying to insist upon the perfect configuration, setup,...
2022-01-21 (first published: 2022-01-10)
380 reads
Tomorrow, July 13, 2021, I will be giving a webinar on data security and compliance. Here’s the sign-up link: SQL Server Data Security and Compliance sign-up (free, but registration...
2021-07-12
37 reads
Tomorrow, April 28, 2021, 12 PM EDT, I will be talking about meeting security benchmarks and compliance requirements with Microsoft SQL Server. Here is the registration link: Geek Sync...
2021-04-27
36 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