-
July 23, 2014 by Kenneth Fisher
This may seem like a question with a simple answer but there is a bit more to it than you …
Continue reading
Category: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, T-SQL
| Tags: code language, language sql, microsoft sql server, problem resolution, sql statements, T-SQL
-
July 21, 2014 by Kenneth Fisher
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
| Tags: microsoft sql server, role, security
-
July 14, 2014 by Kenneth Fisher
Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: code language, Grant Fritchey, language sql, microsoft sql server, NULL, Thomas LaRock
-
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
-
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
SQL Studies 