(Alex Nuijten) My session on “Oracle 12c for Developers” is done. Afterwards someone asked the question:
Other News
The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 11–22)
(Iggy Fernandez) On the Toad World site, I’m writing a series of blog posts and Wiki articles on the subject of EXPLAIN PLAN. I’m using EXPLAIN PLAN as a motif to teach not just SQL tuning but also relational theory, logical database design, and physical database design.
How to Insert Bulk Records Into SQL Server Using XML Data Type in ASP.Net With C#
(Mahesh Alle) In this article you will learn how to insert bulk data into a single table in SQL Server using xml as the data type.
.NET Just in Time Compilation and Warming up Your System
(Abhinaba Basu) One of the primary obstacle we face while scaling our system is Just In Time (JIT) compilation of the .NET stack. We run a .NET managed application server at a huge scale with many thousands of managed assemblies on each server (and many many thousands of those servers distributed gl
AlwaysOn Availability Groups and SQL Server Jobs, Part 3: Defining Batch Jobs
(Michael K. Campbell) Among other things, the SQL Server Agent provides SQL Server with a job scheduling engine (i.e., a daemon or bot) that can be used to schedule the execution of various tasks. Practically speaking, there are a number of different kinds of jobs that can executed on a given SQL Se
One Source of Truth
In any database in order to have consistency it is important to have one ultimate source of truth. Many times we want to have that data in different forms. So, do we maintain the data in different forms, or derive it from a single form? For example, you have data in relational tables in a database. You wish to see […]
SQL Server 2014 Replication – Part 3
SQL Server 2014 Replication – Part 3 Author: Basit A. Farooq Editor’s note: In this third part of my SQL Server 2014 Replication article series, you’ll learn about working and configuration of Transactional replication. You’ll also learn about working of Merge replication. Transactional replication Transactional replication sends incremental changes and transactions to the Subscribers. Transactional replication gives you a shorter...
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
Using SSIS To Get Data From a Web Service
(David Dye) SSIS has a web service control flow task that allows you to call a web service and store the results. This can be very useful if you need to call data from a web service that will be stored in an OLTP or OLAP database.
FileUpload Control Inside WebGrid To Upload File In Asp.net MVC Using C#.Net
(Pranav Singh) This article will show you how you can use input fileupload control in an MVC webgrid and the selected file in the controller end inside the webgrid. In this article I have used mvc webgrid and input file control to upload the file when you select in webgrid by using asp.net mvc and c
Semantic technologies fuel the Web experience wave
(Geoffrey Bock) We’re in the midst of a not-so-subtle shift within content management. The popularity of Web content management is waning and is being replaced by Web experience management. This substitution raises a simple question: How can content be transformed into an experience?