-
November 27, 2013 by Kenneth Fisher
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, SSIS, System Functions and Stored Procedures, T-SQL
| Tags: code language, DTS, language sql, microsoft sql server, sql statements, SSIS, system functions, T-SQL
-
November 25, 2013 by Kenneth Fisher
You know I occasionally find it interesting how I learn new things. I was running through a practice test for …
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
-
November 11, 2013 by Kenneth Fisher
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a …
Continue reading
Category: Index, Microsoft SQL Server, Pass, Performance, Query Plans, SQLServerPedia Syndication, System Functions and Stored Procedures
| Tags: microsoft sql server, Performance, system functions, XML, xQuery
-
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
-
September 26, 2013 by Kenneth Fisher
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL …
Continue reading
Category: Microsoft SQL Server, SQLServerPedia Syndication, SSMS, System Functions and Stored Procedures, T-SQL
| Tags: code language, microsoft sql server, sql statements, SSMS, system functions, T-SQL
-
September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: language sql, microsoft sql server, security, system functions, T-SQL
-
September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: language sql, microsoft sql server, security, system functions
-
September 5, 2013 by Kenneth Fisher
I recently had the task of collecting job activity for the purposes of turning it into a report for some …
Continue reading
Category: Microsoft SQL Server, SQL Agent Jobs, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, language sql, microsoft sql server, problem resolution, SQL Agent Jobs, sql statements, 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
-
August 5, 2013 by Kenneth Fisher
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL
| Tags: code language, language sql, microsoft sql server, principals, security, sql statements, T-SQL, users
SQL Studies 