Saturday, January 31, 2009 |
|
|
Every so often, I have to do database administration activities, like restore a database (typically a DotNetNuke database downloaded from a hosted site).
I know the details are in the SQL BOL, but I usually have to hunt for them. Pinal Dave's site comes to the rescue with a good abbreviated rundown of the RESTORE commands.
Pinal Dave's site is packed with lots of useful database information and I would highly recommend it to up and coming DBAs. He is a regular columnist for SQL Server Magazine.
|
|
|
|
|
Sunday, January 25, 2009 |
|
|
Vista - wait 7 minutes after booting!
I was reading a blog by Michael Woodring, called Some Assembly Required, at PluralSight, which led me to this Microsoft site on Windows operating systems as it relates to hardware. This site has a wealth of information about system internals, virtualization, and performance.
Michael probably doesn't remember me, but he vetted me as an instructor when I came aboard at Learning Tree. I was an instructor on the XML and SQL Server 2000 introduction courses.
Anyway, I have often noted that I need to boot my Vista PC and walk away from it, typically after login, to let it "settle" because it is just very slow during this phase. In the "Measuring Performance on Windows Vista" document located on this site, I came across this gem of information:
As a machine boots, large amounts of code and data are read from the disk. Systems with more than 1 GB of RAM set aside large amounts of memory for a cache of prefetched data. The system releases this cache after boot, its pages become available, and SuperFetch fills these pages with new contents. Because some of the post-boot activities throttle themselves or use low-priority mechanisms, their impact on interactive users is controlled, but they can be a source of variation in benchmarking measurements.
Benchmarking Tip: When you run workloads, delay the workload start until these post-boot activities are finished. Wait 7 minutes after boot before running benchmark workloads to reduce the variability caused by post-boot activities.
|
|
|
|
|
Friday, January 23, 2009 |
|
|
My compatratiots in the developer/user group community have nominated me for Microsoft MVP. This is a huge honor and recognition in and of itself, and I wish to thank those that submitted me for this honor.
 |
1/23/2009 9:07:09 AM (Eastern Standard Time, UTC-05:00) | | Microsoft MVP
|
|
|
|
|
I often get SPAM email for "Corbin Mack". I did a quick search on Google for this name associated with email SPAM but came up with nothing.
So, in case anyone else is out there searching for this, then yes - there is a lot of SPAM mail sent addressed to Corbin or Corbin Mack. Perhaps that gets through the typical filters, but I always drop it in the delete bit bucket.
Corbin Mack =  |
1/23/2009 9:03:39 AM (Eastern Standard Time, UTC-05:00) | | SPAM
|
|
|
|
Sunday, January 11, 2009 |
|
|
Now this is a really cool idea.
Microsoft Tag
Download Microsoft Tag to your cell phone, then point the camera at the image below. It will take your cell phone browser to the CapitalDug.org website.
A bar code for cell phones for links. What a great idea. |
|
|
|
|
Saturday, January 10, 2009 |
|
Thursday, January 01, 2009 |
|
|
Well, I finally have deposited my source code from the Nova CodeCamp presentation on SQL CLR here on my blog.
I apologize for taking so long. I needed to update some of the code and strip out any source code control references.
SQLCLRUDA.Zip (29.89 KB)
My presentation slides can be found in a blog entry below. |
|
|
|
|
|
Here is a little commentary that I dispensed at my recent Nova CodeCamp presentation with regards to user defined aggregates written using SQL CLR for the Microsoft SQL Server. SQL 2008 has improved the user defined aggregate feature, but it currently comes at a price. First I discuss the attribute setting to implement the feature, then I provide necessary information on how to deploy it!
For those developers building user defined aggregates (UDA) in SQL Server 2008, you now can build an aggregate that exceeds the 8000 byte limitation in SQL Server 2005.
To implement this feature, you set the MaxByteSize to -1. This will allow the UDA to grow to a size above 8000 bytes up to 2 GB. An example of the attribute setting is shown below.
[Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedAggregate(
Format.UserDefined,
IsInvariantToNulls = true,
IsInvariantToDuplicates = false,
IsInvariantToOrder = false,
MaxByteSize = -1)
]
Great so far. Now here is where the problem starts. You cannot deploy an assembly with a UDA having this setting from within Visual Studio 2008. You have to deploy the assembly manually.
/*
* Manually add assembly to database
*/
CREATE ASSEMBLY UDA from 'D:\Development\UDA\bin\UDA.dll'
WITH PERMISSION_SET = SAFE
GO
If you attempt to deploy the UDA with the above attribute, you will get the following message:
Error: 'MaxByteSize' property specified was not found.
You can find information on MSDN about the MaxByteSize setting here.
|
|
|
|
|
|
|
|
| Archive |
| April, 2009 (3) |
| March, 2009 (3) |
| February, 2009 (3) |
| January, 2009 (9) |
| December, 2008 (2) |
| October, 2008 (1) |
| September, 2008 (3) |
| August, 2008 (1) |
| July, 2008 (1) |
| June, 2008 (3) |
| May, 2008 (1) |
| April, 2008 (5) |
| March, 2008 (7) |
| February, 2008 (1) |
| December, 2007 (6) |
| November, 2007 (4) |
| October, 2007 (3) |
| September, 2007 (1) |
| August, 2007 (4) |
| July, 2007 (1) |
| June, 2007 (1) |
| April, 2007 (5) |
| March, 2007 (7) |
| February, 2007 (4) |
| January, 2007 (2) |
| September, 2006 (2) |
| August, 2006 (1) |
| March, 2006 (3) |
| October, 2005 (3) |
| September, 2005 (10) |
| August, 2005 (3) |
| July, 2005 (2) |
| June, 2005 (4) |
| May, 2005 (12) |
|
|
|
|
| Themes |
| Pick a theme:
|
|
|
|