See You at SQL Saturday #46 - Raleigh
EDIT: Updated to include a picture of me.
I'm headed up this weekend to speak at SQL Saturday #46 - Raleigh. This...
2010-09-16
827 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Slides and Files: A PowerShell Primer
Here are the slides and scripts from last night's presentation at Midlands PASS Chapter. The presentation was intended to introduce...
2010-09-15
1,029 reads
Task Manager - Don't Believe the System Idle Process Percentage
This morning my laptop went to a crawl. I looked, and sure enough, there was an AntiVirus scan running. Argh!...
2010-09-14
3,571 reads
SQL Saturday #48 - Columbia, SC - Recommended Hotels
If you're thinking about attending SQL Saturday #48 - Columbia, SC and need a hotel room, our crew has done the...
2010-09-06
929 reads
SQL Saturday #48 - Columbia, SC Schedule Posted
The sessions have been selected and we have posted the schedule for SQL Saturday #48 - Columbia, SC. A huge thank...
2010-09-06
626 reads
Thoughts about the PASS BoD Nomination Process
I know I was one of the more vocal ones these past two years when the set of nominees were...
2010-09-06
883 reads
Free SQL Server Training for the Week of September 6, 2010
Tuesday
PASS Performance Virtual Chapter - Introduction to SQL Server Statistics - Andy Warren
Wednesday
Idera - Building a Data Mart with Integration Services - Stacia Misner
SQL...
2010-09-03
908 reads
Re-learning how to think
Cross-posted from The Goal Keeping DBA:
Re-learning how to think is always a difficult process. My oldest son is starting the...
2010-09-03
1,504 reads
Restricting SecurityAdmin on SQL Server 2005/2008
Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.
2010-09-02
6,471 reads
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
Note: Republishing because the article covering the issue and a workaround has been published here on SSC.
In a recent thread...
2010-09-01
4,331 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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