(Richard Vantrease) You have been asked to deploy a brand new SQL Server instance. Your management asks you to come up with the best balance of availability, performance and cost for SQL Server. What do you recommend?
Other News
Where Do You Put Your Unstructured Data?
SQL Server introduced the XML data type in the 2005 release resulting in a lot of power when dealing with both XML data and native SQL. The engine even has the ability to validate XML against a schema, shard the data so that it can be indexed, and included XPath and XQuery syntax for searching XML data quickly and efficiently. […]
What Do You Think of Hybrid Environments?
What Do You Think of Hybrid Environments? I have been working with several different people setting up hybrid environments. With pieces on-premise, and pieces in the cloud, it gets pretty interesting very quickly. There are a number of things I’ve learned, and one ruling that has just been issued certainly weighs heavily on configuration thoughts. First, something that is becoming […]
SQL Server Backup Encryption
(Denny Cherry) With the release of Microsoft SQL Server 2014, we have the first version of SQL Server that supports encrypting database backups directly from the database engine without any third party software being installed on the SQL Server.
Post all form fields to PHP using jQuery
(Mick Redman) The example below simplifies the process of simply passing all HTML form data to a PHP script (or any other HTTP handler), obviously without a refresh. Below that are a couple of suggestions on how the jQuery and PHP could be improved beyond the simplified versions.
The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 1–10)
(Iggy Fernandez) On the Toad World site, I’m writing a series of blog posts and 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.
Progress Bar in HTML 5
(Sourabh Somani) This article explains the HTML 5 progress bar and how to create it.
Time Selector for ADF Graph and Data Filtering
(Andrejus Baranovskis) ADF graph with date/time data in X axis, could be configured with time selection and scrolling functionality. This could be very useful for such use cases, where we want to analyse specific set of data in the selected period of time.
How to Generate Schema DDL Scripts with One File Per Table using SQL Developer
(Jeff Smith) A VERY specific request this morning:
Securing connectivity between WebSphere Cast Iron Database connector and a database
(Vinod A. Valecha) This article describes how to configure a Database connector in WebSphere Cast Iron Studio for secure SSL connection, how to import secure certificates from a DB2 database, and how to execute the orchestration securely.