Blogging: Controlling SPAM in Orchard CMS with OpenCaptcha
When I started blogging last year, my first major decision was either to host my own site somewhere using a...
2012-02-16
1,822 reads
Blog Posts
Creating Your Own Certificates
Did you know that you don’t need to go to Digicert or Thawte, or any other company to get a...
2012-02-16
1,294 reads
Error 14269 on SQL Server 2000
As I noted in my last post, I am currently on a project to review some older servers (SQL 2000...
2012-02-16
723 reads
Execute Multiple 2008/2005 SSIS Packages with a T-SQL
If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this...
2012-02-16
882 reads
February #Meme15 – LinkedIn
It’s the afternoon of the 16th, and time to write my #meme15 post. Remember, these are due on or around...
2012-02-16
615 reads
Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly
SSIS Expressions
Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables,...
2012-02-16 (first published: 2012-02-13)
4,284 reads
PowerPivot and Market Research
This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...
2012-02-16
609 reads
Spruced up query_io_reader.rb
I built a small ruby program a while back to help with two things:
Quickly identify what tables have the highest IO in a particular query
Learn a new language (Ruby)
The...
2012-02-16
17 reads
Spruced up query_io_reader.rb
I built a small ruby program a while back to help with two things:
Quickly identify what tables have the highest...
2012-02-16
576 reads
Spruced up query_io_reader.rb
I built a small ruby program a while back to help with two things:
1. Quickly identify what tables have the highest IO in a particular
...
2012-02-16
18 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers