Gary Varga (12/8/2014)

---

Good luck with that...difficult to find positions that have near zero office politics but they do exist....

As the DBA, if you don't trust your users or your application devleopers to do the right thing, then as last line of defense you can check the data on...

Jeff Moden (12/5/2014)

---

Ed Wagner (12/5/2014)

---

Eric M Russell (12/5/2014)

---

The input should be properly parsed and formatted prior to inserting the database table. Really, allowing users to enter all contact information into...

You are correct that remotely joined tables are very inefficient and the source for many types of problems. If you have a SQL query that joins local tables with remote...

Just to be safe, you may want to use a file search tool to locate the database file (assuming it may still exist) related to that log file, even if...

gouri92 (12/5/2014)

---

Hi I am designing wepage using Asp.net with Sql server as database

I have used Multiline textbox in which user has to enter their family detail.

Like number of brother...

During a round table discussion a senior developer working in a small company posed the question, “How do I get my Finance manager to release funds for me to do...

Brandie Tarvin (12/4/2014)

---

Eric M Russell (12/4/2014)

---

I get the impression this is not commonly known, but a SQL Server authenticated user account, even a minimal user with nothing but default public...

Ideally you will be using Windows authentication across the organization and the network domain admin is a different person than the DBA. However, there are scenarios, like 3rd party applications,...

Steve Jones - SSC Editor (12/3/2014)

---

John Hanrahan (12/3/2014)

---

I believe Steve is referencing the old 'Canary in a Coal Mine'. Miners would test air quality using a bird. If...

Why is the article titled "Always Canary" ?

SQL Server will typically require a schema lock when altering tables, which can be problematic if the deployment involves altering muliple tables and the changes need to be applied in...

Yes, DDL modification events are definately one of the alerts you want sent to your phone.

Organizations actually don't need to spend thousands of dollars to train their IT staff. Those of us in IT, by virtue of our nature, are perfectly capable of going out...

Often times "tricky" techniques are not the best solution. What I mean is that windowing functions are very useful, practicaly essential, for BI type reporting or ad-hoc discovery type SQL...