Powershell in a Month – Day 19 – I/O
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-03-03
1,199 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
Geeky Entertainment
As a break from work, this week Steve Jones wants to know what you wish for. Are there comic book, science fiction, or technological thrillers you'd like to see made into movies?
2014-02-28
158 reads
Powershell in a Month Day 18–Variables
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-02-28
1,456 reads
Fixing CREATE TABLE
Steve Jones has a problem with the inconsistency of the CREATE TABLE statement in SQL Server and has an idea on what to do.
2014-02-27
264 reads
Virtual Lab – Setting up a new VM
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-02-27
1,471 reads
Caching
A SQL Server database can easily be seen as a bottleneck as all data must be retrieved from a single machine. However a caching strategy in your application and alleviate load and improve performance.
2014-02-26
252 reads
Lawsuits and Data Breaches
Steve Jones notes that a data breach resulted in a lawsuit. How long before that's a common practice, and should we be preparing as data professionals.
2014-02-25
145 reads
Auditing Matters
We might not be able to stop hacks, attacks, or issues with our databases, but knowing that they've occurred is important. Steve Jones notes that we might need auditing more than security.
2014-02-24
170 reads
2014-02-24
105 reads
The SQLCLR Impact
Has the SQLCLR system impacted your SQL Server environment? Steve Jones wants to know if it has or has not today.
2014-02-21
221 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