Upcoming SQL Saturday Precon Sessions (Update!!!!)
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
926 reads
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
926 reads
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
8,993 reads
Recently, I was working with a customer designing Power BI reports and dashboards. Everything was going great until she asked...
2016-01-25
2,683 reads
So two new exciting capabilities were announced recently in Power BI. One involved Excel and the other SSRS, but they...
2015-12-17 (first published: 2015-12-14)
1,843 reads
The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...
2015-12-03
900 reads
I was recently asked by a customer to help them do some Text analysis of course evaluation data. They wanted...
2015-12-09 (first published: 2015-12-02)
4,204 reads
I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturdayfor the first time...
2015-07-24 (first published: 2015-07-20)
2,098 reads
After a few years away, the Baton Rouge SQL Saturday group has finally allowed me back at their annual event...
2015-07-15
1,340 reads
Join me for a full day of Power BI in Baton Rouge, LA and Downers Grove, IL, where I will teach...
2015-04-13
1,395 reads
2015-04-10
1,107 reads
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
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...
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....
Kind of a DML question - but specific to an AG instance running on...
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