More Suggestions for SQLSaturday Admin Tools
I just finished the draft schedule for SQLSaturday #151 in Orlando and wanted to write some notes about the process....
2012-08-08
466 reads
Blog Posts
SQLSaturday #160, Kalamazoo
Date: September 22, 2012
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-08-08
600 reads
SSIS: Transfer SQL Server Object using SMO
we often face a situation to move SQL server object beween servers or databases, when you have constant table list...
2012-08-08
5,582 reads
Startup Jobs
Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...
2012-08-08 (first published: 2012-08-02)
3,341 reads
Visio 2010 Forward Engineer Add-in
Somehow I missed this gem that’s been around for quite a while so I thought I would share it in...
2012-08-08
2,406 reads
Book Review: On Writing A Memoir of the Craft by Stephen King
I just finished this book. Literally. Sitting on an airplane in route from Orlando to Charlotte NC. I got up...
2012-08-07
1,019 reads
Can I still buy per socket licenses for installing SQL2008 R2 ?
Many times I have seen this question coming from users - Can I still buy per socket licenses for installing SQL2008...
2012-08-07
741 reads
Colorado SQL - August 2012
This month Kevin Kline will be presenting "End to End Troubleshooting" at the Boulder, Colorado Springs, and Denver SQL Meetings
Summary:...
2012-08-07
643 reads
Creating a DDL Trigger
One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to...
2012-08-07 (first published: 2012-07-31)
2,782 reads
PASS Update #1 - January 2012 Recap
When I ran for the PASS Board of Directors last year I committed to providing a monthly update on PASS...
2012-08-07
966 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