Branching and Merging: Ten Pretty-Good Practices
After experiencing 'merge misery' personally, Konrad Lukasik came up with 10 well-tested ways of making branches and merges a stress-free part of application development.
2014-05-29
7,273 reads
Articles
Transparent Data Encryption (TDE) in SQL Server
There are several ways to implement encryption in SQL Server; Arshad Ali focuses on Transparent Data Encryption (TDE), which was introduced in SQL Server 2008 and is available in later releases.
2014-05-28
3,280 reads
2014-05-27
1,130 reads
Optimizing Transaction Log Throughput
As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. This article demonstrates how this can have a significant impact on the performance of any SQL Server operations that need to read the log.
2014-05-27
3,916 reads
Do We Still Need Database Design in the Era of Big Data?
Many big data application implementations seem to begin with an existing data warehouse, one or more new high-volume data streams, and some specialized hardware and software. The data storage issue is often accommodated by installing a proprietary hardware appliance that can store huge amounts of data while providing extremely fast data access. In these cases, do we really need to worry about database design?
2014-05-26
5,297 reads
The 5 Worst Days in a DBAs Life: Day 2
Steve and the rest of the DBA Team are back for round two. In this episode they have to restore all of a business' data using nothing but a set of off-site backups, kanban, and witty repartee.
2014-05-26
3,080 reads
Microsoft Azure Storage Queues Part 1: 360 Degrees
Microsoft Azure Queues are more than just a class or a concept – they're a ready-to-use service that loosely connects components or applications through the cloud. Roman Schacherl provides a helicopter overview of the service.
2014-05-23
2,227 reads
SQL Saturday #294 - Philadelphia
SQL Saturday is coming to Philadelphia on June 7, 2014. This event is a free day of training and networking for SQL Server Professionals, organized by the Philadelphia SQL Server User Group. The event also features two paid-for Precons, one presented by Allan Hirt and the other presented jointly by Joseph D'Antoni and Stacia Misner. Register while space is available.
2014-05-23
1,877 reads
Table Partitioning –XE Diagnostic for Data Movements
Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols
2014-05-22
2,548 reads
Write for SQLServerCentral
We are looking for new content here for the site, based on your experiences in the real world. Submit something and get yourself published.
2014-05-22 (first published: 2014-04-10)
2,030 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
BCA KCP Jalan Panjang HUB/WA (08218573837)
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
BCA KCP Pasar Puri Indah Hub/Wa 08218573837
Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
BCA KCP Taman Ratu Hub/Cs (08218573837)
Komp, Jl. Taman Ratu Raya Bl. Bl No.5/8, Duri Kepa, Kec. Kb. Jeruk, Kota...
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