State Models - Database Weekly (Feb 16, 2009)
Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.
2009-02-13
774 reads
Articles
Data Mining in Excel 2007 Pt.2 - SQL School Video
In this video MVP Brian Knight continues on with more advanced data mining using Excel.
2009-02-12
3,407 reads
2009-02-12
6,797 reads
Challenging the Tyranny of Third-Party Vendors: A DBA’s Manifesto
Over the years, I have dealt with a lot of third-party applications (and their vendors) that use SQL Server as their back-end databases. It has often been an uneasy relationship, fraught with pain and tribulation. The overriding feeling I have gotten...
2009-02-12
1,514 reads
Conservative or Risky?
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
2009-02-12
537 reads
Conservative or Risky?
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
2009-02-12
513 reads
Conservative or Risky?
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
2009-02-12
557 reads
Introduction to Change Data Capture in SQL Server 2008
This article takes a look at the great new auditing features available in SQL Server 2008.
2009-02-12
2,578 reads
SSIS 101: Isolating Data in a Data Flow
MVP and SSIS expert Andy Leonard brings us a new article on how to work with a data flow and manipulate your data in complex ways.
2009-02-11
10,710 reads
Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
2009-02-11
669 reads
Blogs
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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
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