SQL Server 2008 Administration in Action - Sample Chapter
A sample chapter on clustering from Manning Publishing. Read it to learn a bit on clustering and preview this new book.
2009-12-18
1,612 reads
Press Release
TSQL Challenge 19 - Working with consolidated calculations on hierarchical structures
This challenge involves generating an organizational hierarchy and calculating the total orders created by each employee and his/her subordinates. It involves a number of challenges such as generating a resultset in the correct hierarchical form, calculating the orders created by each employee and his/her subordinates and finally calculating the total orders created by self and all the subordinates.
2009-12-14
2,432 reads
TSQL Challenge 18 - Generate text formatted month calendars
Can you generate a calendar with T-SQL? Take this month's challenge.
2009-11-30
3,924 reads
The WorkTamer Conference
The Worktamer conference is coming to a series of cities in Canada in early 2010. If you're near Vancouver, Toronto, or Montreal, read about this one day event to help you boost your professional development.
2009-11-19
303 reads
TSQL Challenge 17 - Creating cross rows references with inline hyperlinks
Here is a real world scenario I came across on the MSDN forums. The forum poster wanted a method to dynamically create HTML hyperlinks, for keywords/phrases , within the description of the current column text. Enter this challenge and see how your T-SQL skills match up.
2009-11-16
2,633 reads
2009-11-06
40 reads
The ADO.NET Managed Providers team wants to hear your opinion
Take this survey and help out the Managed Provider team at Microsoft.
2009-11-05
806 reads
Top Ten Reasons to Attend the 2009 PASS Community Summit
There are some good reasons to think about attending the 2009 PASS Community Summit.
2009-10-22 (first published: 2009-03-24)
4,570 reads
SQL Bits IV
Coming to Newport in the UK on Nov 19-21, be sure to register and attend if you are nearby. A few days of great SQL Server training.
2009-10-21 (first published: 2009-09-21)
1,917 reads
Data Cleansing with the SSIS Data Flow
A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.
2009-10-21 (first published: 2009-10-19)
5,648 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers