DevSharePoint.com

Connect to SQL Server management studio and run: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') You should... [read more]

http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/3425c9bf-4f20-4664-8bb1-ed21f2468175/ – Let’s look at the token SELECT principal_id, sid, n... [read more]

http://jasonfollas.com/blog/archive/2008/03/14/sql-server-2008-spatial-data-part-1.aspx Geometry and Geography. The most important thing to keep in mind about t... [read more]

http://erinstellato.com/2011/05/sql-university-internals-deletes/ Deletes on a heap do not deallocate. ... [read more]

http://msdn.microsoft.com/en-us/magazine/cc163346.aspx SELECT e.EmployeeID, oe.NumOrders, oe.MaxDate, e.ReportsTo AS ManagerID, om.NumOrders, om.MaxDate FROM E... [read more]

http://blogs.technet.com/b/wbaer/archive/2010/05/03/database-mirroring-in-sharepoint-2010.aspx Bill Baer overview of the past. Configuration In many cases the S... [read more]

Email Subscription. Enter your email address to subscribe to this blog and receive notifications of new posts by email. ... SharePoint MOSS 2007, SharePoint Cen... [read more]

http://www.mssqltips.com/tip.asp?tip=2119&home As you can see, the offset of Disk 1, Partition 0 is 32,258 bytes. �That’s sixty-three 512 byte blocks.... [read more]

SELECT SERVERPROPERTY(‘ProductVersion’) AS ProductVersion, SERVERPROPERTY(‘ProductLevel’) AS ProductLevel, SERVERPROPERTY(‘Edition’) AS Edition GO ... [read more]

When I Try to modify Navigation in a site and add a heading, this is not working. When pushing OK, there is nor error messages appearing, but the heading is n... [read more]

http://consultingblogs.emc.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx Data flow task t0 lo... [read more]

SQL Server VSS Writer. Windows SharePoint Services Administration. Windows SharePoint Services Search (only if this is installed using Central Administration). ... [read more]

SQL Server VSS Writer. Windows SharePoint Services Administration. Windows SharePoint Services Search (only if this is installed using Central Administration). ... [read more]

SELECT ‘BACKUP LOG ‘ + name + ‘ TO DISK = ‘ + ”’H:BackupsSQL’ + name + ‘.bak”’ + ‘ WITH NOFORMAT, NOINIT, NAME=’ + ”” + name + CO... [read more]

http://technet.microsoft.com/en-us/library/cc966395.aspx#XSLTsection129121120120 SQL Server 2005. ... [read more]