Quickly Copy Data
Moving data around can be a challenge as the sizes of our databases grow. Steve Jones talks about some of the challenges and some creative ways you might consider moving data.
2013-06-06
298 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Fear Fear
Do you let your fear drive you in how you work with technology? Steve Jones thinks you should be cautious, but not paralyzed.
2013-06-05
144 reads
CHOOSE in SQL Server 2012
The CHOOSE command is new in the T-SQL as of SQL Server 2012. I hadn’t ever had the chance to...
2013-06-04
1,365 reads
2013-06-04
165 reads
Relying on Algorithms
Today Steve Jones looks at the way software affects the world and how we might be worried about how things might change in the future.
2013-06-03
129 reads
PC Sales Declining
About 3 or 4 years ago I was talking with my wife and a colleague of hers that worked in...
2013-05-31
1,400 reads
The Bicentennial
Tomorrow is the bicentennial SQL Saturday event. SQL Saturday #200 takes place in Philadelphia, and Steve Jones has some thoughts as he travels to the City of Brotherly Love.
2013-05-31
81 reads
When will we look back at this?
It’s amazing how software has advanced. I look at the software I use, and I’m amazed. I still remember texting...
2013-05-31 (first published: 2013-05-24)
2,053 reads
Exploring a Database in Azure
After creating my Azure account, I wasn’t sure where to go next. Fortunately I had an immediate project that occupied...
2013-05-30
1,653 reads
The Speed of Azure
There isn't a lot of acceptance of Azure from DBAs. Steve Jones talks about some of the advantages of Azure and thinks that we should be working to ensure that our internal systems respond at the same speed as people can get from Azure.
2013-05-30
180 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