(Derek Ferguson) Tablet PCs are high-end mobile computers that combine the power of desktop computers with the mobility of Smart Devices. Like many mobile computing devices, businesses often use Tablet PCs for mobile data collection and access. Tablet PCs may access data and send it back to the orga

(Don Schlichting) SQL Server 2005 includes a banded reporting tool and engine called SQL Server Reporting Service (SSRS). Developing reports in SSRS is similar to report building in Crystal or Microsoft Access. Reports can be viewed in a web browser, exported to a file, or embedded into a Windows fo

In Microsoft SQL Server 2000 Service Pack 4 (SP4), new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread. Additionally, the thread context variable is not populated with the expected thread stack information. When this problem

(Samuel Isaac) Okay, the more I think about this, the more I feel the title is wrong. The excel sheets I deal with are not entirely unformatted.

After you use a DELETE statement in Microsoft SQL Server to delete data from a table, you may notice that the space that the table uses is not completely released. When you then try to insert data in the database, you may receive the following error message: Could not allocate space for object ‘T

After you apply Microsoft Windows Server 2003 Service Pack 1 (SP1), an error occurs when you try to access the Microsoft SQL Server 2000 Analysis Services performance monitor counter object.

(Ted Bouskill) Do you have or have you ever managed a legacy SQL database that has become large and unwieldy? This tool can be executed at anytime, even as a scheduled task, to create a unique date and time stamped CSV file with a report of the table space used for each table in the database, using

(Sonu Chauhan) The default ASP.NET process identity for Web applications can write new records to the event log, but it does not have sufficient permissions to create new event sources.

(Muthusamy Anantha Kumar) One of the many new features that have been added to SQL Server 2005 is DDL triggers. We use DML triggers in SQL Server 7.0 and 2000, which executes a bunch of SQL statements or procedures whenever an INSERT, UPDATE or DELETE statement is executed and limited to a table or

(Jeremy Kadlec) Locking is a necessary component of the SQL Server engine to properly ensure transactions are processed accurately with high levels of concurrency. Unfortunately, those locks can quickly become unwieldy and reduce SQL Server from a high concurrent database to a single-user machine wi