agustingarzon (2/29/2012)

---

We are going to develop a project where clients will be able to Create their own SQL tables and fields.

The idea is to give the client the possibility...

Databases have a much smaller surface area for security breaches than do Web applications. For a database, you're basically concerned with how accounts, role membership, or object permissions have changed,...

I ran across a piece that surveyed some salaries and it shows that people working with cloud platforms are commanding higher salaries, even when the underlying technologies are the same....

SQLRNNR (2/28/2012)

---

I am curious to see more of how Hadoop will play in the MS BI stack with big data. Is it more of a fad, or does it...

GilaMonster (2/28/2012)

---

On 2008 both select into and insert ... select can be minimally logged, insert... select requires that the table is empty to start and a tablock hint specified for...

rvasanth (2/26/2012)

---

Hi,

I am using SQL Server 2008 R2.

I am having an table with 10M records (around 40 fields). If i fetch 1M records with simple...

Your supervisor at work should really be the one providing you with guidance about what BI tools you need to learn. Other than padding your resume, there is no point...

Several times a year, I'll take a weekend sabbatical. I'll immerse myself in some project that stretches the scope of my experience, like rennovate the bathroom or replace the water...

"Where traditional databases hit their limits, Hadoop starts to emerge as a much better fit for solving unique analytics challenges," Lockner says. "Because data can be incorporated from multiple sources...

Have you traced the SP:Recompile event? If so, then is there a correlation between an increase in recompiles to some activity in the database, like following the reload of tables?

What I typically do is execute a pass-through style query on the remote server using EXEC ('..') AT REMOVE_SERVER syntax and output the result into a temp table, which I...

I agree that it's best to map local logins to an account on the remote server, rather than have all logins access the linked server using a default security context....

Peter Maloof (2/24/2012)

---

Eric:

Eric M Russell (2/24/2012)

---

For the past several years, I find myself walking up the theatre, reviewing the movie lineup, and then most of the time I'll just walk...

"Dolphin Tale" is one of the other hanful of movies from 2011, and it was one that me and the family enjoyed together.

For TV series, "Spartacus: Gods of the...

For the past several years, I find myself walking up the theatre, reviewing the movie lineup, and then most of the time I'll just walk away disinterested. The same goes...