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

One reason why a 40% increase in data growth translates into only a 5% increase in IT budget is that our hardware and database server platforms are designed to handle...

One thing that will attract talent to a company is when they publish technology solution case studies in trade publications or on their website. There have been occasions where I...

Well, if he doesn't even know what the technology is called, then even Google and MSDN won't help him. I...

drew.georgopulos (3/18/2012)

---

During a discussion about virtualizing servers, I suggested we migrate just data that we knew for sure was in use. The idea instigated a riot among the developers...