-
November 17, 2014 by Kenneth Fisher
We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
Continue reading
Category: Central Management Server, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: Central Management Server, CMS, code language, language sql, microsoft sql server, sql statements, SSMS, T-SQL
-
November 11, 2014 by Kenneth Fisher
What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL Tuesday
| Tags: code language, database permissions, language sql, microsoft sql server, security, server permissions, T-SQL, T-SQL Tuesday
-
September 22, 2014 by Kenneth Fisher
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that …
Continue reading
Category: Microsoft SQL Server, Settings, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, instance settings, language sql, microsoft sql server, system functions, T-SQL
-
September 17, 2014 by Kenneth Fisher
For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, language sql, microsoft sql server, sql statements, T-SQL, triggers
-
September 11, 2014 by Kenneth Fisher
Trace flags are one of those things that I’ve heard about more and more over the last five or six …
Continue reading
Category: Microsoft SQL Server, Settings, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, language sql, microsoft sql server, system functions, T-SQL, trace flags
-
September 2, 2014 by Kenneth Fisher
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
Continue reading
Category: Microsoft SQL Server, Performance, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, language sql, microsoft sql server, Performance, T-SQL
-
August 14, 2014 by Kenneth Fisher
If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, language sql, microsoft sql server, sql statements, system functions, 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 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
-
May 19, 2014 by Kenneth Fisher
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, SSMS, System Functions and Stored Procedures, T-SQL
| Tags: code language, DAC, language sql, logon triggers, microsoft sql server, sql statements, sqlcmd, SSMS, system functions, T-SQL
SQL Studies 