For this sort of thing I would recommend a server-side profiler trace. Don't use the Profiler itself if you intend to trace over an extended period.

Grant Fritchey (12/2/2013)

---

When you run a full backup, it also backs up the transaction log. If your transaction log has 30gb of transactions that have not been backed up (guessing...

Sorry......a little bit of pendantism coming through! The only reason I brought it up is to prevent the...

I wrote this:

USE [Monitor]

GO

/****** Object: StoredProcedure [dbo].[sp_DBSizing] Script Date: 12/06/2013 12:01:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE procedure [dbo].[sp_DBSizing]

as

begin transaction;

EXECUTE master.sys.sp_MSforeachdb

'USE [?];

insert into monitor.dbo.tbl_DBSizing

select...

Knight (12/4/2013)

---

Are you sure this senior dev doesn't mean something like a work or staging database? i.e. something pre-production and isolated on a different drive? That I could understand.

As Gail...

nagasai88 (12/3/2013)

---

Thanks,

Even I know we cannot do like this, but Sr. SQL developer in our company said that he had seen this kind of implemenation in his previous company so...

Talib123 (12/6/2013)

---

Am I correct in thinking that sql is licensed per server and not per instance.

So if I have a VM with 4 instances then the 1 license will cover...

wak_no1 (12/5/2013)

---

Hi

I've been tasked to audit a number of SQL Server environments.

I'm going to be creating baseline documentations for each environment, documenting statistics (database stats, waits stats, log usage etc.)...

D.Schrenker (12/5/2013)

---

I will preface this by stating we are using MS SQL Server 2008 R2.

We're having issues when our database backups are running SQL Server takes all of the...

Hi Lutz,

thanks for the comments. Nice....

The solution I have created (albeit far from perfect) is to allow a member from the Dev Team to have DBCREATOR rights. Only...

george sibbald (1/12/2009)

---

SQLBOT (1/12/2009)

---

Andy Steinke (1/12/2009)

---

Your organization needs to suppoort saying no; it's easy to say this from an ivory tower perspective but you have to have management and executive...

GilaMonster (11/29/2013)

---

If the developers have enough rights to run that, they have enough rights to just log directly on to the server and do stuff anyway. If you don't trust...

GilaMonster (11/29/2013)

---

This can't. To run...

Wow! Fantastic input!

So, the obvious question.....

How could this be rewritten so it would be more secure? Ideally if I am going to implement it, I want it done...

Great, thanks for your input.....I'll do it shortly and let you know how it went.

Two questions though (and please remember I am not a developer!):

1. Why NVARCHAR(MAX) and not...