(Pinal Dave) The In-Memory Database and In-Memory Caching market is heating up and we (the users) are the real winners. Exciting!!!

(Michael K. Campbell) The key takeaway from my presentation was that even if developers are totally committed to using object-relational mappers, or ORMs (because of the productivity benefits they provide), it’s still worthwhile to assume or anticipate that if/when your application becomes very succ

(Sergio Govoni) Column store indexes had been released with SQL Server 2012 to optimize data warehouse workloads that have specific patterns, data are loaded through T-SQL scripts or through SSIS packages, several times a day, in any case the frequency is not important, only that the available data

(Kenneth Fisher) Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the most frequent example where I see this but I do see it elsewhere as well and it’s very easy to make a simple mistake.

(Koen Verbeeck) Microsoft recently released the OData source adaptor for Integration Services (SSIS). Using this source component, it becomes really straightforward to read data from OData sources, such as SharePoint lists. This tip will walk you through the installation and configuration of this br

(Kalen Delaney) Way long ago, when Sybase first added the IDENTITY property, it took people quite a while to get the hang of using it. Along with being able to automatically generate sequential numbers for each row, we had to tune a configuration option with the geekiest of names: “Identity Burning

(Hareesh Gottipati) In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the number of processors and up to a maximum of 8.

(Robert Sheldon) There are some aspects of tables in SQL Server that a lot of people get wrong, purely because they seem so obvious that one feels embarrassed about asking questions.

(Pinal Dave) Recently, while working on a demo about backup, I realized that in management studio, now there is a new option in the backup screen called a URL. This feature is called as “backup to URL”.

(Tim Smith) We recently faced an issue with an internal data provider where we imported a flat file at 1AM, but in the past few months, the data provider began providing an incomplete or inaccurate file because it lacked the proper length (or didn’t exceed a certain size).