Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2013

Thoughts About The Nail

The other day Grant Fritchey (Blog | @GFritchey) linked out the video below.  It’s a quick little video, that isn’t about the nail.  As I watched it, it spoke volumes to me from both personal and professional experiences.  Check it out quick and then I’ll continue this blog… Read more

5 comments, 309 reads

Posted in StrateSQL on 31 May 2013

Reblog: May 24 to May 30

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… Read more

0 comments, 283 reads

Posted in StrateSQL on 31 May 2013

Security Questions: TRUNCATE TABLE Permissions

As I mentioned in the introductory post, during 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… Read more

5 comments, 375 reads

Posted in StrateSQL on 30 May 2013

Security Questions: Accessing SQL Server Securables

As I mentioned in the introductory post, during 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… Read more

5 comments, 994 reads

Posted in StrateSQL on 29 May 2013

Security Questions: Authentication Performance

As I mentioned in the introductory post, during 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… Read more

1 comments, 255 reads

Posted in StrateSQL on 28 May 2013

Security Questions: Difference between sysadmin and CONTROL SERVER Permission

As I mentioned in the introductory post, during 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… Read more

3 comments, 290 reads

Posted in StrateSQL on 27 May 2013

Last Weeks Top “Reading” Links #34

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… Read more

0 comments, 257 reads

Posted in StrateSQL on 27 May 2013

Reblog: May 17 to May 23

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… Read more

0 comments, 234 reads

Posted in StrateSQL on 24 May 2013

Security Questions: Differences between “Grant” and “With Grant?”

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… Read more

0 comments, 1,223 reads

Posted in StrateSQL on 23 May 2013

Index Analysis May Update

Seems I managed to make it through all of April without an update to the index analysis stored procedure.  It wasn’t for lack of using it with clients, but a lack of time to get the changes out the door.

A few months back, I added the option to… Read more

2 comments, 207 reads

Posted in StrateSQL on 22 May 2013

Security Questions: Grant Permissions to All Stored Procedures

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… Read more

3 comments, 253 reads

Posted in StrateSQL on 22 May 2013

SQL Server Security Webcast Questions – Series Introduction

Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s.  A video of the session is available at the Pragmatic Works website.  As a part of that session, I received a couple dozen questions about security that we didn’t… Read more

1 comments, 234 reads

Posted in StrateSQL on 21 May 2013

Last Weeks Top “Reading” Links #33

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… Read more

1 comments, 274 reads

Posted in StrateSQL on 20 May 2013

Get Just The Tools: SSMS Download

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… Read more

10 comments, 513 reads

Posted in StrateSQL on 15 May 2013

Last Weeks Top “Reading” Links #32

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… Read more

0 comments, 278 reads

Posted in StrateSQL on 13 May 2013

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

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… Read more

5 comments, 115 reads

Posted in StrateSQL on 12 May 2013

Reblog: May 3 to May 9

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… Read more

1 comments, 301 reads

Posted in StrateSQL on 10 May 2013

Presentation Materials “Discovering the Plan Cache” #SQLSat175

I’m a little late getting the information from my Fargo SQL Saturday session posted, titled ”Discovering the Plan Cache“.  But it’s better a little late that never.

Even though it was the end of the day, the session had great turnout and lots of good questions.  Reviewing my… Read more

0 comments, 219 reads

Posted in StrateSQL on 7 May 2013

Webcast Presentation Materials: Introduction to SQL Server Security

Last Thursday, I delivered a presentation for Pragmatic Works Training on the T’s. The session for last week was Introduction to SQL Server Security, a part of last month’s series of introductory presentations.

The abstract for the sessions is:

One of the most often overlooked feature sets of…

Read more

10 comments, 258 reads

Posted in StrateSQL on 7 May 2013

May 2013 – Monthly SQL Server Checklist

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… Read more

0 comments, 267 reads

Posted in StrateSQL on 6 May 2013

Older posts