Does Your Company Have a SQL Server DR Plan?
This past month I ran a poll asking this question: “Does your company have a formal, tested, disaster recovery plan...
2010-06-30
1,551 reads
This past month I ran a poll asking this question: “Does your company have a formal, tested, disaster recovery plan...
2010-06-30
1,551 reads
This is my third in a series of checklists that I am putting together for a new book designed for...
2010-06-29
2,937 reads
As a part of a new book project, I am putting together a series of checklists that DBAs can use...
2010-06-23
1,212 reads
Starting today, you can vote for the 2010 Exceptional DBA of the Year. All of the nominations have been reviewed...
2010-06-23
465 reads
I’m in the process of putting together a SQL Server hardware inventory/audit checklist for an upcoming book project. The purpose...
2010-06-21
2,593 reads
SQLBits—The 7 Wonders of SQL Conference—will be held in York, England, September 30 through October 2, 2010. SQLBits is the...
2010-06-21
434 reads
Recently, Buck Woody challenged myself, Paul Randal, and Brent Ozar to write a blog post on “How I Travel”. I...
2010-06-18
2,331 reads
I’m thinking about setting up a SQL Server test box in my home office for doing some extensive, real-world SQL...
2010-06-17
414 reads
While I was at TechEd last week, I got a 50% off Microsoft Certification test voucher that expires on June...
2010-06-15
1,492 reads
TechEd is finally over, and I have been overwhelmed by attending 20 different sessions over the last four days. As...
2010-06-12
436 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...
All, We have an environment where connecting to servers in SSMS requires an extra...
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....
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