Pinterest • The world’s catalog of ideas

Sql Year

SQL in the City ishappening virtually this year

Azure SQL Database Now Supports Backup Retention for 10 Years: Microsoft announced that the backup retention of Azure SQL Database has been…

Refactoring T-SQL with Windowing Functions - You've been querying comparative numbers like Year To Date and Same Period Last Year by using tedious CTEs and subqueries. Beginning with SQL Server 2012, getting these numbers is easier than ever! Join Doug for a 30-minute T-SQL tune-up using window functions that will cut down dramatically on the amount of code you need to write.

1

Azure SQL Database: Now supporting up to 10 years of Backup Retention (Public Preview) https://azure.microsoft.com/de-de/blog/azure-sql-database-now-supporting-up-to-10-years-of-backup-retention-public-preview

1

A day after announcing it would be bringing SQL Server to Linux, Microsoft has announced that it is joining the Eclipse Foundation, an open source community for developers launched more than 10 years ago.

How to manage year expiration date in database ? | The ASP.NET Forums

Sql Server: Query to Get Age in Years, Months and Days from Date of Birth field http://www.webcodeexpert.com/2016/07/sql-server-query-to-get-age-in-years.html In this article I am going to explain how to calculate age in year, month and day from the Date of Birth(DOB) field.

So many times I have been asked for help with a query, where the questoin really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and…Read more ›

394
45

So many times I have been asked for help with a query, where the questoin really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and…Read more ›

1
3
from ReadWrite

How Cloud Computing Democratizes Big Data

Do You Need Big Data? Is Big Data right for your company? The first question any firm must ask is if they will benefit from Big Data analysis. Begin by understanding the data sets available to you. Analysis of 20 years of stock closing prices, for example, would not likely require the power of Big Data systems. Given the relatively small size of this dataset, analysis can, and probably should, be performed using SQL or even simply Excel.