Getting started with SSDT – SQL Server Data Tools

Posted on by
8

If you are looking for BIDS (Business Intelligence Development Studio) in SQL Server 2012, then you will not find it. It is replaced with SQL Server Data Tools (SSDT) in SQL Server 2012. In this blog we shall take a sneak peek at how to open SSDT and create a new project.

Go to start -> Microsoft SQL Server 2012 (in this case it is RC0), but in final release, it will not be there, so I mentioned the general term.  If you have chosen to to Install SSDT while installing SQL Server 2012 on the machine, you should see SQL Server Data Tools as shown below. Click to open SSDT.

When you are using SSDT for the first time, this screen is displayed, where you are requested to choose which Environment settings would you be using. Select Business Intelligence Settings as shown below and click, Start Visual Studio.

In order to create a new Project click on New Project as shown below.

Then, a new Project dialog box appears where you can select what kind of Project that you would like to create. Once you have selected the type of project, you can enter the name of the project and click OK to start creating your choice of project.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

What are SQL Server Developer Responsibilities?

Posted on by
15

Couple of weeks back I published What are SQL Server DBA Responsibilities? After that blog, while I was writing notes for the section Learn SQL Server, I thought, why not post a blog that lists out the responsibilities of a SQL Server Developer too.This would also complete the topic of what responsibilities of these 2 positions (DBA and Developer) under my new section Learn SQL Server.

  • Create Entity Relationship (ER) Diagrams to the proposed database
  • Create database objects such as tables, views, stored procedures, Triggers etc.
  • Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
  • Identify columns for Primary Keys in all the tables at the design time and create them.
  • Create functions to provide custom functionality as per the requirements.
  • Be aware of potential blocking, deadlocking and write code to avoid those situations.
  • Endure that the code is written keeping in mind any security issues such as SQL Injection.
  • Develop reports in SQL Server Reporting Services.
  • Design, Develop and Deploy SSIS Packages.
  • Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
  • participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
  • Participate in development and creation of Data warehouses.
  • Create cubes in SQL Server Analysis Services.

Since I primarily work as a SQL Server Database Admin, I might not be able to give an exhaustive list covering all responsibilities of a SQL Server Developer. If you feel something is missing, please feel free to post a comment.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

Square – Mathematical function in SQL Server

Posted on by
Reply

In this blog post we shall learn a mathematical function in SQL Server called Square. This function expects 1 value to be passed and returns the multiplied value itself nothing but the square of the passed value. 

The function expects a value of float data type to be passed. Any other data types, such as an integer will be implicitly converted into a float value. See that the function treats 10 (integer) and 120.59 (float) as float and returns the expected square values..

If the passed value is a integer or a float value with quotes, then that is also converted into a float. See that the function converts ‘120.5’ to float 120.5 without issues.

When the value passed is a datetime or string characters (a – z) or special characters, the could not be converted to float, the function returns an error. See the error below, where ‘abcd’ is passed to the function.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty