DevWeek 2010 is Coming Up
The time has come again for the UK’s biggest conference for .NET developers and SQL Server professionals. Read the press release about this years DevWeek.
Get Your ANSI_NULLs Settings Consistent
William Talada brings us a short article to help you check your ANSI NULL settings and gives you a few reasons why you might want to make them consistent.
SQL Server Consolidation : how to decide on the right approach
The PASS DBA VC hosts this session today that will focus on helping to choose between using a virtualization, instance, or database consolidation option. We will highlight a few of the key areas to consider as well as some of the important differentiators to keep in mind. We will provide a decision tree to help guide administrators through the process of selecting a consolidation option.
The Dying Administrator
Is the SAN administrator dying out as a job? Steve Jones comments on an article that suggests it might be.
Celko's SQL Stumper: The Class Scheduling Problem
What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!
SQL Saturday #34 - Boston
Coming on Jan 30, to the Boston area, be sure to attend this SQL Saturday if you are nearby.
The IT Explosion
So many people are joining the IT industry all the time and Steve Jones talks about the attitudes that they bring with them.
Using "Multiple Assignment Variables" for a Generic Compare Data Script
Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.
Best Practices for Exception Handling and Defensive Programming in Microsoft SQL Server
This is a deep dive developer session that explores error handling in SQL Server. The session focuses on core error handling areas such as understandign the anatomy of errors, detecting errors in TSQL and best practices for error handling and defensive programming in Microsoft SQL Server. tuesday, 1/26, 8:00am EST
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