List all Usernames, Roles for all the databases.
Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).
2013-12-30 (first published: 2008-07-24)
34,256 reads
Shiva
Remove comments from the SQL Code
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
1,982 reads
Create Role for specific set of Objects based on a set of Conditions.
This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.
2008-10-08 (first published: 2008-07-23)
1,124 reads
Blogs
Ethics in Modern Data this Saturday with the South Florida Data Geeks
By Will Assaf
This Saturday Aug 7, Christine and I will present our joint presentation on Ethics...
3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution
By kleegeek
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...
The PowerBI Volleyball Report – Organizing Data To Start
By Steve Jones
One of my goals this year was to build a report that I can...
Forums
Minimun Role Permissions Needed
Hi Friends, Please some guidance, To import a bacpac file in a MI instance,...
Need counts of payment amounts per week grouped by week
Hello, I have a code that suppose to give me weekly(summed) payments, but instead,...
Import CSV Data Into Existing Tables
Hi Guys, I am having issues trying to import data from CSV files into...
Ask SSC