(Deanna Dicken) SQL Server 2012 introduces three new built-in conversion functions: PARSE, TRY_ PARSE, and TRY_CONVERT. These functions were introduced to be more familiar to users of expression languages. They perform a subset of the functionality of the pre-existing conversion functions. This arti
Other News
SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer
(Pinal Dave) A CTE can be thought of as a temporary result set and are similar to a derived table in that it is not stored as an object and lasts only for the duration of the query.
SharePoint: Sites vs. Site Collections
(Neil Barkhina) Part of being a SharePoint solutions architect means designing a solution based on technical, maintenance and governance requirements. One of the most important initial design questions is whether to recommend Sites or Site Collections for a solution.
Insert Value From CheckBox in Database (MySQL) in PHP
(Vineet Kumar Saini) In the last article you saw how to insert a value from a radio button in the MySQL database in PHP. Now in this article you will see how to insert a value from a checkbox in the MySQL database. Using a checkbox you can insert multiple values in the MySQL database in PHP.
Common Pitfalls of jQuery
(peter_olson) jQuery is a wonderful library that makes web development with JavaScript a much better experience–but there are some common pitfalls that you should avoid.
Configure automatic maintenance in DB2 for Linux, UNIX, and Windows using IBM Data Studio
(Arvind Gupta) The automatic maintenance capabilities of IBM DB2 for Linux, UNIX, and Windows relieves DBAs so they can focus on other vital tasks, such as maximizing performance. This article demonstrates how to configure automatic maintenance capabilities in DB2 for performing database backups, ke
CLR in Azure
SSWUGtv With Stephen Wynkoop In this episode Steve takes on the difficult task of cleaning data. Do you clean it first and then bring it in? Do you bring it in and then cleanse it. How about transforming data to fit your schema. Watch as Steve interviews key players in the data cleansing world. Watch the Show CLR in Azure […]
Should You Use CLR Capabilities?
Should You Use CLR Capabilities? My particular question about CLR capabilities is that I have enjoyed using them for years. Now, considering the utilization of Azure I find they are not available. The reason, you don’t have direct access to disk subsystems in the Azure world, and CLR assemblies require a path in order to work. Sounds like a broken […]
Introducing Developers to XQuery in MarkLogic
(Dave) In the last few month’s I have helped a number of developers enter the world of XQuery. Here are the first three websites that I point people to on their first day as well as some discussions on sequences and FWLOR statements that often occur.
Deferred Segment Creation Quirks
(Alex Fatkulin) If you have a habit, as I do, to quickly check dba_segments to make sure there is nothing important in the tablespace you are about to drop then deferred segment creation can present some surprises. Consider the following: