Review of Review of SQL Server 2000 Administrators' Companion
Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.
2004-03-26
4,134 reads
Administration
2004-03-24
1,796 reads
2004-03-23
1,636 reads
2004-03-18
1,970 reads
2004-03-17
1,829 reads
Dump SQL Permissions
We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.
2004-03-17
18,595 reads
2004-03-02
1,993 reads
2004-03-01
1,581 reads
Monitoring Failed Job Steps
New Author! We've run a couple articles on similar topics, this one takes a slightly different approach. It's a short article and has two scripts included.
2004-03-01
9,093 reads
Review of Lumigent Entegra
We've been trying to catch up on reviews lately, Hai was kind enough to give Entegra a try and report back on it. The basic concept is that it lets you do extensive auditing without having to add triggers. If you're trying to find an auditing solution, this is worth considering.
2004-02-27
6,047 reads
Blogs
Query to Email….Well Formatted Email
By SteveHood79
When I get alerts from SQL Server I want it to do three things...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
T-SQL Tuesday #185: Video
This month’s invite is from Erik Darling, who invites you to make a video...
Forums
SSIS XML Source Columns Don't Match XML/XSD
In my SSIS package I have a Data Flow with a XML Source with...
Get days between 2 dates excluding weekends.
Hello all. Trying to measure the time in days between to dates excluding weekends....
Running DML on a Primary AG Instance
Kind of a DML question - but specific to an AG instance running on...
Question of the Day
The Long String
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