Category Archives: Learn SQL Server

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

Publishing 100th Blog on LearnSQLWithBru

Posted on by
Reply

Today, I am happy to share that I am writing my 100th blog on www.LearnSQLWithBru.com. On this note, I would like to personally thank all the readers who have been visiting this blog. I would also like to thank my wife Tripura Medishetty, who has always taken care of me and without her support, I would not have dedicated a ton of hours towards my blog and this website.

My primary goal in writing these blogs, is to share what I continuously learn and help readers to learn at least one single topic in SQL Server by reading my blog posts. I hope I have not disappointed my readers. Having said that I am looking forward to write more often in the future and cover as many areas and topics as possible on SQL Server. If you have been following this site, we recently started a new section called Learn SQL Server, which will focus on teaching SQL Server to first time users.

Apart from writing regular blog posts on this site, I am also planning to write more beginner topics as part of our new section Learn SQL Server for Beginners. Re-start the daily SQL dose, (SQL Tidbits, from Jan 1st 2012) and also expand sections under Learn SQL Server, for Mid-level and Advanced SQL users and so on……

As always, I seek your feedback and comments on what new sections / areas can make this site better.. 

— Bru Medishetty