(Marcin Policht) In our recent articles published on this forum we have been discussing characteristics of the Microsoft Azure SQL Database offering. So far, we have been dedicating our attention to the process of its deployments (mainly by importing schema and data from an on-premises environment)
Other News
Optimising MDX Calculations With The Unorder() Function
(Chris Webb) The Unorder() function is probably one of the least used functions in the whole of MDX. It exists only as a query performance hint and, since I had never up to now found a scenario where it did improve the performance of a calculation I had pretty much forgotten about it (as Books Onlin
SQL SERVER – SSMS: Schema Change History Report
(Pinal Dave) The heat is picking up and I am glad you are liking this series going so far. This particular report is close to my heart and the most recommended. At my recent trip to Delhi and the user group out there, I had the opportunity to meet a number of young DBA’s who were getting into their
Implement a SQL Server HA failover solution without shared storage
(Greg Robidoux) One of the primary duties for a SQL Server DBA is to ensure that the database server stays online without causing disruption to users. DBAs do all types of things to improve performance, such as using new indexing strategies, maintaining indexes, optimizing code, and separating data
Promise of Backward Compatibility
I was reading an advertisement in the Oracle magazine the other day where they were using backward capability as a valuable feature of the Spark/Solaris product line. If I understood this correctly, they were promising lack of obsolescence should you choose to move to a new platform Your older versions of software would continue to run. This caught my attention, […]
Is Your SharePoint Installation In Need of a Brush-Up?
Is Your SharePoint Installation In Need of a Brush-Up? The interesting thing is that many companies are using SharePoint for their own systems and to facilitate collaboration and all of the great things you can gain from a rock-solid SharePoint installation. Turns out a majority of companies have installations of SharePoint, but many aren’t quite there yet on getting what […]
HTML 5 Web SQL Database
(Sourabh Somani) Web SQL is very interesting feature, even though it isn’t part of the HTML 5 specification. But it is a separate specification and it can still help for developing web applications. Web SQL is used to manipulate a client-side database.
Using a custom domain for my Bluemix Python-based weather app
(Henrik Loeser) Last week I played with IBM Bluemix, Python, and JSON to deploy a (very) simple weather application. Now, as an enhancement, I wanted to use my own subdomain for that app. I succeeded, here is how.
External Table Access
(Michael McLaughlin) I left to chance where students would attempt to place their external files in a Linux or Unix implementation. As frequently occurs, they choose a location in their student user’s home directory. Any attempt to read an external table based on a file in this type of directory fai
MySQL: Extracting timstamp and MAC address from UUIDs
(Roland Bouman) I recently overheard a statement about whether to use auto-incrementing id’s (i.e, a sequence managed by the RDBMS) or universal unique identifiers (UUIDs) as method for generating surrogate key values.