Ultimately any task where you care more about high speed and low cost than you do about consistency is a great candidate for NoSQL. However, I have to comment on...

Evil Kraig F (1/12/2012)

---

Heh, New Guy on the block I guess.

Ctrl-F5 is my friend. Where'd I typo?

I want to worry and keep in my head the object model and...

SQL Server posting to Twitter... Why not, workstations posting to IRC works extremely well for some of the most prolific software out there.

Great idea, I'll blame Steve when I get...

savedanthony (7/28/2011)

---

I am trying to use SQL to transfer a prompt list of values into a column that I can join with values in a cognos table in order to...

"The cloud isn't the ultimate answer, and you ought to have a backup plan, which should include the ability to move your services back to your own data center."

Having a...

Have you checked the usual culprits?

Disable UAC and make sure that Kerberos is working correctly. I know I've had issues with both of those at various times with scheduled tasks.

Other...

I've spent just enough time evaluating Denali CTP 1 to realize that the cool new features that I want to evaluate aren't available in CTP 1.

I'm now waiting for CTP...

Tom.Thomson (2/18/2011)

---

If your data is sufficiently important to need...

TheSQLGuru (2/1/2011)

---

max server memory and cpu affinity can get you "isolation for performance reasons" without giving up the memory another instance will chew up for nothing. And many times...

Here is a great article by Erland Sommarskog, SQL Server MVP.

His coverage of permissions is excellent and very complete. I think it should cover what you're trying to do. EXECUTE...

Bradley Deem (5/13/2010)

---

Toreador (5/13/2010)

---

Interesting - it never occurred to me that the identity values wouldn't be available in the inserted table!

So how would you get the identity values of the...

Henry_Lee (5/10/2010)

---

I do not like different schemas within the same database, since they break the ownership chain. Joining different schemas in a proc forces me to grant permissions on the...

Have you considered putting the TSQL code into a stored procedure and using ownership chains.

The simplest version is to create a stored procedure using an account that has the...

William Rayer (11/20/2009)

---

I thought it was easy to remove Windows authentication. All that Windows authentication does is include the Windows Adminstrators group in the sysadmin server role. So all you...

Andrew (9/9/2009)

---

rja.carnegie (9/9/2009)

---

I mean, have I got this wrong: I can change your password to what I want it to be. But I can't change it back, or can...