@lowell

Thanks a lot.

Above is a very interesting piece of code. I definitely would like to experiment and try myself. I will try this at home at my...

If the only user account that hits...

Grant Fritchey (2/19/2015)

---

We had different servers with different Service Level Agreements. When the backups on the highest SLA failed, it was an oncall situation because we had to have a...

GilaMonster (2/19/2015)

---

Because you're protecting it against people who don't have proper permissions.

Consider, all HR people have access to the Employees table but only the HR head for each department should...

For how long has been running? If you execute this T-SQL script

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SELECT

DB_NAME(er.[database_id]) [DatabaseName]

,er.[session_id] AS [SessionID]

,er.[command] AS [CommandType]

,est.[text] [StatementText]

,er.[status] AS [Status]

,CONVERT(DECIMAL(5, 2), er.[percent_complete]) AS...

Lowell (2/18/2015)

---

column level encryption is what you are asking about., not table level. each individual field in a row would be encrypted.

effectively each column that specifically needs to be protected...

Grant pretty much explained it already, and very well by the way.

But in other words ... if your column or Index is not selective enough, there is a chance...

S. Kusen (1/29/2015)

---

The event session that you sent over didn't generate any data for me. I created a simple procedure named MyStoreProcedure so as to not modify the definition...

Wow! :doze: ... I can't believe people keep asking me about that and if the session has been started. It happened to me on StackExchange too.

Yes! The session is running....

rollercoaster43 (1/27/2015)

---

Hi All,

I have a question out of curiosity.. For Bulk Load requests in SQL server, Are there any specific profiler event? Like the one we have for RPC RPC:Starting...

Most of your tables have 1k pages or below. You can't get rid of fragmentation on small tables like that. In fact, you should not put too much effort on...

I do recommend you to do this on a test environment 1st, but you can test how much memory backups consume with these flags

TRACE FLAG 3605:

TRACE FlAG 3213:

Fire a...

I've done this when creating AdventureWorks I think, where the ldf is absent.

Having said that, I see no other useful purpose or reason. Attaching or creating a database without a...

** EDIT **

Replace some values and did some trial and error and got this

SELECT

event_data.value('(event/data/value)[5]', 'bigint') AS cpu_time,

--database name

event_data.value('(event/data/value)[6]', 'bigint') AS duration,

--estimated cost

event_data.value('(event/data/value)[7]', 'bigint') as estimated_row,

--nest level

event_data.value('(event/data/value)[2]', 'bigint') AS object_id,

event_data.value('(event/data/value)[9]', 'nvarchar(max)')...

Tony Lanterman (1/9/2015)

---

Sean McCown had a great session on this topic at the last SQL PASS Summit (DBA-307). Very much worth your time if you have the session DVD....