To find out which SQL Server Version you are running on, use the following TSQL Statement –
Of late I am working most of my time in SQL Environment as a Data Architect (even though I prefer most of the time to work on ASP.Net Web stack, due to some unprecedented work challenges I took Project Manager responsibilities. As a PM most of my work goes out through Excel and Outlook, but I don’t want to get away from being a developer. So I immediately opted for being a SQL Dev along with PM, alongside I code for some C# components for my dev team). I am excited working with SQL Server, especially with TSQL. So I started out rolling on very basic concepts on “HOW DO I” and wanted to share some of my routine findings with all my readers. As a result “SQL Server” tag landed up in my tag Cloud.
Most of the tutorials under this tag are going to be very basic (my learning experiences and code). As time moves on I would be shedding some complex stored procedures and data models of my interest. In last 3 months of time, I came across very valuable topics in Data world with some very famous tools. My future articles are going to cover some of them with very specific examples.
I hereby convey to all my readers, that most of the tutorials in this particular tag are going to be very quick, short and basic. They are outcomes of my day to day learning. There can be many ways to solve the problems in any technology, based on the that I would always try to advocate mostly best practices and performance oriented solutions. Please use some of the SQL which I will be narrating with care in your personal/work purposes.