If you are building this data warehouse...

n00bDBA (3/31/2012)

---

Hello!

We have a lot of database used in 3rd party apps. Things like shop sales. and marketing data.

As i understand it. The best way to Analyse the data...

Sean Lange (4/2/2012)

---

Eric M Russell (4/2/2012)

---

jamesforest (3/21/2012)

---

In testing with auto increment I havde noticed the ID field gets incremented even when the insert fails resulting in missing entries. I...

jamesforest (3/21/2012)

---

In testing with auto increment I havde noticed the ID field gets incremented even when the insert fails resulting in missing entries. I have tested on 2 build...

wayne.mcdaniel (3/30/2012)

---

I've been working on something similar to this for a while. We wanted our database update utility to do an automatic backup before it started changing tables and...

Really, this article could be more of a general primer on how to call a stored procedure from a windows form application. If it included a best practive example of...

I think the best way to kick off backups would be to schedule them via SQL Server Agent job. If you're going to kick off your backups from something like...

The Mechanical Turk may be the first documented case of a slick salesperson showcasing Vaporware.

One option for detecting table inserts, updates, and deletes is to implement a server side trace on perhaps the StmtStarting event and also filtering TextData.

To create a trace, the...

Truth be told, some IT guys are probably intimidated by the prospect of a new hire to the department who will be doing the same or similar job. They're afraid...

Gianluca Sartori (3/23/2012)

---

Eric M Russell (3/23/2012)

---

Formatting dates in the presentation layer is best, because how the application wants dates formatted and how reporting wants dates formatted will be different, even...

Formatting dates in the presentation layer is best, because how the application wants dates formatted and how reporting wants dates formatted will be different, even if you get them to...

If someone is looking for free books, the "Best of SQL Server Central" volumes 1 - 7 can be downloaded. It contains a mix of dba, developer, and BI topics.

http://www.sqlservercentral.com/Books/

I'm curious to know how or if you were able to see those mdf and ldf files again from SSMS. Even if the files were in use by another process,...

jfogel (3/21/2012)

---

It should also be noted that this can cut both ways. Many times when a developer is asking questions of a DBA applicant they will not ask Administration based...