Categories
CSSUG

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 long hours for me to go through all the codes and then bring back the website… I’m happy that we are refreshed with new theme and gong forward you can expect frequent updates in this website.

Categories
Scripts

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 user with their roles.

Categories
Scripts

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 :

Categories
General

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 explain you what’s recovery time and how does it matter in recovery situation.

Categories
CSSUG

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 the participants to register for this event. I need to provide the participant list to them, only those folks are allowed inside the campus.