Using a 3rd party to manage user identities make sense for many reasons, and the most compelling reason is that you own your identity and it can be reused...

As a side note, in Oracle a NULL and an empty string '' are equal, which means that:

'' IS NULL, the expression '' = '' would always evaluate False,...

Rod at work (6/29/2016)

---

Eric M Russell (6/28/2016)

---

While we're on the topic of organizations who leverage technology to automate "grunt work", this is a funny read.

How to Snare Millions of...

Phil Parkin (6/28/2016)

---

Eric M Russell (6/28/2016)

---

Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source...

Check your maintenance plan. Often times it will contain truncate job and backup history.

There is a function called object_definition() that accepts object_id and then returns the T-SQL of object like stored procedures, UDF, or views. When combined with sp_msforeachdb, you can leverage it...

While we're on the topic of organizations who leverage technology to automate "grunt work", this is a funny read.

How to Snare Millions of Men with Web Bots

http://gizmodo.com/ashley-madison-code-shows-more-women-and-more-bots-1727613924

Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source database server.

- First confirm...

Many IT organizations (OK, probably more like most), even some of the largest organizations, just don't "get" database design. Oh, they know all about networking, SAN storage, hardware, and virtualization......

roger.plowman (6/24/2016)

---

Ah, clearly you are unfamiliar with the miracle...

Umm... no. :unsure:

Maybe we can startup a SCRUM team using folks from here at SQLServerCentral.

If the interviewer knows what he's talking about, and the whole point is to spark a conversation about how the candidate approaches DDL deployment, then it's a good question. If...

In many organizations (OK probably most) the application developers create the database; both the logical and physical model. The DBA discovers that this new database will soon exist in production...

Charmer (6/23/2016)

---

Hi Friends,

I had a question during my interview, as saying that What could be the reason when I am trying to drop all these tables , views, functions, SP's...