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

Some of these newer T-SQL features (like SEQUENCE and IIF function) are not an evolutionary improvement over what we've had in SQL Server for the past 15 years but rather...

Working 10 or 12 hour shifts (in exchange for a shorter work week) is OK when I'm on a sprint. A sprint is when everyone involved has clear understanding of...

However I decided this year that I should buckle down and get this done. I'm proud to say that I spent about an hour working on the task and got...