Apr
8
By Ben  //  No Comments

My New Digs – BuyFun.com

I’ve recently started working as a Senior Developer at BuyFun.com. Decided I was ready for a change after 11 years at the same company. I wasn’t really [...]

Jan
8
By Ben  //  No Comments

“New Index…” is greyed out in SSMS

Can’t create a new index?  In SQL Server Management Studio, if the New Index… option is greyed out, it is because you have a table’s Design window [...]

Jan
8
By Ben  //  No Comments

Full Text Index with Database Project Problem

I was running into issues with scripting full text indexes to my database project when doing a database compare from a SQL Server 2008 R2 database to [...]

Dec
15
By Ben  //  No Comments

SQL Server 2008 R2 Spatial Data Notes

Building a Point A point in SQL Server is represented as Longitude and then Latitude geography::STPointFromText(‘POINT(‘ + CAST([Longitude] AS VARCHAR(20)) + ‘ ‘ + CAST([Latitude] AS VARCHAR(20)) [...]

May
22
By Ben  //  No Comments

Error generating final archive: Debug certificate expired

I’m getting back into android development after being away from it for a while. When trying to build my application (using a 64 bit windows 7 machine) [...]

Feb
27
By Ben  //  No Comments

Do I have SQL Server 2008 or SQL Server 2008 R2 installed?

How to identify your SQL Server version and edition SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) Version Components and Numbering SQL Server 2008 R2 is a minor upgrade [...]

Feb
23
By Ben  //  No Comments

SSRS 2008 Security Item Level and System Level Role Definitions

In SSRS 2008 it appears you can no longer configure item-level role definitions and system-level role definitions like you used to be able to do in SSRS [...]

Sep
14
By Ben  //  No Comments

Remote Desktop to Console

To RDP directly to a server’s console you can use the following command… mstsc /v:SERVERNAME /console

Knowledge Bomb