Introduction SQL 2016 has brought in lots of new and exciting features on the plate. One of the pretty cool feature that was added to SSIS in SQL 2016 is the ability to expose the data directly as a SQLServer…
SQL Server 2016 Available for General Availability Now
SQL 2016 has been released for general availability now You can find the download links from MSDN The evaluation period is for 180 days https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 SQL 2016 comes with lots of useful and cool features including Native JSON support Always…
T-SQL Tips: Can a UDF Return Values of Multiple Datatypes?
This was a question raised in one of the forums recently.This blog explains how we can create a user defined function (UDF) which can return values of different datatypes under different conditions.Consider the case where we require creating a user…
Power BI Tips: Creating a Map Visualization in Power BI
Introduction This blog explains how you can create a map visualization based report in Power BI desktop. Map visualization is one of the cool features that Power BI provides for doing analysis based on geographical locations. Its pretty useful tool…
Windows Build 2016 : Live Streaming
Here’s a golden opportunity to watch the live streaming of the Microsoft Build 2016 Conference here for those whose are unable to attend. Microsoft Build is an annual conference event held by Microsoft for Developers. And this year its being held from March…
Guest Post: Variant Disaster Recovery Plans in SQL Server 2008
Andrew Jackson one of the fellow SQL professionals had expressed his desire to write a guest blog for me. Here’s the guest post contributed by him on Disaster Recovery Plans One of the foremost responsibility of a SQL Server administrator is…
My Interview Published on Technet Wiki
Glad to share with you all the news that my Technet Wiki had interviewed me and they’ve posted the interview on their official blogs. The link is given below http://blogs.technet.com/b/wikininjas/archive/2016/02/22/interview-with-a-wiki-ninja-visakh16-a-sql-server-mvp-microsoft-partner-amp-mcc.aspx Really feeling nice getting this motivation from Microsoft and being…
Identification and Application of Retrospective Changes Done in Databases
Introduction One of the common scenarios that we have come across during the course of every project life cycle is the need to identify the changes done retrospectively and revert them. This usually happens during subsequent phases of the project…
T-SQL Tips: OFFSET Without FETCH i.e. Skipping Rows in Resultset
Introduction The purpose of this blog is to provide an answer to the below two questions Can we use OFFSET without FETCH in T-SQL? How can we skip some rows while returning a resultset through SQL query? The above questions…
T-SQL Tips: Aggregate Functions in CASE Expressions
Impetus The impetus for this blog comes from a recent discussion that happened in one of the forums of which I’m a member. There was a question asked by one of the fellow members regarding an error he was getting…