BT

SQL Server Unit Testing with tSQLt

by Jenni Konrad on  Feb 10, 2012 2

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.

MVP Erland Explores SQL Server Performance Concepts

by Roopesh Shenoy 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.

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

by Abel Avram 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.

Microsoft is Making a Play for MySQL Users

by Jonathan Allen 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.

SQLAzureMW Migrates SQL Databases to SQL Azure

by Abel Avram 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.

SQL Enlight T-SQL Analyzer

by Al Tenhundfeld 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.

Amazon's EC2 Switches from Beta to Production

by Abel Avram 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.

Microsoft SQL Server 2005 Driver for PHP Released

by Al Tenhundfeld 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.

Implementing NOLOCK with LINQ to SQL and LINQ to Entities

by Robert Bazinet 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.

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

by Hartmut Wilms 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.

Database Virtualization - Is it worth it?

by Jonathan Allen 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.

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

by Jonathan Allen 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.

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

by Hartmut Wilms 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.

Microsoft Ups Their Support for PHP

by Jonathan Allen 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.

Recursive Selects using Common Table Expressions

by Jonathan Allen on  Oct 05, 2007 8

Relational databases are great for storing most forms of structured data. The most notable exception is recursive data. Tree-like structures, essential for menus, normally require awkward stored procedures to efficiently return. SQL Server 2005 does have an answer though.

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2013 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT