Understanding the CDC State Value
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,230 reads
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,230 reads
Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...
2012-07-10
4,122 reads
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may...
2012-06-26
276 reads
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...
2012-06-25
959 reads
PowerPivot was a great new tool when it released several years ago. Now the newest version is out along side...
2012-04-05
3,748 reads
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,234 reads
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a...
2012-04-02
1,494 reads
In an SSIS package you have the option to choose from a wide range of source from Flat Files to...
2012-03-29 (first published: 2012-03-23)
3,625 reads
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In...
2012-03-23
2,018 reads
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
1,435 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
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