A Discount on SQL Populator
Software Development Innovations is offering SQLServerCentral.com members a 20% discount on their products with a coupon of "sqlservercentral" used in their cart.
2007-07-27
2,309 reads
Articles
CLR: 9 Reusable Parallel Data Structures and Algorithms
This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal.
2007-07-27
2,632 reads
SQL Server Spotlight on Len Wyatt
Project REAL was an amazing undertaking by Microsoft to put SQL Server 2005 to the test in a real environment. One of the main people working on this was Len Wyatt, who agreed to take a few minutes and share some thoughts with us.
2007-07-26
1,870 reads
To Wrap or Not to Wrap
It's not a string manipulation article in T-SQL, but it is SQL Server related. Check out what Steve Jones has in store for the PASS 2007 Summit for the SQLServerCentral.com community..
2007-07-26
1,506 reads
XML Notepad with SSMS
XML is becoming more pervasive in all of MIcrosoft's product, including SQL Server. Jay Dave brings us a short look at how one of their lesser known tools, the XML Notepad, can be used by SQL Server DBAs.
2007-07-26
3,677 reads
Keep a check on your IDENTITY columns in SQL Server
Be sure you don't end up with arithmatic errors in your identity columns from a SQL Server MVP.
2007-07-26
2,984 reads
A T-SQL Regular Expression Library for SQL Server 2005
This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.
2007-07-25
4,024 reads
ADO.NET Entity Framework Overview
ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework.
2007-07-25
2,551 reads
Searching Words and Phrases in a Rich Text Field
Searching for data in a database is something we all do constantly, but few of us use the Full-Text Search features of SQL Server. Yousef Ekhtiari brings us a look at how you can get around some of the limitations of this feature and possibly use it in your application.
2007-07-24
6,474 reads
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
Part 3 of this series discussed how to script PowerShell and connect to SQL Server. This installment illustrates how to use a PowerShell script to loop through the content of a file and connect to different servers.
2007-07-24
2,479 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
Berikut Nomor whatsapp resmi Milik Bank woori
Berikutnya Nomor WhatsApp resmi milik Bank Woori Saudara (BWS) adalah 0821-3737-7865. Nomor ini digunakan...
BCA KCP Maluku tlpn/WhatsApp 08216977749
Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
BCA KCP Panglima Polim Raya Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby. Baru,...
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