Giving Your Best
It's easy to get into a rut at work, and easy to just attempt to get some minimum amount of work done each day. Steve Jones is inspired today to think about doing more.
2009-05-18
513 reads
Articles
Giving Your Best
It's easy to get into a rut at work, and easy to just attempt to get some minimum amount of work done each day. Steve Jones is inspired today to think about doing more.
2009-05-18
204 reads
To Date or Not To Date….
OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store current data, but there is a need for future-dated data as well. Because the base table can’t hold that data...
2009-05-18
3,057 reads
Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video)
This video demonstrates how to improve the performance of the data flow in an Integration Services package. In this video, you will learn how to tune the following phases of the data flow: Extraction, Transformation, Loading
2009-05-18
2,270 reads
Using PowerShell with SQL Server Management Objects (SMO)
I want to know how Windows PowerShell can help me as a SQL Server DBA.
2009-05-18
3,498 reads
Vendor Value
Software maintenance is often required when purchasing software packages. But do the vendors deliver value for this charge? Steve Jones has a few thoughts on the subject.
2009-05-17
76 reads
Vendor Value
Software maintenance is often required when purchasing software packages. But do the vendors deliver value for this charge? Steve Jones has a few thoughts on the subject.
2009-05-17
87 reads
Vendor Value
Software maintenance is often required when purchasing software packages. But do the vendors deliver value for this charge? Steve Jones has a few thoughts on the subject.
2009-05-17
72 reads
Setting up a SQL cluster under MS VS2005 R2 Part2
Continuing with setting up a 2 node SQL cluster under MS Virtual server 2005 Ent R2 SP1, Perry Whittle looks at the SQL configuration in this article.
2009-05-15
3,945 reads
The Data Access Handbook - Sample Chapter
We have a sample chapter available from The Data Access Handbook, written by experts at DataDirect Technologies.
2009-05-15
1,952 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