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

Here you'll find all the SQL Server storage internals information you can handle and then...

I typically code stored procedures using an output parameter that is also a return code. When the procedure executes to completion, the @status variable will have a return value of...

There are tools downloadable from Microsoft to stress the I/O and consume memory in a general way.

Also, using SQL Profiler, you can capture T-SQL events on one server, and...