Join this webinar on Tuesday, Nov 29, 2011 to see how SQL Monitor and SQL Source Control can help you solve problems in your environment.
2011-11-29 (first published: 2011-11-21)
1,196 reads
2011-11-29 (first published: 2010-03-31)
10,008 reads
The SQL Server 2008 R2 setup program crashes sometimes leaving you with a "half installed" instance: this is about how I repaired the setup on a populated cluster.
2011-11-29
4,565 reads
The loss of a company's data is often enough to put the company out of business; and yet backup errors are generally avoidable with the application of common sense rather than deep technical knowledge. Grant digs into memories of his long experience of giving forum advice, to come up with the most easily preventable backup errors.
2011-11-29
2,910 reads
This challenge invites you to identify the longest sequence of alphabets from a string.
2011-11-28
992 reads
How to incorporate data mining directly into the Data Flow of SQL Server 2008 R2 Integration Services-based packages.
2011-11-28
2,226 reads
This article demonstrates basic VB.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.
2011-11-25
15,755 reads
SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.
2011-11-25
4,497 reads
2011-11-24
42 reads
2011-11-24 (first published: 2010-03-24)
10,599 reads
Ten years ago, I published a post about filming a Pluralsight Play by Play...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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
Comments posted to this topic are about the item 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