SQL Server 2008 R2 Best Practices Analyzer
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
Changing Jobs
Today Steve Jones talks about the reasons why you might change jobs, and the fact that you aren't alone. However be careful about changing jobs, and make an attempt to stay if you can.
Script Task Exception Handling in SSIS
When working with Script Task of SQL Server 2008 Integration Services, it is important to ensure that your custom code complies with the most elementary programming practices. Learn how to handle unexpected errors that interfere with the successful execution of your code.
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
Help with Performance
Performance is always one of the most important things a DBA can learn to deal with. It's also one of the more nebulous arts to learn. Today Steve Jones shares some thoughts on how we might better help people learn.
SQLServerCentral Webinar Series #5: Setup Your Source Control With Help from PowerShell
MVP Allen White shows how he can use Powershell to setup SQL Source Control from Red Gate Software on Nov 18, 2010.
Determining An Enterprise Execution Policy Setting
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
Troubleshoot Database Concurrency in SQL Server with sp_locks
sp_locks is a useful tool which can help a DBA in detecting and troubleshooting blocking and concurrency scenarios. This article demonstrates a worked example of using sp_locks to troubleshoot a database concurrency issue.
Analyzing Product Growth with the Management Data Warehouse
This article presents a case study of using the Management Data Warehouse feature in SQL Server 2008 to analyze disk usage trends by product.
Ready for Inspection
Today we have a guest editorial from Andy Warren. Are you ready for an inspection at work? Are you really running your environment in a way that would make you proud? Andy has some thoughts about sticking to your policies and procedures.
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
BCA KCP S. Parman TLP/WA 08216977749
Jl. S. Parman No.184, Ulak Karang Sel., Kec. Padang Utara, Kota Padang, Sumatera Barat...
BCA KCP Kemang Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta Selatan, Daerah...
BCA KCP Ambasador Telpon/wa:0813.7887.595
BCA KCP Ambasador Telpon/wa:0813.7887.595.Mal & Apartemen Ambasador, Jl. Prof. DR. Satrio No.R.18 Lantai Dasar,...
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