July 2010 - Posts

• 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

• T-SQL Tuesday #008: Turning Civilians into Soldiers

  This month’s T-SQL Tuesday, started by Adam Machanic ( Blog | Twitter ),  is being put on by SQLServerCentral author and MCM, Robert Davis ( Blog | Twitter ).  This month the topic is learning and teaching Read More... Posted Wednesday, July 14, 2010 12:53 AM by Jonathan Kehayias | 1 Comments Filed under: TSQL2sday

• Have the Experts at your Fingertips! Buy the PASS Summit DVDs!

  Last year after returning from PASS Summit, I blogged about The benefits of attending PASS realized! , where I provided a specific example of how attending had helped me in troubleshooting a problem in my environment.  I love PASS Summit, its the Read More... Posted Monday, July 12, 2010 11:41 PM by Jonathan Kehayias | 1 Comments Filed under: PASS

• How do you learn BI as a DBA?

  As a DBA, I control a lot of data in my environment. Most of this data is stored in relational Online Transaction Processing (OLTP) databases that support the daily operations of the applications in our environment. While it is possible to do basic reporting Read More... Posted Monday, July 12, 2010 7:09 AM by Jonathan Kehayias | 7 Comments Filed under: Business Intelligence

• Understanding the MD3000/3000i Storage Array configuration options

  Yesterday I happened to catch Brad McGhee’s ( Blog | Twitter ) tweet about receiving a new MD3000 DAS storage array today.  I shot him a tweet that I could send him information about using the command line interface for the MD3000 to do advanced Read More... Posted Thursday, July 08, 2010 2:45 AM by Jonathan Kehayias | 1 Comments Filed under: Database Administration, Storage

• 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

• Working with Team Foundation Server 2010 – Part 1

  As I try and make changes in our environment and enforce best practices for development in my own work as well as that of other team members, one of the topics that had to be made was what path we would take for source control.  Since we are in the Read More... Posted Wednesday, July 07, 2010 1:56 AM by Jonathan Kehayias | 2 Comments Filed under: Team Foundation Server