Beginning Professional Development
Continuing with his series on professional development, Andy Warren takes a look at funding some of your career growth and why it pays to invest in yourself.
2007-09-27 (first published: 2006-09-25)
5,619 reads
Articles
Newsletter Changes
A few proposed changes to the newsletter. Read about them and give us some feedback on what you think.
2007-09-27
590 reads
Reverse Engineering ADTs in SQL Server 2000 - Part 3
Continuing on with his series on ADTs, Yakov Shlafman takes a look at working with schema changes when your ADT is on a column used as a primary or foreign key.
2007-09-27
2,241 reads
Avoid enclosing Indexed Columns in a Function in the WHERE clause
When a function is wrapped around an indexed column in the WHERE clause it will usually prevent the proper usage of that index. This article gives an example and discusses what other options are available.
2007-09-27
5,005 reads
Dynamic Partitioning and Dynamic Indexing
We are always searching for new ways to improve the performance of our database systems. Raghavendra Narayana brings us a new article that examines an idea for rebuilding partitions and indexes based on data access: in real time!
2007-09-26
5,613 reads
2007-09-26
529 reads
A Cynic's Top Ten Tips for IT Contractors
As autumn approaches, Patrick Index produces his ten hot chestnuts for IT Contractors like himself, with a jaundiced 'contractor's-eye view'.
2007-09-26
5,583 reads
Replication Statement Delivery Options - Part 2
Continuing with his look at transactional replication, Andy Warren looks at the various delivery options with a detailed analysis of what happens under various configurations.
2007-09-25
5,548 reads
RSS Everywhere
With the new codebase in place, RSS is pervasive throughout the site. Get a few hints here on how this works.
2007-09-25
2,251 reads
Four cool new features slated for SQL Server 2008
SQL Server 2008 (code named Katmai) is scheduled to launch in February of next year, and the code isn't slated to be released to manufacturing until Q2 2008. But database gurus don't have to wait to get a sense of what's to come because Microsoft recently released SQL Server 2008 to the community for preview.
2007-09-25
7,293 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers