-
August 18, 2014 by Kenneth Fisher
In order to speed up our backups on a large database our team decided to stripe the backup files. In …
Continue reading
Category: Backups, Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication
| Tags: backups, dynamic sql, language sql, microsoft sql server
-
June 23, 2014 by Kenneth Fisher
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures …
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
-
January 15, 2014 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
-
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
SQL Studies 