SQL Server Source Control Basics
Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.
Troubleshooting SQL Server: A Guide for the Accidental DBA
Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
Set up a Memory Quota for SQL Server Memory Optimized Databases
You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip you will learn how to proceed.
SQL Server Luxembourg: Wait Watchers
On November 19, 2014, the SQL Server Luxembourg User Group and Dell Software will be hosting a free event. Richard Douglas will be be presenting a double bill: SQL Server 2014 features everyone can use, and Wait watchers - Gain Performance Increases Fast! This event is free to registered attendees.
Pay It Forward
Steve Jones looks at the dilemma of training developers and having them leave, or maybe, just having them stay untrained.
Using Comments to Quickly Test CTEs
A quick tip for using a combination of block and line comments to test CTEs
Acceptance Testing with FitNesse: Database Fixtures, Project Overview
There aren't many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configured and set up correctly, makes it very easy for a non-specialist to set up individual tests.
ETL Performance Auditing - Part 2: Auditing Data Staging Phase
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
Backup and Restore Strategies in SQL Server – Part 2
In this article of the series Arshad Ali discusses different types of restore processes and backup and restore scenarios.
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 Puri Deltamas HUB/WA 08216977749
Komplek Ruko Puri Deltamas Blok J. 5, Jl. Bandengan Sel. No.43, Daerah Khusus Ibukota...
BCA KCU BINTARO Hubungi.0821•3111•185
BCA KCU BINTARO Hub.0821•3111•185 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
BCA KCP Citra Towers HUB/WA ,08216977749
Citra Towers, North Tower Lt 01 No. Unit 01/GF, Jl. Benyamin Suaeb Kavling A6,...
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