Planning of Database Structure & Organization – Part – 1 Introduction:- Every single information or data in the business attempts to be an entity or object. Forming a sole database requisite classifying the numerous entities or objects in addition to the networks that connect each of them. Once the entities or objects as well as the connections have been recognized,...
Other News
Get Ready to Learn SQL Server: 17. How to use the Intersect Operator
(Kris Wenzel) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database. You can get started using these free tools using my Guide Getting Started Using SQL Server.
Playing with the log – Before the first full backup
(Kenneth Fisher) The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log. So the other day I was asking about VLFs and got sent to this great video of a recorded session from PASS SQLRally Nordic 2013 by Mikael Wedham (b
HOWTO: Validate XML content against an XML Schema
(Marco Gralike) Somewhere 😉 on this site is a post regarding how to validate against an XML schema and although it is not incorrect, you should not use the method isXMLValid for validation.
Customize HTML5 Validation Messages In ASP.NET MVC
(Bipin Joshi) HTML5 allows you to put constraints on the data entered in form fields through several techniques. These techniques include new input types (such as email and url) and attributes such as required and pattern.
What is Angular Material Design and Why to use it?
(Shailendra Chauhan) It is Google’s new fancy UIs for the web. It is based on Google’s Material Design. As per Google, “Material Design is a specification for a unified system of visual, motion, and interaction design that adapts across different devices.
Extracting Audio Segments from a Song with Visual Basic
(Hannes Du Preez) I dare to say that no one loves music more than I. Music is literally my life and my job is my hobby. That is just how serious I am about music. Now, as an avid music lover, I always try to find new things to do to a song, and with Visual Basic, hence this article.
Retrieving Multiple RecordSets in a Single Trip to the Database
(Peter Vogel) I know that I keep going on about this, but: The best way to speed up your application is to retrieve all the data you need on each trip to the database and make as few trips to your database as you can. One way to do that when retrieving rows is to retrieve multiple sets of rows […]
What Day Is It If You Only Specify The Time?
(Martin Widlake) What is the date if you only specify the time when you populate an Oracle date column (or variable)?
Explain Plan ‘Notes’ in Oracle SQL Developer
(Jeff Smith) Oracle ACE Director, BI/data/all things cool and extraordinaire, Stewart Bryson had a bit of a complaint about our favorite tool today. He wants Explain Plans in SQL Developer to show the same notes you can see in SQL*Plus…
