Do you work with data? You’ve always got options.
She's ready for the future. Are you?
In preparing for the SQLPeople event, I thought about the role, motivation, and techniques...
2011-04-15
948 reads
Blog Posts
Late April Free Training from PASS VCs
PowerShell provisioning of Hyper-V Servers
Designing Cubes for Performance
Database Standards SOP
_____________________________________________________________
PowerShell provisioning of Hyper-V Servers
April 20, 2011, 12 PM EDT (GMT...
2011-04-15
717 reads
Powershell Day 15
Day 15 Introduction to Powershell for MS Sql Server So far we have discussed several features and information about Windows...
2011-04-15
785 reads
Re-Blog – April 8-14
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-15
581 reads
SQL Azure
If you’ve talked to anyone from Microsoft recently you had to have heard the phrase “all in.” It’s been made...
2011-04-15
645 reads
The Pro-Active DBA List Updated
A couple of years back, in the heart of the economic tsunami, I proposed a list of pro-active steps to...
2011-04-15
1,381 reads
A SQL Server Hardware Nugget A Day – Day 14
Since 2006, Intel has adopted a Tick-Tock strategy for developing and releasing new processor models. Every two years, they introduce...
2011-04-14
608 reads
Be the Master of your Data Warehouse Universe at SQLRally!
Do you have a data warehouse initiative in your current organization and looking for a way to learn how to...
2011-04-14
855 reads
Confessions of a DBA – Part 3
After reading this confession, I am sure almost every DBA is going feel a churn in their stomach. They are...
2011-04-14
2,059 reads
Get all SERVERPROPERTY values for SQL Server
A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...
2011-04-14
13,535 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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