I don't know if this is the right place for this question or not but I'm hoping someone can point me in the right direction. I have a project in mind that requires a database and I would like to begin ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

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. In part one of this article, I described a ...

Ok, I am pretty new to the whole Web App, Databases, etc... I have built one App so far that used CF&SQL server to search a Database. Now I have a new initiative. I want to build A web app that will ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

Microsoft announced the latest preview of its next-gen SQL Server product at Ignite. Here's a rundown of everything the new release promises, from performance enhancements to security and availability ...

Having recently set up an old desktop as a dev machine in order to avoid trashing my main computer with evaluation software (don't get me started), I decided it was time to try out Visual Studio 11 ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...