February Question: If you weren’t a DBA, what would you like to do?
Sometimes its fun to think of what career you might have chosen if you hadn’t become a DBA. With this...
2012-02-01
834 reads
Learning, Networking & Wine
Let’s say, you want to spend a couple of days learning about SQL Server. You also want to spend some...
2012-02-01
1,186 reads
A few quick time calculations
Have you ever needed to do a quick time calculations of the amount of hours/minutes/seconds that have passed? Suppose you...
2012-02-01
1,118 reads
Speaking at Space Coast SQL Users Group on Feb 9, 2012
I’ll be visiting the Space Coast group (http://spacecoast.sqlpass.org/) on Feb 9th to do a presentation on Professional Development Plans. I’m...
2012-02-01
735 reads
A Script A Day - Day 1 - Database File To Volume Mapping
Today is the 1st February 2012 and as promised here is the first of script in my "A Script A Day"...
2012-02-01
585 reads
SSRS – Using Analysis Services Dynamic Management Views to Build Dynamic Reports
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They...
2012-02-01
2,335 reads
DevConnections Offers DBAs Many Options for Training
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...
2012-02-01 (first published: 2012-01-31)
2,508 reads
App Domains and Their Uses
What is an app domain
An App Domain can be thought of as a kind of lightweight process. So What is...
2012-01-31
144 reads
Your Road to Becoming a DBA: Laying a Strong Foundation
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-01-31
2,154 reads
Setting the DAC port….
TweetG’day,
I had a situation today where I needed to ensure that the dedicated Administrator connection (DAC) ran on a specific port.
The main...
2012-01-31
9,886 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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