SQL Server 2011 CTP3 (Denali) Released
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
1,370 reads
Brian K. McDonald
2011 SQL Rally Evaluations - Reporting Services Boot Camp
I wrote this early in June, but lost it in my blog pile again and just found it…
First and foremost,...
2011-07-11
410 reads
FileLinking Using SSIS
A user recently asked how to generate a file link using SSIS so that it could be inserted into the...
2011-07-01
1,010 reads
Awesome Reports Webinar Tomorrow at 11AM
Here at Pragmatic Works, we enjoy putting on a show for the community. As can be seen by Training on...
2011-06-30
1,407 reads
Watermarking
Someone asked me a long time ago how to do watermarking in Reporting Services and I meant to write a...
2011-06-30
2,785 reads
Who Am I
If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these...
2011-06-25
687 reads
PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released
I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...
2011-06-02
674 reads
SQL Saturday 74 Is Here! Register Now! Show Up Tomorrow!
Tomorrow (4/30/2011) is SQL Saturday #74 in Jacksonville Florida and once again, I am giving a talk with other well...
2011-04-29
1,474 reads
Awesome Software/Training Deal!
Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps...
2011-04-21
457 reads
SQL Rally Still Only $349 Until 4/30/2011
If you're on twitter, follow the #SQLPass hash tag and @briankmcdonald for up-to-date information.
You may have heard that PASS is...
2011-04-18
338 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers