I don't think that knowing from memory the syntax for infrequently used T-SQL statements and admin commands is relevent. However, I do expect a candidate to complete the following test...

Freddie-304292 (7/13/2011)

---

I get really annoyed by interviewers who expect you to know every bit of syntax off the top of your head and don't accept answers like the above. ...

I think that employers, clients, and managers appreciate when an IT professional openly admits what they don't know while still demonstrating what they actually do know. When I've done job...

A data warehouse is a database that consolidates data across the entire enterprise or organization. The database should be nonvolatile, meaning that data which is updated or deleted in the...

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,...