SQL Server


SQL or No SQL for Big Data in the Cloud?

The relational model and SQL dominate today's database landscape, but NoSQL is gaining adherents in the era of "big data." But Roger Jennings says SQL and NoSQL may not be as exclusive as many developers think.

Deleting all Data from a SQL Server Database (Part 2)

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.

Deleting All 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.

Build Big-Data Apps in SQL Azure with Federation

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.

Crystal Reports vs. SQL Server Reporting Services

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.

Manage Database Design with Red Gate SQL Source Control

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.

DBA Goes Columbo on 'Invalid Object'

Mike worked as a SQL developer for a non-profit, debt management company that handled student loans.

A Well-Grounded Cloud

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).

SQL Server 2008 SP2 Now Available

Microsoft today released Service Pack 2 for SQL Server 2008.

Microsoft Kills Key Components of the 'Oslo' Modeling Platform

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.

SQL Server 2008 R2 for the Developer

Microsoft extends its enterprise-capable database platform with powerful new management and scalability features -- and there's plenty in the latest rev for developers.

Microsoft PowerPivot: Making Excel Analytics Work

A new component in SQL Server 2008 R2 gives users the autonomy to set up business intelligence functionality in Excel without taking control of the process away from IT.

Microsoft Issues New Windows Security Advisories

Microsoft issued even more details about Windows security concerns, even after releasing its August security update on Tuesday.

How to Get Oriented with a New Database

On VB author Joe Kunk shows how you can quickly discover the orientation of an unknown database using dynamic queries.

Microsoft Unveils Windows Small Business Server Previews

Microsoft on Monday announced two new "previews" to come for its Windows Small Business Server product suite.

Coming This Fall: Windows Azure Cloud Appliances

Addressing one of the key objectives of cloud computing, Microsoft today said its Windows Azure platform will be available as an appliance that can run on customer and partner premises.

Build Your Own 'Skunk Works' Business Intelligence Project with SQL

How to use SQL Server to build a business intelligence (BI) platform without getting your organization's top brass involved.

SQL Server 2008 R2 Released to IT Pros

Microsoft released versions of SQL Server 2008 R2 products to IT professionals on Monday.

SQL Server 2008 R2 Set to Analyze Mountains of Data, Coming in May

Developers with Visual Studio 2010 can package data-tier application components, including tables, views and stored procedures, as a single unit of deployment.

Microsoft Courts PHP Developers with Reporting Services SDK

Within the last two months, Microsoft has announced a command-line tool for PHP to deploy applications on Windows Azure, OData interoperability with PHP and guidance for using PHP with the Windows Azure Tools for Eclipse plug-in.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.