XQuery for the Non-Expert – @Variable Use
Talk to the Experts
In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert...
2011-01-20
2,997 reads
Articles
Multi-subnet Failover Clusters
Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...
2011-01-19
2,819 reads
SQL Server Unit Testing with tSQLt
When one considers the amount of time and effort that Unit Testing consumes for the Database Developer, is surprising how few good SQL Server Test frameworks are around. tSQLt , which is open source and free to use, is one of the frameworks that provide a simple way to populate a table with test data as part of the unit test, and check the results with what should be expected. Sebastian Meine and Dennis Lloyd, who created tSQLt, explain
2011-01-19
3,084 reads
Why Every DBA Needs a Buddy
If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...
2011-01-19
2,790 reads
Making a more reliable and flexible sp_MSforeachdb
While the system procedure sp_MSforeachdb is neither documented nor officially supported, most SQL Server professionals have used it at one time or another. This is typically for ad hoc maintenance tasks, but many people (myself included) have used this type of looping activity in permanent routines. Sadly, I have discovered instances where, under heavy load and/or with a large number of databases, the procedure can actually skip multiple catalogs with no error or warning message. Since this situation is not easily reproducible, and since Microsoft typically has no interest in fixing unsupported objects, this may be happening in your environment right now
2011-01-18
3,580 reads
SQL University: Spring 2011
The new SQL University Logo
Welcome back students! We’re very excited to start up a new semester and SQLU is back and...
2011-01-18
1,258 reads
31 Days of SSIS – Create XML Document (13/31)
31 Days of SSIS
Day thirteen and we are trucking along with the 31 Days of SSIS blog series. The last...
2011-01-17
2,056 reads
Effective Clustered Indexes
As a guideline, clustered Indexes should be Narrow, Unique, Static and Ever Increasing (NUSE). Michelle Ufford Explains why.
2011-01-17
4,641 reads
SQL Saturday #45 - Louisville
A free day of training in Louisville, KY. Come and learn more about SQL Server from a variety of experts.
2011-01-17 (first published: 2010-11-30)
3,202 reads
Getting Started with SQL Azure Development
SQL Azure provides features similar to a relational database for your cloud apps. We’ll show you how to start developing for SQL Azure today.
2011-01-14
3,003 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor resmi BCA KCU PLUIT Telp:083178278662
Telp:083178278662Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North Jakarta City,...
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