Apr
8

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

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

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

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

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

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

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

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