(Lukas Eder) SQL Server is known to have a very strict interpretation of the SQL standard. For instance, the following expressions or statements are not possible in SQL Server:
Other News
Connecting to an Oracle Database from SQL Server and Microsoft BI Tools
(Tyler Chessman) When it comes to relational databases, most organizations run heterogeneous environments. SQL Server DBAs, IT professionals, and business intelligence (BI) practitioners will likely need to connect to an Oracle database at some point in their career.
Geek City: The Hekaton Saga Continues, and some answers to questions
(Kalen Delaney) My Hekaton (aka In-memory OLTP) books is with the publisher. And I have no doubt they will do a much better job than my previous publisher did in bringing my SQL Server 2012 Internals Book into the light of day.
Logging with the .NET backend for Azure Mobile Services
(Carlos Figueira) On the node.js version of mobile services, logging was done mostly via the node’s console object. In any of the server scripts you could call console.[log|warn|error] and when that script was executed you could go to the “logs” tab in the portal to see them.
3 More Ways to Improve Database I/O Performance
(Dave Beulke) As I talked about last week, the application and database performance involves constantly analyzing different DB2 I/O aspects of your environment. By analyzing the DB2 I/O reports you’ll discover there are many different aspects to examine to optimize your environment, application work
Data Security in the Cloud – Part #4
(Walid Rjaibi) In the previous blog entry we stated that the overall responsibility for security is shared between the cloud service provider and the client. Then, we covered the responsibilities of the cloud service provider. This new blog entry discusses the responsibilities of the client.
Four Steps to Data Security in the Cloud
(Sudhee Subrahmanya) The infamous bank robber Willie Sutton is often quoted as saying that criminals go after banks because “that is where the money is.” Whatever the source, the intended meaning is of course that thieves try to steal wherever things of value are located.
Why I consider USING harmful
(Marko Tiikkaja) Often on the topic of the different JOIN syntaxes in SQL I mention that I consider ON the only reasonable way to specify JOIN clauses in production code, and I get asked for details. It always takes me a while to recall the specific problem and to come up with a plausible scenario,
How To Add Custom Actions To Your User Reports
(Jeff Smith) I’ve shown you and more than a few customers how to customize your Monitor Sessions page/report. If you need a refresher, that’s here.
RAC 12c enhancements: adding an additional SCAN-part 2
(Martin Bach) In the first part of this article you could read how to add an additional network resource, additional VIPs and SCAN to an 12.1.0.1.2 cluster. In this part I hope to show you the next steps such as adding the SCAN listeners and other resources.