GSquared (7/12/2011)

---

First, datareader and datawriter are dangerous rights to have to grant. Given that you sometimes have to do so, to accommodate poorly designed applications, you have to recognize...

IceDread (7/11/2011)

---

Eric M Russell (7/11/2011)

---

IceDread (7/11/2011)

---

GSquared (7/11/2011)

---

IceDread (7/11/2011)

---

Changing from sa to a new user should always be done.

However, having said that, it does not offer much if the new users...

IceDread (7/11/2011)

---

GSquared (7/11/2011)

---

IceDread (7/11/2011)

---

Changing from sa to a new user should always be done.

However, having said that, it does not offer much if the new users rights is not properly...

In addition to security, backups, and the hiring and retaining of good staff, a CIO should also periodically take inventory of all the IT projects that are currently under development...

IceDread (7/11/2011)

---

Changing from sa to a new user should always be done.

However, having said that, it does not offer much if the new users rights is not properly limited.

If...

In addition to "invalid object" alerts and running DMV queries to determine object usage, you could perhaps identify those infrequently referenced database objects by searching application source code using a...

If you're not a member of SYSADMIN, and you're running into a snag, then verify that your account has ALTER TRACE permission.

Permissions Required to Run SQL Server Profiler

http://msdn.microsoft.com/en-us/library/ms187611.aspx

Also, if you don't have time to develop and maintain a website, then perhaps just create a blog on blogger.com or wordpress and then point the DNS for your domain...

Thomas Abraham (6/28/2011)

---

I have the rights to dbanalyst.com domain name. I was going to use it for consulting work, but have decided against that at the current time.

Can someone suggest...

Cisco, Google, Microsoft, and many non-tech companies have made investments in and done tremendous business with various governments around the world, often ignoring the social policies and issues of those...

As suggested earlier, attend local SSUG meetings. It's good that you have your certifications, but also read some books that delve more into detail about topics like SQL Server internals,...

It sounds like this reporting / EDI server is perhaps just a snapshot of a production OLTP database and serving the purpose of an Operational Data Store (ODS). The query...

keymoo (6/27/2011)

---

I have a super table called Instrument. I have a sub-type table called BondInstrument. Relationship is one-one. PK is a column called InstrumentId.

I also have a table called InstrumentEvent...

The database developer really should be a SYSADMIN in the development environment, or at least have permission to VIEW SERVER STATE, ALTER TRACE, and SHOWPLAN permission. At the very least,...

The good news is that:

#1 30,000 rows is not a lot of data.

#2 Dropping a column is not a change of data operation, meaning that the column is marked as...