In this article, we focus specifically on highlighting new features in the GDR, including its support for offline schema development, tools that support new processes that you can use when you develop a database schema, and features that support database administration.
2009-03-20
2,208 reads
In this article Dinesh Priyankara shows how Visual Studio Team Edition for Database Professionals can be used to perform data comparison.
2008-03-26
2,707 reads
This article from MSDN discusses the benefits of TDD and bringing unit testing to your database development.
2008-03-07
3,320 reads
In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.
2008-01-24
3,280 reads
The Visual Studio 2005 Team Edition for Database Professionals (a.k.a Data Dude) was released somewhere around December 2006 helping many Database Administrators and Database Developers. The release was huge for us, because it addresses many issues faced by us.
2008-01-09
3,641 reads
2003-06-11
Thank you for the suggestions. We have gone through the syscacheobjects table. Note that the setopts values are not completely documented for SQL 2000. And this problem arises because a trigger has three possible caching objects, but setopts can only use two. A multirow trigger har no special setopts, and a single row trigger has […]
2003-06-04
1 reads
I have two tables.Employeecustomedetail with field freetext04 and another table occupation with the field name. Now both freetext04 and occupation contains an employee's occupation. HOwever in freetext04 the occupation will be i.e 'rigger' and in occupation.name it will be rigger0260. How do I write a statement that compares these two fields? Does it make more […]
2003-05-15
Try creating dynamic sql and parse the briefcase and add case statements to the dynamic sql to do the order by. declare @briefcase varchar(100),@work varchar(100),@this varchar(10),@order varchar(1000),@ct int,@num int declare @sql nvarchar(4000) set @briefcase = '47,36,187' set @work = @briefcase set @order = '' set @num = 0 while @work <> '' begin set @ct […]
2003-05-13
Right click on My Computer, select Manage, select Services. Or, open Control Panel and click on Services. Do you see SQLSERVERAGENT in the list of services?
2003-05-07
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers