Database uplevel Restores
Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day....
2012-01-06
691 reads
Are you allowed to use social networking at Work?
I was reading this article about internet usage by staff who work for local authorities in Wales http://www.bbc.co.uk/news/uk-wales-16394916 The content...
2012-01-06
962 reads
Arithmetic overflow error and isdate sql
Executing a t-sql statement with a convert function
convert(datetime, my_date_column) ,
threw an arithmetical overflow error with the message :
Message
Arithmetic overflow...
2012-01-06
1,260 reads
A Tale of Two Cities - SQLSaturday Goes Global..
It was a day of warm weather, it was a day of cold weather. A tale of two cities on...
2012-01-06
2,060 reads
SQL Server 2012 Licensing VMs without SA
I ran across a blog talking about Microsoft licensing, and found it very interesting. I learned a few things, and...
2012-01-06
2,006 reads
31 Days of SSIS in a PDF
At some point last year after finishing the 31 Days of SSIS, I decided to bundle up all of the posts...
2012-01-09 (first published: 2012-01-05)
7,132 reads
PASS Summit Eval – Extended Events
As I mentioned in yesterday’s post, I had two sessions at the PASS Summit this past year in which I...
2012-01-05
750 reads
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...
2012-01-05
2,246 reads
Msg 7395: Unable to start a nested transaction
Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but...
2012-01-05
3,368 reads
LOOP, HASH and MERGE Join Types
Today I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences,...
2012-01-05
5,879 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