You are browsing archives for
Its been a busy few weeks for me and I haven’t had as much time to catch up on my reading as I’d have liked. This is the list of things that I have been / trying to read. Software Development at Microsoft Observed Microsoft Research paper on developers� typical tools and work habits and […]
Today marks the release of CTP6 of Visual Studio Team Edition for Database Professionals. I’m pretty excited to see the development of this Visual Studio product. Finally database developers will be able to work like other programmers. Extreme Programming methods will be useful. Through Visual Studio projects and source control more developers will be able […]
It seems to happen from time to time: your network engineers decide on a new network topology or naming scheme and they want to rename one or more of your SQL Server machines or worse your desktop machine! Renaming a SQL Server instance is not as simple as renaming the computer in My Computer Properties. […]
While producing a report for another team today, I wanted to build a database diagram to see the relationships in the source database. As I was working with a local copy of the database I decided to build a Database Diagram with Management Studio, but I received this error: Database diagram support objects cannot be […]
Or rather, why is there no “undo” in when working with Integration Services packages? This has been something that has me puzzled me since working with Beta 2 of Integration Services. I guess I figured it would be fixed by RTM, and just worked around the issue by regularly checking in finalised changes, and saving […]
If you want to be able to have your own template appear in Visual Studio when you add a new item to a project, this is where you will need to save it. Visual Studio 2005 Database Projects: C:\Program Files\Microsoft Visual Studio 8\Common7\Tools\Templates\Database Project Items Reporting Services 2005: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ ProjectItems\ReportProject Reporting […]
When SQL Server 2005 Management Studio’s Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP’s disabled, the service is not started or disabled. Start the SQL Server Agent service by: using the SQL Server Configuration Manger located in Start -> Microsoft SQL Server 2005 -> Configuration […]
Rebuilding the master database is done using the Rebuild Master utility “rebuildm.exe” which is located in the 80\Tools\Binn directory of the SQL Server installation. Select the server and instance that you want to rebuild. Now you are going to need access to the files from the install CD for SQL Server. Browse to the Data […]
Microsoft has quietly kicked out the final version of SQL Server 2005 and Visual Studio 2005 to MSDN subscribers ahead of the Launch Tour 2005. The .Net 2.0 Framework has also been released, which you will need to install/use either of these great things. If you’ve been keeping track of SQL Server 2005’s development, you’d […]
SQL Server 2005 September Community Technology Preview (CTP) has been released today by Microsoft and is available for download now. The September CTP will be the last CTP/Beta before Microsoft releases the RTM/Gold version in November. Its available in the same five flavours as before: Enterprise, Standard, Workgroup, Express, and Developer. Microsoft have said that […]
