BT

Your opinion matters! Please fill in the InfoQ Survey!

Development Follow 194 Followers

SQL Server 2005 is No Longer Receiving Security Updates

by Jonathan Allen Follow 197 Followers on  May 04, 2016 2

SQL Server 2005 has now officially hit its end of life. This means that it will no longer receive security updates and new vulnerabilities that are discovered will go unfixed. Yet a recent survey commissioned by Microsoft showed that 46% of companies using SQL Server had at least one production machine running SQL Server 2005.

Followers

SQL Server Unit Testing with tSQLt

by Jenni Konrad Follow 0 Followers on  Feb 10, 2012

tSQLt is a free, open-source framework for unit testing in SQL Server. By writing tSQLt test cases, developers can create fake tables and views based on production data, then compare expected versus actual results. Tests can be created directly in SQL Server Management Studio.

Followers

MVP Erland Explores SQL Server Performance Concepts

by Roopesh Shenoy Follow 0 Followers on  Jul 13, 2011

In "Slow in the Application, Fast in SSMS?", SQL Server MVP, Erland Sommarskog, explores the various things that affect Query Plan, compilation of Dynamic SQL and other things that ultimately affect your SQL Server Database Performance. He covers various concepts and scenarios like parameter sniffing, query plan caching, Blocking, saved settings, issues with linked servers and more.

Followers

Migrating from MySQL/Access to SQL Server/Azure with SSMA

by Abel Avram Follow 4 Followers on  Aug 17, 2010

Microsoft has released the SQL Server Migration Assistant (SSMA) for MySQL 1.0, and has refreshed SSMA for Oracle v4.2, SSMA for Sybase v4.2, and SSMA for Access v4.2. These toolkits helps customers migrating their MySQL/Oracle/Sybase/Access databases to SQL Server and some even to SQL Azure.

Followers

Microsoft is Making a Play for MySQL Users

by Jonathan Allen Follow 197 Followers on  Jan 19, 2010

Microsoft has released its first community tech preview for a MySQL to SQL Server migration tool. This tool supports SQL Server 2005, 2008, and Azure.

Followers

SQLAzureMW Migrates SQL Databases to SQL Azure

by Abel Avram Follow 4 Followers on  Sep 03, 2009

The SQL Azure Migration Wizard (SQLAzureMW) is a CodePlex project and wizard that can be used to migrate SQL 2005 and SQL 2008 databases to SQL Azure.

Followers

SQL Enlight T-SQL Analyzer

by Al Tenhundfeld Follow 0 Followers on  Apr 29, 2009

SQL Enlight is a tool designed to expedite and facilitate T-SQL development through code analysis and templating. SQL Enlight integrates into MS Visual Studio and SQL Management Studio.

Followers

Amazon's EC2 Switches from Beta to Production

by Abel Avram Follow 4 Followers on  Oct 24, 2008

Amazon's EC2 services are no longer offered as beta, but they have been switched into production, Amazon offering a Service Level Agreement (SLA). Windows on EC2 is still available as beta.

Followers

Microsoft SQL Server 2005 Driver for PHP Released

by Al Tenhundfeld Follow 0 Followers on  Aug 05, 2008

Version 1.0 of the Microsoft SQL Server 2005 Driver for PHP has been released, allowing greater interoperability between PHP and MS SQL 2005. The driver is available for download on MSDN, and the source code for the driver is available on Code Plex.

Followers

Implementing NOLOCK with LINQ to SQL and LINQ to Entities

by Robert Bazinet Follow 0 Followers on  Mar 21, 2008 1

Scott Hanselman recently posted a really useful article on his blog covering the NOLOCK hint when using LINQ to SQL and LINQ to Entities. The problem is actually how to get the SQL generated by LINQ queries to use the NOLOCK hint as SQL developers are accustomed.

Followers

SQL Server Data Services: Microsoft's Answer to Amazon S3

by Hartmut Wilms Follow 0 Followers on  Mar 06, 2008 2

Microsoft has announced SQL Server Data Services (SSDS) at MIX08. Being a storage service on the web, SSDS is Microsoft's Amazon S3 competitor.

Followers

Database Virtualization - Is it worth it?

by Jonathan Allen Follow 197 Followers on  Feb 12, 2008 3

Hosting server applications inside VM images is all the rage today. The ability to quickly move a virtual server from one machine to another as needs change is a big win for IT departments. But can this be applied to heavyweight systems like SQL Server? Conor Cunningham says no.

Followers

SQL Server Best Practices Analyzer to be Integrated into SQL Server 2008

by Jonathan Allen Follow 197 Followers on  Jan 23, 2008

Microsoft is looking to change how SQL Server is managed by incorporating the SQL Server Best Practices Analyzer into the core of SQL Server 2008. This new feature, known as the Declarative Management Framework, allows for proactive enforcement of database policies.

Followers

Post-VS 2008-Technology: LINQ to XSD and LINQ to Stored XML

by Hartmut Wilms Follow 0 Followers on  Dec 05, 2007 2

Today, Shyam Pather, Principal Development Lead on the Data Programmability Team at Microsoft, is giving a presentation on LINQ to XML: Visual Studio 2008, Silverlight, and Beyond at the XML 2007 Conference in Boston. He talks about the current and future technologies surrounding LINQ to XML.

Followers

Microsoft Ups Their Support for PHP

by Jonathan Allen Follow 197 Followers on  Nov 27, 2007

PHP is a cornerstone of LAMP development. In an attempt to lure PHP developers off Linux and MySQL, Microsoft is beginning to offer deep support for PHP in IIS 7 and SQL Server.

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT