SQL Server 2011 (Denali) CTP3 Released!
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
954 reads
BrianKMcDonald
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
424 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,023 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,422 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,797 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
691 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
678 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,484 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
469 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
350 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers