SQL Server Orphanage – Using sp_change_users_login to find and fix all orphaned SQL users
Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy...
2012-07-30
1,437 reads
Blog Posts
SQLSaturday #171 Pittsburgh Prep Continues
Hey, did I mention that Pittsburgh is having a SQLSaturday this year?
Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...
2012-07-30
1,562 reads
Stop Storing Unencrypted Passwords!
I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...
2012-07-30 (first published: 2012-07-26)
2,748 reads
Syncing your contacts
In the same vein as my blog post about Syncing your calendars, I wanted to post how to sync your contacts...
2012-07-30
1,985 reads
Video Enable PowerPivot Add-in
This is one of our first PowerPivot video tutorials and this short 1 minute tutorial we show how to enable...
2012-07-30
1,631 reads
How to move master and resource system databases?
I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...
2012-07-29
6,887 reads
The effects of an SSD on SQL Server Performance
I. Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me. Being a...
2012-07-29
5,687 reads
Learning solid SQL Server and Business Intelligence skills through online training
I have just signed up for a one year standard subscription of Pluralsight Hardcore Developer Training. I’m focusing on SQL...
2012-07-28
1,657 reads
reconfigure vs reconfigure with override
You can change server properties of SQL Server using sp_confgure and to "save" it you need to use reconfigure. In...
2012-07-28
2,323 reads
SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint
This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing...
2012-07-28
974 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