The Demo Setup–Attaching Databases with Powershell
I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...
2015-03-16
4,581 reads
I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a...
2015-03-16
4,581 reads
2015-03-13
1,470 reads
I was testing something the other day and realized this was a security area I didn’t completely understand. I decided...
2015-03-12
1,234 reads
A short piece, as I ran into the need recently to alter a column to NOT NULL status. I’ve rarely...
2015-03-12
793 reads
How much of an investment should you make in learning design? Steve Jones talks about why we should learn how to do it right.
2015-03-11 (first published: 2010-09-29)
337 reads
2015-03-11
1,816 reads
2015-03-10
1,864 reads
2015-03-04
1,865 reads
2015-03-03
1,825 reads
2015-03-02
810 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
Comments posted to this topic are about the item 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