SQL Server 2008 R2

Technical Article

RE: Security Methodology Using Roles

  • Reply

I would love to agree with you, but the fact of the matter is that patch management is still a major issue, even with tools like those provided by Microsoft, Shavlik, and St. Bernard (among others) available. Take SQL Slammer, for instance. Getting different companies to agree to support us when we were talking about […]

2003-06-23

1 reads

Technical Article

RE: Security Methodology Using Roles

  • Reply

ok, first let me respond by saying that - if an organization has 45 production servers - then they also need the infrastructure to keep all workstations logged and patched automatically (IT dept's problem - but very doable)... secondly, in many environments (especially large corporate retail) developers must write, test, and deploy automated jobs every […]

2003-06-23

1 reads

Technical Article

RE: Security Methodology Using Roles

  • Reply

quote: this is where you dba-types are totally clueless - how is a developer going to develop when they can't create dts pkgs and schedule jobs that run existing dts pkgs? not possible for any real db dev or testing of data... A couple of things here. First, Steve is advocating the removal of guest […]

2003-06-23

1 reads

Technical Article

RE: How much do you earn?

  • Reply

Dale, quote: Here's what the president of a local consulting group said to me just last week, "...I was perfectly at ease after I got over the shock of hearing such techno-babble from such a beautiful woman!" Sometimes men say such things as a genuine compliment. Sometimes they say them as a "come-on". Sometimes just […]

2003-06-20

2 reads

Technical Article

RE: Operators

  • Reply

You have to have SQLAgentMail configured before you can send emails or pages to the operators you've setup. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

2003-05-14

1 reads

Blogs

Goal Progress for Jan 2023

By

The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger

By

Does Context Info work across databases? This post shows it does. Another post for...

Introducing… Data On Rails!

By

Data On Rails is a Data On Wheels project designed to give a platform...

Read the latest Blogs

Forums

Storing a text file in a VARCHAR(MAX) column

By Mick Opalak

I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...

"ID" primary key from two separate tables as a foreign key in a new table

By Edub1122

I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...

blocking issue

By vsamantha35

Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers