T-SQL Tuesday #005: Monitoring Reports with SSRS
This post is a T-SQL Tuesday Entry, hosted this week by Aaron Nelson on the topic of “Reporting”. (It got...
2010-04-13
1,058 reads
Seth Phelabaum
Bug: Reporting Services 2K8, SSMS and Windows 7
[Edit] Since writing this, I've realized that the true reason behind this was that my account was not a member...
2010-04-12
1,128 reads
SCSUG April Meeting Follow-up
The April meeting went well. I had hoped that the prospect of a couple of Technet subscriptions would increase attendance...
2010-04-12
402 reads
2010 Goals – First Quarter Review
Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.
Community...
2010-04-07
482 reads
Date Manipulation with DATEADD/DATEDIFF
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
37,524 reads
SCSUG April Meeting Reminder
A reminder to anyone in the Brevard County Florida area:
The SCSUG monthly meeting is at 6:30 on Thursday, April...
2010-04-06
295 reads
A T-SQL Holiday Message
Totally pointless, but fun. Run it to decode the message.
DECLARE @Message varchar(20)
SET @Message = '????????????'
DECLARE @Decode Table(
DSeq tinyint,
DKey smallint
)
INSERT INTO...
2010-04-03
722 reads
The Best vs. The Good Enough
When you ask a question on the forums, you'll often get responses that certain ways of doing things are inefficient...
2010-04-02
465 reads
Blog Topics - Where do you draw the Line?
I started blogging a few months ago and since I started writing my own blog, I've been a much bigger...
2010-04-01
502 reads
DBCC INPUTBUFFER vs fn_get_sql
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog...
2010-03-28
8,779 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