Mid September Free Training from PASS
There's going to be over 30 hours of free online SQL Server training in the upcoming week and you're not going to want to miss out!
Top 10 SQL Server Integration Services Best Practices
Learn the top 10 best practices for large scale SSIS packages from a real world DBA.
Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log
SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the log can become fragmented and cause delay. In this tip we look at how to see how many VLFs exist as well as how this can be reduced to a more reasonable number.
SQL Saturday #46 - Raleigh
A free one day training event in Raleigh, NC. Come to the first SQL Saturday in this city on Sept 18, 2010
Instrumentation
This Friday Steve Jones is looking for the instrumentation or monitoring that you build into your applications.
Identifying and Eliminating the Dreaded Cartesian Product
Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever.
SQL Saturday #48 - Columbia
SQL Saturday Columbia, SC gives you a chance to get a full day of free SQL Server information, lectures, and seminars from the experts on the East Coast.
Enjoy Your Job
A reminder today that there are people that enjoy their jobs. Steve Jones reminds us that we should take jobs based on that criteria.
Inside the Optimizer: Constructing a Plan - Part 2
How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.
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
Kantor BCA KCP Pandanaran Telp/wa 085169998803
Telp/wa 085169998803 No. 101 A, Jl. Pandanaran, Mugassari, Kec. Semarang Sel., Kota Semarang, Jawa...
BCA KCP Hayam Wuruk HUB/WA 08216977701
Jl. Hayam Wuruk No.54, Maphar, Kec. Taman Sari, Kota Jakarta Barat, Daerah Khusus Ibukota...
BCA KCU Semarang Telp/wa 085169998765
Telp/wa 085169998765 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
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