In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.
There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, doing so may not be as easy as it seems.
Peter Vogel introduces a new column on application development in the real world, and begins by advocating for Language Integrated Query.
Peter Vogel introduces a new column on application development in the real world, and begins by advocating for Language Integrated Query.
Get ready to scale out SQL Azure databases beyond today's 50GB limit with the Transact-SQL and ADO.NET elastic sharding features, which are coming in the 2011 SQL Azure Federation Community Technology Previews.
- By Roger Jennings
- 03/01/2011
The frequency with which Microsoft has changed database access technologies is remarkable, with each new scheme offering the promise that .NET developers have finally arrived at a long-term solution.
- By Mark Michaelis
- 01/01/2011
If you're trying to decide whether to use Crystal Reports or SQL Server Reporting Services with ASP.NET, you can rest assured that there is no bad choice.
This complete package takes care of modeling data and managing the resulting designs -- provided you're using entity-relationship modeling to design your databases.
Red Gate SQL Source Control is a useful tool for SQL Server developers using TFS or Subversion, but falls short in managing database design changes.
Mike worked as a SQL developer for a non-profit, debt management company that handled student loans.
- By Kathleen Richards
- 11/01/2010
In a Redmond Review column last year ("What's Old Is New Again," April 2009), I discussed a move by Microsoft to reform its then-named SQL Data Services (SDS).
- By Andrew J. Brust
- 10/01/2010
LiveLINQ speeds up LINQ queries against in-memory collections by an order of magnitude -- but before you buy it, make sure you have the problems it solves.
Lennie Lobel, CTO of Sleek Technologies and a consultant at twentysix New York, is an expert on Entity Framework and Microsoft .NET Framework data-access technologies.
- By Readers of Visual Studio Magazine
- 10/01/2010
Microsoft today released Service Pack 2 for SQL Server 2008.
It's no surprise that 'Oslo', also known as SQL Server Modeling, has not survived the on-going battle of competing data platform strategies at Microsoft.
- By Kathleen Richards
- 09/22/2010