-
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
-
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
-
June 4, 2014 by Kenneth Fisher
An identity column is an auto incrementing column An identity column is typically used as a primary key A primary …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL
| Tags: code language, language sql, microsoft sql server, sql statements, T-SQL
SQL Studies 