(Richard Carr) The ninety-fifth part of the Windows Presentation Foundation Fundamentals tutorial continues the examination of data binding. This article considers the values assigned to properties when a binding operation fails.
Other News
Linq Without SQL Engines
I’ve been using Linq a lot lately demonstrating set operations that were exclusively SQL work for me in the past. However, now I am working with a lot of data that does not come from a relational data store, and libraries such as Entity Framework have no impact on my work. I am gather sets of data from a multitude […]
Database Design Interview Questions
Database Design Interview Questions Author: Basit A. Farooq In this article, we will outline questions suitable for a Database Developer/Database Analyst interview to assess the candidates skills related to database design. Question 1: What is Database Management System (DBMS)? Answer: The software that manages the storage and access to the data in the databases. Question 2: Describe the main phases...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
The Road to MySQL 5.6: Default Options
(Gavin Towey) When you’re testing out a new version of MySQL in a non-production environment there is a temptation to go wild and turn on all kinds of new features. Especially if you’re reading the changelogs or the manual and scanning through options.
Demystifying Oracle Unpivot
(Scott Wesley) A couple of years ago I posted a simple example using PIVOT, converting rows to columns with the classic example of figures by months.
Non-English Character Display in Oracle SQL Developer
(Jeff Smith) I get a variation on this question at least once a week, if not more frequently.
Wrapping SQL*Plus
(Michael McLaughlin) One annoying thing from installing Oracle Database 11g on Fedora, was that the up arrows for command history didn’t work. I decided to fix that today after seeing Lutz Hartmann’s article on rlwrap. Unfortunately, the epel (Extra Packages for Enterprise Linux) package he recommen
Creation & Deletion of Database Snapshot by SQL Agent Job
(Rohit Garg) Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear that It can be done very easily.
#0346 – SQL Server – Using CASE with a PRINT statement
(Nakul Vachhrajani) Informational and alert messages during execution of a T-SQL script are the most preferred method to update the user on the progress of the task being executed. These messages are generated by the various PRINT statements embedded in the script.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
(Pinal Dave) Yesterday we discussed about the Basics of Delayed Durability in SQL Server 2014. Today we will learn one more topic about this subject – How to Setup Delayed Durability for SQL Server 2014?