(Glenn Berry, Louis Davidson and Tim Ford) Let’s get right down to the OS level. We’re looking at the worker threads that carry out the tasks required by our transactions. The Dynamic Management Objects (DMOs) in this category—all of which start with the name sys.dm_os_—provide extremely detailed in
Author: SSWUG Research
How to Enable Backup Compression for Microsoft SQL Server
(Wayne Zimmerman) I recently attended a SQL 2012 training class, and one of the coolest features that was discussed during the class was the built-in backup compression. This feature became available in SQL 2008 R2.
How To Create an ADO.NET Data Access Utility Class for SQL Server
(Ray Barley) I am a .NET developer and I typically write applications that use a SQL Server database. I’m looking for a really simple, reusable class that encapsulates my ADO.NET database access code for create, read, update and delete (CRUD). As I see it I need two methods in the class: one that
Calculating timezone offsets
(Giuseppe Maxia) Time zones are a tricky feature. You live in a given time zone, and most of the time you won’t think about that at all. You may live in a place where you are conscious of time zones, such as the United States, if your business spans across the country, where you know that New York i
How to rebuild table when you don’t have TOAD
(mdinh) I will demonstrate how to rebuild table DEPARTMENTS using datapump.
Visual Studio 2012: ‘The event log file is full’ error message
(Mandi Anez Ohlinger) I installed Visual Studio 2012 Professional. The installation did not complete successfully so I ran a Repair. During the Repair, the following error occurred:
How BLU Acceleration Really Works
(Guy Lohman) Want to know how BLU Acceleration REALLY works? Written by the researchers and developers that invented it, this highly technical overview is not really a white paper, but in fact a contribution to academic literature that was refereed by world experts and presented at the 39th Interna
Creating PDF documents from XML
(Marco Merola) This article is about using XML/XSL-FO and the open source library FO.NET to generate PDF documents by mixing input parameters, images and static localization strings. I think that this kind of approach is ideal to automate the process of generating invoices or simple dynamic document
Date Time Picker in jQuery and JavaScript
(Mahesh Alle) I have searching many websites for datetime pickers and have not found anything useful. I finally I found a jQuery and JavaScript Date Time Picker and it is very simple and attractive.
sp_SrvPermissions
(Kenneth Fisher) Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it to one of my co-workers and his response was “Where’s the server version?” Unable to come up with an appropriate rude response I’m posting the server vers