Posts Tagged: SQL Server

Padlock

Security Questions: Grant Permissions to All Stored Procedures

Posted by & filed under , , , , .

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.  Instead of just a re-cap of all of the questions, instead I’ve opted to put together a post per topic.  Hopefully, this will [...]

Padlock

Security Questions: What permissions are required to create temporary tables?

Posted by & filed under , , , .

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.  Instead of just a re-cap of all of the questions, instead I’ve opted to put together a post per topic.  Hopefully, this will [...]

Blurry keyboard

Last Weeks Top “Reading” Links #33

Posted by & filed under , .

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These tweets include “Reading” in the message and are items I’ve read over the past few days, usually after hours when sharing would be less than useful, and spaced out to [...]

tool

Get Just The Tools: SSMS Download

Posted by & filed under , .

Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools.  For some reason, the client machine doesn’t have SQL Server Management Studio (SSMS) installed.  Now I’m not talking about not having the SSMS installed on the server, but on the local workstation that you need to connect to [...]

Blurry keyboard

Last Weeks Top “Reading” Links #32

Posted by & filed under , .

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These tweets include “Reading” in the message and are items I’ve read over the past few days, usually after hours when sharing would be less than useful, and spaced out to [...]

Book

Reblog: May 3 to May 9

Posted by & filed under , .

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value. Some posts from years gone by that you [...]

data center

May 2013 – Monthly SQL Server Checklist

Posted by & filed under , , .

It’s the start of the month of May, or at least the first Monday in May.  Hopefully you aren’t nursing too much pain from a weekend that included two fairly dissimilar holidays.  First, there was Star Wars Day on Saturday.  Followed by Cinco de Mayo on Sunday.  There should have been something in there for [...]