Time Off
It's almost summer with Memorial Day coming next week in the US. For this Friday's poll Steve Jones asks about nothing to do with SQL Server, technology, or work.
2009-05-21
425 reads
Articles
Time Off
It's almost summer with Memorial Day coming next week in the US. For this Friday's poll Steve Jones asks about nothing to do with SQL Server, technology, or work.
2009-05-21
474 reads
Creating a recycle bin for SQL Server 2005\2008
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
2009-05-20
13,755 reads
Data Profiling Column Functional Dependency T-SQL
This article demonstrates Data Profiling Functional Dependency
2009-05-20
4,536 reads
Connectivity Options for Microsoft SQL Server 2008 Integration Services
This white paper provides an overview of the connectivity options that are available for SQL Server 2008 Integration Services.
2009-05-20
1,939 reads
Denver SQL Server User's Group
Come learn about advanced data modeling with Paul Neilsen and DMVs with Glenn Barry, Thur, May 21 in Denver. Steve Jones will attend as well.
2009-05-20
1,223 reads
Do You Have a Problem?
Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.
2009-05-20
83 reads
Do You Have a Problem?
Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.
2009-05-20
326 reads
Do You Have a Problem?
Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.
2009-05-20
82 reads
SQL Injection - Why I Don't Think Parameterization is Enough
One of the main defenses touted against SQL injection attacks is to use proper parameterization at the application layer. But while this gets most of the cases, there are clearly examples where this alone fails. For instance, consider the stored procedure...
2009-05-20
3,948 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