Microsoft SQL Server security best practices checklist
SQL Server is a repository of sensitive information for organizations, and that is why it is important to ensure that...
2013-07-15
3,418 reads
Basit's SQL Server Tips
Understanding SQL Server Database Restore Process
Data is a critical asset for an organization to keep information about their customers, inventory, products, purchasing, and financial stocks....
2013-07-15
689 reads
SQL Server Database Backups and Recovery Models – (Part 3)
Checkout the part-3 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which I discussed...
2013-07-15
742 reads
SQL Server Database Backups and Recovery Models – (Part 2)
Checkout the part-2 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which you’ll learn...
2013-07-15
933 reads
xVelocity Columnstore Indexes in SQL Server 2012
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in...
2013-06-12
1,430 reads
Centralized SSIS solution to monitor failed SQL Server Agent Jobs across the enterprise
SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business...
2013-06-12
878 reads
SQL Server Transactions and Locking (Part 2)
Checkout the part-2 of my two part article series on SQL Server Transactions and Lockinghere, in which you will learn...
2013-06-12
593 reads
SQL Server Database Backups and Recovery Models – (Part 1)
Whether caused by hardware failure, software errors or malicious actions, there is always a possibility of data loss. You should...
2013-06-12
697 reads
Monitoring Blocked Processes with Event Notifications
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...
2013-06-12
1,206 reads
Database index design and optimization: Some guidelines
Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response...
2013-05-22
1,539 reads
Blogs
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...
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...
Forums
BCA KCP Kemang Telpon/wa:0813.7887.595
BCA KCP Kemang Telpon/wa:0813.7887.595.Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta...
BCA KCP Permata Ujung Menteng Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota Jakarta...
BCA KCP Sejati Mulia Telpon/wa:0813.7887.595
BCA KCP Sejati Mulia Telpon/wa:0813.7887.595.Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, Jati Padang,...
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