SQL-Articles

Data Engineering – Learn from the experts

  • September 2013 UG Meet

    I was happy to inform you that finally we are back on track for September month user group meeting. Last month we got stuck up with so many things and one of the reason we aren’t able to proceed is that we got attacked and this site is almost down for 5 days.. It took…

  • Generate Users and Roles Script

    Couple of weeks back I wrote a script for generate object level permission in the database. People started requesting me to write a script which should script all the users and roles in a database. I came up with this script which will script roles and users in a database and it will also associate…

  • T-SQL Script to find the names of the StoredProcedure that has used dynamic SQL

    This article has the script that will be useful to find the names of the  Stored procedure that has used dynamic sql within the definition of the Stored procedure . In this post , I am creating a sample database with four stored procedures to show an example on how the script works :

  • Indirect Checkpoint – SQL Server 2012

    I noticed an interesting feature that’s released with SQL Server 2012. In this version now you can set recovery time at database level. In other words now you can set when checkpoint should happen to a database which directly relates to the recovery time of the database. Before stepping into further I would like to…

  • July 2013 UG

    We are in 3rd quarter of 2013 and we are continuing without hassles. This month we are scheduled on 20th so hope to see all the faces again. I could see some people are not registering for event which created issues with MS office securities. So from this time registration is mandatory, I require all…

Got any recommendations?

Get In Touch