Data Warehousing: Ensuring Data Integrity with End-to-End and Statisti
This article provides an architecture and process framework to ensure data quality in a data warehousing environment.
2007-08-02
1,862 reads
Articles
SQLCLR Security and Designing for Reuse
SQL Server's CREATE ASSEMBLY statement lets you catalog code with one of three predefined security buckets. But under the covers, there are actually two distinct security models at play: Code Access Security and Host Protection, and you need to understand both.
2007-08-02
1,670 reads
Server Farm Reporting - Part 1
Managing a large number of servers can be quite the challenge for many DBAs and it seems to get worse each year as more servers are added without an increase in staffing. New author Mark Tierney brings us the first part of a series on the framework he's built to help manage his servers.
2007-08-01
4,264 reads
T-SQL error handling with Try…Catch blocks
T-SQL Try…Catch block for SQL Server exception handling has new, improved functions to handle errors when executing T-SQL code in SQL Server 2005.
2007-08-01
3,672 reads
Get And Set SQL Server 2005 Instance Registry Values
Most SQL Server DBAs will never need to read the registry for their instances, however in case you do find yourself needing to read or write something in SQL Server 2005, Vince Iacoboni brings us a technique for performing both of these actions.
2007-07-31
8,881 reads
RSS Newsfeed Workbench
Robyn and Phil decide to build an RSS newsfeed in TSQL, using the power of SQL Server's XML.
2007-07-31
1,412 reads
SQL Server Password Management:
Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server.
2007-07-31
2,653 reads
Revisit What You Know
A thought provoking article from SQL Server expert and trainer Andy Warren. As a DBA you should think about the rules and decrees you have developed over the years and revisit them for application in your current situation.
2007-07-30
3,542 reads
AJAX Stock Symbol Drop-down List
A web look up of a huge list of stock symbols from an MS SQL database.
2007-07-30
2,817 reads
10 tips for sorting, grouping, and summarizing SQL data
Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.
2007-07-27
5,433 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