-
November 4, 2013 by Kenneth Fisher
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, database permissions, dynamic sql, language sql, microsoft sql server, security, server permissions
-
August 19, 2013 by Kenneth Fisher
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: code language, dynamic sql, language sql, microsoft sql server, security, T-SQL
-
August 14, 2013 by Kenneth Fisher
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: database permissions, dynamic sql, language sql, microsoft sql server, security, system functions
-
July 22, 2013 by Kenneth Fisher
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, dynamic sql, language sql, microsoft sql server, system functions, T-SQL
-
July 1, 2013 by Kenneth Fisher
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: code language, dynamic sql, language sql, microsoft sql server, sql statements, T-SQL
-
June 12, 2013 by Kenneth Fisher
Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: best practices, code language, dynamic sql, language sql, microsoft sql server, sql statements, T-SQL
-
May 30, 2013 by Kenneth Fisher
A couple of months ago I talked about moving a login from one server to another without the password. The …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
| Tags: code language, dynamic sql, language sql, microsoft sql server, security, sql statements, T-SQL
-
April 8, 2013 by Kenneth Fisher
I see this question in one form or another a lot. I’ve seen this or something like it probably half …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: code language, dynamic sql, language sql, microsoft sql server, split function, sql statements, T-SQL
-
February 25, 2013 by Kenneth Fisher
When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: code language, dynamic sql, language sql, microsoft sql server, sql statements, T-SQL
-
December 17, 2012 by Kenneth Fisher
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: code language, dynamic sql, language sql, microsoft sql server, sql statements, T-SQL