-
June 3, 2015 by Kenneth Fisher
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, Upgrades
|
Tags: microsoft sql server, orphans, security, upgrades
-
May 28, 2015 by Kenneth Fisher
A question came up at work the other day, mostly as a mind game, but you never know it might …
Continue reading
Category: Microsoft SQL Server, Security, Settings
|
Tags: database settings, default settings, microsoft sql server, security
-
May 20, 2015 by Kenneth Fisher
I do a lot of testing with security in SQL Server. And of course to do a thorough job of …
Continue reading
Category: Security, SQLServerPedia Syndication
|
Tags: command shell, security
-
April 20, 2015 by Kenneth Fisher
To be fair it’s not actually hidden, just not so well known. Have you ever wondered how to grant permissions …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication
|
Tags: microsoft sql server, roles, security
-
March 23, 2015 by Kenneth Fisher
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I …
Continue reading
Category: Microsoft SQL Server, Security, Speaking, SQLServerPedia Syndication
|
Tags: microsoft sql server, security, speaking
-
February 25, 2015 by Kenneth Fisher
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
Continue reading
Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL
|
Tags: code language, database permissions, DMV, dynamic sql, language sql, microsoft sql server, security, server permissions, system functions, T-SQL
-
February 12, 2015 by Kenneth Fisher
When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL Tuesday
|
Tags: security, T-SQL Tuesday
-
February 10, 2015 by Kenneth Fisher
So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL Tuesday
|
Tags: database permissions, microsoft sql server, security
-
February 3, 2015 by Kenneth Fisher
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought …
Continue reading
Category: Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL Tuesday
|
Tags: Adam Machanic, microsoft sql server, security, T-SQL Tuesday
-
January 12, 2015 by Kenneth Fisher
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I …
Continue reading
Category: Microsoft SQL Server, Security, SQL Hangout, SQLServerPedia Syndication
|
Tags: Boris Hristov, database permissions, microsoft sql server, security, server permissions, SQL Hangout
