(Pinal Dave) There are several ways to know the version of SQL Server. But did you know that there are two system procedures through which you can know the version? They are SP_SERVER_INFO and EXEC XP_MSVER

(Ed Elliott) I use SSDT and tSQLt in my work and I am always interested in productivity tools to help speed up development and make it more streamlined, if there is something that can help us develop better or faster then we should use it.

(Robert Biddle) For data synchronization projects, using rowversion is a very effective method for detecting changes. In order to work with the rowversion properly, we would need to either use @@DBTS or the function min_active_rowversion. Understanding the differences between these values will help

(Adam Aspin) For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics of the target device.

(Arshad Ali) We often need to combine two or more string values to use this combined string value in reporting. Although there was a way to do that in earlier versions of SQL Server, starting with SQL Server 2012 we have CONCAT function for this specific situation. This T-SQL function also takes car

(Paul White) Read uncommitted is the weakest of the four transaction isolation levels defined in the SQL Standard (and of the six implemented in SQL Server). It allows all three so-called “concurrency phenomena”, dirty reads, non-repeatable reads, and phantoms:

(Pinal Dave) I am a big time advocate of some common best practices that I see in the industry. These have been ingrained into every session that I do be it SQL Server, MySQL or any other databases.

(Jeremy Kadlec) Being able to identify SQL Server performance issues at the drop of a hat is easier said than done. Without a means to collect and analyze the performance data it is difficult at best to understand and correct the items in a timely manner.

(Kalen Delaney) In my class in Budapest last week, someone asked if point-in-time recovery was supported for transactions on memory-optimized tables. I couldn’t think of a reason why not, but I had never tried it. And just because there is not a technical inhibitor to allow certain functionality, i

(Dennes Torres) I’m from the age when sp_help and it’s variants could give to us almost any information about the database objects.