Elliott W (8/12/2009)

---

I like both but each has its own purpose..

Many (most) environments end up with a mix. With Linked servers being used less.

For data that you need the...

Thanks, I checked amazon and there are no reviews, but from...

Luke L (7/28/2009)

---

The dedicated admin connection or DAC is a special connection setup by SQL Server. There is one per instance and it is usually 1 port higher than...

Paul White (6/25/2009)

---

Yeah I know what you mean - went through something similar with PCI-DSS (or whatever it was called).

Heh. You could always upgrade to 2008 Enterprise and use...

Paul White (6/24/2009)

---

I've never seen anything to suggest that is necessary, no.

My favourite article for this stuff on here is http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sql2005symmetricencryption/2291/

There are plenty though - search the tags if you...

Paul White (6/19/2009)

---

You have an indication that at some points in time, your disk sub-system is unable to keep up with I/O requests from SQL Server. Whether this is...

DCPeterson (6/17/2009)

---

We have a few indexed views in our reporting database and have had no problems creating them...until now. I've created a new view and am attempting to create...

I originally posted this here (http://www.sqlservercentral.com/Forums/Topic734068-361-1.aspx), but this seems like a better place for it...

Developers at my workplace are pondering use of LINQ for their upcoming projects.

How much should I,...

Oops, I just saw these 2 links, perhaps I will carry on in the discussion on Steve's editorial instead of here...

http://www.sqlservercentral.com/articles/Editorial/64842/

http://www.sqlservercentral.com/blogs/andy_warren/archive/tags/LINQ/default.aspx

andrewkane17 (6/9/2009)

---

This is how management studio gets the startup params, I use this to poll our server in ssis and save the data in case of DR

CREATE TABLE #TEMPTOAD (...

Here is something I just came up with:

--Return list of encrypted columns in current db

select

OBJECT_NAME(c.[object_id])

,c.[name] as columnName

from

sys.columns c

join

sys.types t

on

c.system_type_id = t.system_type_id

where

t.name = 'varbinary';

How does it...

Wobble Chops (5/30/2009)

---

I use PowerGUI Script Editor too and have the same concern. The way I get around it is to put "return 0" as the first line of...

GilaMonster (5/30/2009)

---

You could always take the DBs offline as you finish the backups. That way no one would be able to make any transactions. It may make the downtime more,...

Carl Federl (5/30/2009)

---

If all of the user databases are in full recovery mode, then full backups could be made earlier (starting at 6PM?), and then at 7 PM, only transaction...

We are doing a critical outage tonight, and I have a 20-minute window to backup a large number of databases before our storage admin does the tape backups.

My schedule...