Utilizing sharded data can be a complicated process. By now you probably know that sharded data is the distribution of data into multiple tables or even multiple databases. The problem then becomes how to retrieve that data from the distributed shards if you don’t have an already built in method such as partitioned tables in SQL Server? MySql has a […]
Other News
Tips for using XML in SQL Server 2014
Tips for using XML in SQL Server 2014 Use SQLXML instead of Native XML Web Services. Beginning in SQL Server 2014, the Native XML Web Services is removed. So, you can no longer use CREATE ENDPOINT or ALTER ENDPOINT to add or modify SOAP/HTTP endpoints. Consider using the RAW mode of FOR XML queries, instead of AUTO or EXPLICIT modes....
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
Querying XML in SQL
(Martina) I like to use my blog as a library for myself, to be able to easily find solutions I have used before. Here is a simple example of querying an XML string using SQL.
Setting up and using a DB2 in-memory database on IBM Bluemix
(Henrik Loeser) Last Friday I was on the way back from some customer visits. While traveling in a German highspeed train I used the Wifi service, connected to IBM Bluemix and created a DB2 in-memory database.
Generic Repository and Unit of Work Pattern, Entity Framework, Unit Testing, Autofac IoC Container and ASP.NET MVC [Part 1]
(Brij Mohan Dammani) In this post, we will see how to implement a decoupled, unit-testable, N tier architecture based on Generic Repository Pattern with Entity Framework, IoC Container and Dependency Injection in ASP.NET MVC. We will implement a sample application step by step for the same.
JavaScript Result in Controller Sample in MVC: Day 12
(Akshay Patel) Here we see how to use a JavaScript result in controller in MVC.
A brief comparative perspective on SQL access for Hadoop
(Sherif Sakr) Although Hadoop is often thought of as the one-size-fits-all solution for big data processing problems, the project is limited in its ability to manage large-scale graph processing, stream processing, and scalable processing of structured data.
Create with WLST a SOA Suite, Service Bus 12.1.3 Domain
(Edwin Biemond) When you want to create a 12.1.3 SOA Suite, Service Bus Domain, you have to use the WebLogic config.sh utility. The 12.1.3 config utility is a big improvement when you compare this to WebLogic 11g. With this I can create some complex cluster configuration without any after configura
Preventing standby databases opening in Active DataGuard mode + chopt !!!
(John Hallas) It is long been a concern of mine that it is relatively easy to open a standby database inadvertently and then be potentially liable to a licensing cost as usage is shown in the DBA_FEATURE_USAGE_STATISTICS view.
A brief history of time^H^H Oracle session statistics
(Martin Bach) I didn’t intend to write another blog post yesterday evening at all, but found something that was worth sharing and got me excited… And when I started writing I intended it to be a short post, too.