Posts

SQL 2012 - Newly Introduced Date and Time Functions

As a SQL developer we are always keen to find and understand new features that microsoft releases with each new versions may be sql or anyother microsoft packages. The functions mentioned in below articles are some of the new T-SQL Date and time functions introduced in SQL 2012. This should help in redcuing time in writting some of complicated date time queries in a simple manner. DATETIME2FROMPARTS Building on the DATETIME2FROMPARTS offers more precise DateTime2 data type, It contains fractions of a second to a specified precision. This means the syntax for the function will accommodate additional parameters for fractions and precision. The syntax for this function is DATETIME2FROMPARTS (year, month, day, hour, minute, seconds, fractions, precision). SELECT DATETIME2FROMPARTS (2014, 02, 18, 14, 23, 44, 50, 2) AS MyDateValue MyDateValue 2014-02-18 14:23:44.50 DATETIMEFROMPARTS DATETIMEFROMPARTS is similar to DATEFROMPARTS, except it returns a DateTime value, and not
Post a Comment
Read more

another window on the way.. Windows 8…..

Image
Windows 8 is a future version of Microsoft Windows , a series of operating systems developed by Microsoft for use on computers and the likely successor to Windows 7 . Windows 8 is scheduled for 2012. Windows 8 is still in development. What is already certain is that Windows 8 will get native support for USB 3.0. Previous versions had separate driver 's installed. Furthermore, also the management of files changed: conflicts and file transfers are combined into one window. The transfer window will also detail a more comprehensive overview. Transfers will be paused. ISO files and virtual hard disks will stand as a virtual disk can be used. Windows Explorer gets a ribbon (ribbon) instead of a menu bar , just like in Microsoft Office 2007, 2010 , some programs from the Windows Live Essentials and Windows 7 versions of Word pad and Paint . The intention is that the tab"Home" the most used functions. The start menu also gets a review.  Windows 8 will also receive an app store
Post a Comment
Read more

and the humiliation ends…….

Image
India arrived in England as the top Test side in the world. They lost the marquee series 4-0, including two defeats by an innings. Cricket is a great leveler. For the past 21 months India had been the top Test team in the world. In April they became the world champions, lifting the World Cup after nearly three decades. Nothing could seemingly go wrong with this indisputably talented team with the best batting line-up in the world. Mahendra Singh Dhoni was the captain with the Midas touch, leading India to dominate the world of cricket in all formats of the game, including the fickle Twenty20. Staying on top was never going to be easy but Indian fans are shocked by the way India has capitulated to England during this dismal summer. It is not the players above the age of 36 (with the exception of Rahul Dravid, of course) who looked out of sorts; that decline was expected despite a nation being in denial.It is those in the early 30s, men who ought to be making the transition easier,
2 comments
Read more

Is this the end of corrupt Officials? Is India on a rise?

Kisan Hazare was born on 15 June 1937 in Bhingar , a small village near the city of Hinganghat, in Mumbai Province. Kisan's father, Baburao Hazare, worked as an unskilled labourer in Ayurveda Ashram Pharmacy. Kisan's grandfather was working for the army in Bhingar, when he was born. His grandfather died in 1945, but Baburao continued to stay at Bhingar. In 1952, Baburao resigned from his job and returned to his own village, Ralegan Siddhi. Kisan had six younger siblings and the family faced significant hardships. Kisan's childless aunt offered to look after him and his education, and took him to Mumbai. Kisan studied up to the seventh standard in Mumbai and then sought employment, due to the economic situation in his household. He started selling flowers at Dadar to support his family. He soon started his own shop and brought two of his brothers to Bombay.   What is Lokpal Bill? The Jan Lokpal Bill (Citizen’s ombudsman Bill) is a draft anti-corruption bill drawn up by
Post a Comment
Read more

Kashmir: le Paradis sur Terre

Image
Jammu & Kashmir (commonly referred to as "Kashmir") is situated in one of the most captivating and tumultuous geographical regions of the world. Jammu & Kashmir is centrally located between Pakistan, India, Tibet, China, and Afghanistan. Some one has once said that if there is any heaven on earth then it is in Kashmir. The beauty of this place can easily enchant the mind of any individual. The snowy mountains, lush green grasses, forest etc. together creates a memorable moment in the life of a person. And that is the reason why thousands of tourists are attracted towards this destination every year.Gulmarg, Sonmarg, Pahalgam are the most beautiful places in the Kashmir to watch. In the month of December and January, this place are covered with snow. Doing skiing  here is just fabulous or indulging into its world class Golf course. The Snowy Mountains and valley together creates a fabulous beauty. The forest region has its own distinct place in providing scope for ad
Post a Comment
Read more

It is paid cricket- Not cricket for Pride...

Image
I can't really remember how long ago it began but it seems months ago. I doubt the BCCI will consider constructive feedback about the duration of the event, but what they might do is listen to the fact that even in cricket mad India the public have got a little bit fatigued by too much cricket. Pubs have reported much lower audience for IPL matches and in some cases they've stopped showing the IPL. And the huge number of games means that the BCCI have made more money than last year from advertisers I hear, but is it significant that they've made less per advert? To be honest, the IPL 4 was a drag. Too many matches and way too long to even recollect good matches of the tournament. According to a recent report, the brand value of the IPL has fallen by 11%, while it had doubled last year. Currently, the IPL is valued at $3.67 billion, against last year's $4.13 billion (over Rs. 18,000/- crore). Keeping Modi factor aside, can the IPL survive in the longer run? It is
Post a Comment
Read more

MVC v/s MVP, which one’s your favorite?

Image
This is one of the most pretended question that comes  in technical interview and the way to look at it varies from condition to condition. When looking beyond the RAD (drag-drop and configure) way of building User Interfaces that many tools encourage you are likely to come across 2 design patterns called Model-View-Controller and Model-View-Presenter. MVC is a fundamental pattern which has been tweaked quite a bit to fit into various platforms. For instance if you had asked anybody how to implement an MVC in ASP.NET (prior to release of ASP.NET MVC framework) you would get very different answers. So let’s start with basic. The common motivation behind both is separation of concerns, cutting flab from UI (good for UI designers), swapping UIs (for instance windows to web), make UI easy for Unit Testing, etc. MVP Pattern Three components. But dependencies change (look at arrows in the diagram). Over here we replace Controller with Presenter (one which presents the changes done in
Post a Comment
Read more