Browse by Tags

• Internals
• SQL Server 2008
• SQL Server 2008 R2

• SQL Server 2008 R2 DACPAC Bug - Cannot insert the value NULL into column 'created_by', table 'msdb.dbo.sysdac_instances_internal'

  While trying out the new DACPAC feature in SQL Server 2008 R2 recently, I ran into a bug that makes no sense to me at all.  In my environment we use an Active Directory Group for the SQL Database Administrators and that group is a member of the sysadmins Read More... Posted Tuesday, July 27, 2010 12:14 AM by Jonathan Kehayias | 0 Comments Filed under: Bug Reports, SQL Server 2008 R2

• Bug in SQL 2008: Why you shouldn’t create large tables in the Model Database

  If you follow me on Twitter ( @SQLSarg ) you probably saw tweets about a bug I encountered in SQL Server 2008 recently.  What was hoped to be a normal Monday morning started off with alerts from a new production server that DBCC CHECKDB had failed Read More... Posted Wednesday, July 07, 2010 2:39 AM by Jonathan Kehayias | 0 Comments Filed under: Bug Reports, Internals, SQL Server 2008