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

From SSMS Object Explorer, you can also right clicks on a database and set the 'Restrict Access' propery from the default 'MULTI_USER' value 'RESTRICTED_USER', which will achieve the same result...

The following statement can be used to kill a specific connection:

KILL <SPID>

If what you're trying to do is terminate all connections on a specific database, while allowing a couple minutes...

LightVader (6/21/2016)

---

Eric M Russell (6/20/2016)

---

Jeff Moden (6/20/2016)

---

Eric M Russell (6/20/2016)

---

Jeff Moden (6/17/2016)

---

As a bit of a sidebar and like anything else in SQL Server, saying something like the use of...

Gene Roddenberry invented the floppy disk, just like invented the smart...

I'm sure that scribes in ancient Egypt saw papyrus as an innovation over clay tablets. However, today most of what we know about Egypt comes from the clay tablets as...

So this basically just T-SQL with additional extensions for sourcing from or outputting to flat files and also perhaps analytical functions?