(Manoj Pandey) With SQL Server 2016 now you can configure the number of TempDB Database Files during the installation of a new Instance. While installation process in the Database Engine Configuration page you will see an extra option to set number of TempDB files.

(derekewilson) One of the features in SQL Server 2016 that you will want to explore is the ability to store your historical data in the Azure cloud.

(Ed Elliott) I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one 2008. The 2012 project referenced the 2008 project as a “this database” reference and while this seemed like it worked, the reference in solution explorer had a little warning sign and

(Manoj Pandey) With SQL Server 2016 now you can configure the number of TempDB Database Files during the installation of a new Instance. While installation process in the Database Engine Configuration page you will see an extra option to set number of TempDB files.

(Richard Carr) SQL Server includes a number of system stored procedures that allow information to be obtained about the server or instance. One useful stored procedure is sp_Databases, which returns a list of the available databases.

(Derek Dieter) There are two different functions that can be used when converting an integer to a string. One is CAST and the other is CONVERT. Either of these functions can be used with the exact same result when converting to a string.

(Pinal Dave) I play and experiment with SQL Server to the max. Sometimes I am not sure what I did and I land into something undesired. Then the reason to troubleshoot starts and I get to learn something new.

(Richard Carr) SQL Server includes a number of system stored procedures that allow information to be obtained about the server or instance. One useful stored procedure is sp_Databases, which returns a list of the available databases.

(Derek Dieter) There are two different functions that can be used when converting an integer to a string. One is CAST and the other is CONVERT. Either of these functions can be used with the exact same result when converting to a string.

(Pinal Dave) I play and experiment with SQL Server to the max. Sometimes I am not sure what I did and I land into something undesired. Then the reason to troubleshoot starts and I get to learn something new.