(Jeremy King) Sometimes if you have tables with a lot of columns which you are trying to union, it can be hard to identify the columns they have in common and you may get this error a lot
Author: SSWUG Research
Database diagram support objects cannot be installed because this database does not have a valid owner- SQL server error solution
(jalpesh vadgama) Before some days, I have copied one database from the one of server and restored it on my machine. The server was not having ‘sa’ user login and I was having the ‘sa’ user in my local machine.
Exploiting Integer Based SQL Injection in Nested SQL Queries
(Sasha Zivojinovic) In this post I’ll be talking you through exploiting what turned out to be an interesting SQL Injection variation – SQL injection involving nested queries and arithmetic evaluation.
Using the updated SharePoint 2013 REST API versus the SharePoint 2010 model
(Craig Pilkenton) This article will cover the changes between how we used REST in 2010 and what we need to ‘update’ for using the streamlined interface in SharePoint 2013.
SQL Server Analysis Services Query Response Comparison by Storage Mode
(Dallas Snider) What are the differences in MDX query response times among the different Analysis Services storage modes? SQL Server offers three cube types MOLAP, HOLAP and ROLAP. In this tip we will look at response times for each of the different cube types.
Sometimes MySQL is more standards-compliant than PostgreSQL
(Peter Gulutzan) Here are examples comparing MySQL 5.6 against PostgreSQL 9.3 Core Distribution, where MySQL seems to comply with “standard SQL” more closely than PostgreSQL does.
Using jQuery Mobile and ASP.NET to Pass Data from one Page to another
(Mahesh Sabnis) ASP.NET developers working on either Web Forms or ASP.NET MVC can integrate jQuery Mobile into their Web sites to create rich mobile Web apps. jQuery Mobile is a lightweight JavaScript framework for developing cross-platform mobile/device Web applications.
APAR Friday: A change to the default value of a subsystem parameter
(Willie Favero) In keeping with my subsystem parameters discussions (AKA: DSNZPARMs), I came across an APAR that fits the theme perfectly. It also goes well with all the whining I do about being careful taking defaults.
Distributing tables evenly into groups using the SQL Model Clause
(Rob van Wijk) My colleague Ronald Rood recently had a nice SQL challenge for me. He had to perform an export of all the tables in a schema the old fashioned way and wanted to manually parallellize the operation. For that to work, all tables need to be assigned to a group.
XML and XSLT
(Christopher Keefer) Not terribly long ago, XML was the darling of the web. HTML4 was reformulated as XHTML 1.0, SOAP messages were XML, and let us not forget XMLHttpRequest.