This quote from MSDN CREATE PROCEDURE documentation leads me to believe that the text of the stored procedure isn't encrypted in the database, but rather SQL Server doesn't expose the...

toddasd (8/24/2011)

---

It's called the Dunning–Kruger effect http://en.wikipedia.org/wiki/Dunning%E2%80%93Kruger_effect

We had a kid a few years out of college who couldn't program his way out of a wet paper bag, and yet couldn't...

Jeff Moden (8/23/2011)

---

What's really spooky to me is how little a lot of job applicants know about the basics and how many of them don't know what they don't know....

I can see value in adding Tweet functionality to SSRS or SSIS as a destination.

Well, when creating a SQL Server Alert, the options currently include email, pager, SMS message, and Net Send. Tweets are typically for public broadcast. SMS messages are equivalent in functionality,...

Whether an IT project is a "failure" is a matter of perspective. Just like highway construction, if people ultimately use the applicaton, it generates a profit, and no one gets...

Fortunately most of the larger employers here in Atlanta, especially IT related, are not centralized in the downtown area. They are instead spread out in office parks across the metro...

Currently my commute is about 1/2 hour on those days that I drive into work. There is no mathematical formula that I would use to determine how much time I'd...

michael wang-201906 (8/4/2011)

---

When you put a 7/24 business on the cloud. How any days you could lost to rebuild an in-house data center when your cloud provider having a trouble?...

At this point, my impression is that it makes more sense to migrate datamarts and reporting databases to the cloud, and keep in-house those transactional databases that serve their core...

Lee San (8/3/2011)

---

Hi hi,

I am the inexperience so called DBA (in my job title again). You said you need lead developer for tuning, in my very first job where I...

In both SQL Server and Oracle, the ROWID is a physical marker that changes when the physical position of the row in the page or table changes. For that reason,...

allonlineaccts (7/31/2011)

---

Allow me to rephrase the question and exclude MS Access from it.

I am responsible for developing and editing user interfaces for several departments. These interfaces allow the end...

From what I've seen, most outages (an extended period of time where all or a large number of users cannot access the application or some key feature of it) are...

mar10br0 (7/29/2011)

---

Eric M Russell (7/29/2011)

---

mar10br0 (7/28/2011)

---

For deduping duplicates in a heap-table, I would just delete all offending rows, then re-insert one record. Since a heap cannot have any foreign-keys pointing...