-
July 10, 2014 by Kenneth Fisher
If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
Continue reading
Category: Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication, SSMS
| Tags: database permissions, microsoft sql server, problem resolution, security, SSMS
-
July 8, 2014 by Kenneth Fisher
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
Continue reading
Category: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, T-SQL Tuesday
| Tags: problem resolution, T-SQL Tuesday
-
July 2, 2014 by Kenneth Fisher
Early yesterday Kirsten Benzel(b/t) announced something very exciting, at least exciting to me. Argenis Fernandez(b/t) has agreed to wear a …
Continue reading
Category: DBA Humor, Microsoft SQL Server, Pass
| Tags: #sqlfamily, Humor, Pass
-
June 30, 2014 by Kenneth Fisher
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work …
Continue reading
Category: Documentation, Microsoft SQL Server, SQLServerPedia Syndication
| Tags: BOL, Documentation, microsoft sql server
-
June 25, 2014 by Kenneth Fisher
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: code language, language sql, microsoft sql server, strings, T-SQL
-
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
-
June 18, 2014 by Kenneth Fisher
Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication
| Tags: alias, microsoft sql server
-
June 16, 2014 by Kenneth Fisher
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: microsoft sql server, object permissions, schema permissions, security
-
June 12, 2014 by Kenneth Fisher
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures
| Tags: default trace, microsoft sql server, system functions
-
June 9, 2014 by Kenneth Fisher
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me …
Continue reading
Category: Blogging, Documentation, Microsoft SQL Server, SQLServerPedia Syndication
| Tags: blogging, Documentation