Do you want to speed up the performance of your Entity Framework project? Jonathan Magnan has an extention for Entity Framework doing precisely that. Check it out at http://zzzprojects.com/entity-framework-extensions/ What does it do? In short it reduces the number of round trips from your app server to the database server when executing you Create, Update, or Delete operations. The extension […]
Other News
SSWUGtv: Today, Patrick and Steve discuss data security for start ups.
Video Programming for IT Professionals
SQL Server 2014 Merge Replication Optimization Tips (Part 1)
SQL Server 2014 Merge Replication Optimization Tips (Part 1) Create an index on each of the columns that is used in the filter’s WHERE clause. If you do not use indexes on columns used in filters the SQL Server must perform a table scan, which can results in performance degradation. Set the "Maximize Throughput for Network Applications" option. This can...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Improvements to STRICT MODE in MySQL
(Abhishek Ranjan) As a part of improving the error handling, in MySQL 5.7.5 we have re-implemented STRICT sql mode.
Statement-Level Atomicity
(stewashton) So important yet often ignored or misunderstood! No, not me, but “statement level atomicity”.
Oracle Database 12c: RMAN Enhancements
(Sridhar_R-Oracle) In this blog, I am going to provide an overview of new Oracle Recovery Manager (RMAN) features that were introduced in Oracle Database 12c.
Alerting on plans that change for the worse
(Bobby Durrett) I’ve uploaded a monitoring script that I have worked on: zip.
Step-by-Step: Automated Provisioning for Linux in the Cloud with Microsoft Azure, XPlat CLI, JSON and Node.js ( Part 1 )
(KeithMayer) Since previously publishing the Quick Start Guide for Building Highly Available Linux Servers in the Cloud on Microsoft Azure, several people have asked me about ways in which Linux workload provisioning can be automated with Azure.
Java Bytecode Reverse Engineering
This article is especially designed to crack Java executables by disassembling their corresponding bytes code. Disassembling of Java bytecodes is the act of transforming Java bytecodes into Java source code.
Improved Online Operations in SQL Server 2014
(Dinesh Asanka) Online indexing rebuilding was a major breakthrough from SQL Server to support users re-indexing while the clustered index (or table) and other indexes are available during the index rebuild operation.