SSRS report subscription: Fire Event from SSIS package
My previous two posts about SSRS reports being deployed to a SharePoint site along with their subscription didn't stop me...
2014-07-29 (first published: 2014-07-22)
14,507 reads
Make an SSIS package Delay or Wait for Data
Packages can be scheduled to run at a time when you expect data to be in a database. Instead of...
2014-07-30 (first published: 2014-07-21)
12,881 reads
Tampa Code Camp Revivial
If you were to look around Florida at the various cities technology based User Groups, and their accompanying local conferences you...
2014-07-21
750 reads
Rename SharePoint Central Administration Database
SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that...
2014-07-21
1,449 reads
Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of Service pack setup. Informatory details only. Step...
2014-07-21
17 reads
Powershell Tips–Showwindow
Looking for help is a pain in Powershell. I type something like
help get-process
execute this and I’m scrolling up and down....
2014-07-21
1,164 reads
July 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist. Even though it hasn’t been...
2014-07-21
734 reads
Null Values in SQL Server
Walk & Talk #001 – Unknown or Null Values
Ride with us in this video as we head to Richmond, Virginia to present...
2014-07-21
621 reads
Last Weeks Top “Reading” Links #93
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-07-21
991 reads
Victims of Success
I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how...
2014-07-21
673 reads
Blogs
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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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