Sound Off with Soundex
In this article, learn how to use phonetic algorithms such as soundex to make looking up names faster, easier, and more reliable.
How Do You Handle the Stress of Being a DBA?
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
The power of batching Transactions
This article analyzes the performance gains of batching multiple DML statements into a single transaction. New author Manor Lev-Tov examines the effect of grouping statements together instead of running them all as separate transactions.
How To Enable Caching in SQL Server Reporting Services (SSRS)
We have many SQL Server Reporting Services (SSRS) reports that use our OLTP systems as data sources. We are always adding new reports and the number of users running these reports is also increasing rapidly. We would like to look at enabling report caching as a way to reduce some of the load on our database servers. In this tip I will go over the steps needed to enable report caching for SQL Server Reporting Services reports.
Help Others, Help Yourself
There is something to be said for helping others. However it isn't necessarily a selfless act. Guest writer Tim Mitchell talks a little about how helping others has helped him.
Retrieving Identities on set-based inserts
Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.
Full Text Index Queries using CONTAINS and CONTAINSTABLE
Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on the remaining two constructs, CONTAINS and CONTAINSTABLE.
Perfect is the Enemy of Good
Today we have a guest editorial from Andy Warren. We all would love to have perfect code, but is always worth the time? Andy Warren notes that cutting a corner or two might make sense at times.
Recovering data from corrupt tables using non-clustered indexes
At times database corruption happens and no good recovery path is available. It is possible to salvage data from indexes using query hints.
Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
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