InfoQ Homepage SQL Server Content on InfoQ
-
Amazon/Microsoft Deal Expanded to Include BizSpark and SQL Server 2012
Amazon has announced two licensing deals with Microsoft. The first eliminates the licensing fees for running Microsoft software on EC2 for BizSpark members. The second allows all developers to run the preview of SQL Server 2012 on EC2. It should be noted that normal EC2 service rates still apply for both.
-
Accelerate SQL Server Performance With SafePeak’s Dynamic Database Caching
SafePeak is a plug-and-play Dynamic Database Caching Solution, designed to improve data access performance for Applications built on SQL Server. It offloads the read queries and stored procedures which perform “Select” by dynamically caching in-memory result sets, thereby reducing read response time and overall database load.
-
.NET Framework 4 Now Supports LocalDB
Microsoft has added LocalDB support in .NET Framework 4. LocalDB is a free developer edition of SQL Server “Denali” meant to provide most of the server’s API but without management overhead.
-
'Denali' No More: SQL Server 2012 Announced, Focuses on BI and Big Data
Microsoft announced that the next version of SQL Server, known by the codename "Denali", will be called SQL Server 2012. It will feature the big data capabilities of Apache Hadoop and Power View, a touch-based business intelligence tool.
-
ORM Profiler Analyzes Data Access Performance
Solutions Design has released ORM Profiler, a tool meant to help improve data access layer performance. It tracks and logs ADO.NET calls so that developers can analyze their data access and discover potential problems.
-
Spatial Data Introduced to Entity Framework
One of the new additions in the Entity Framework June CTP is official support for Spatial data types, which allow developers to represent data using a system of coordinates, such as shapes, lines, or points on a map.
-
Sync Framework Breaks Platform Barriers
Sync Framework Toolkit builds on the Sync Framework 2.1 and uses OData to sync with any platform or client, including Windows Phone 7, Silverlight, Windows Mobile, iPhone, iPad, Blackberry, Android devices, and any browser using HTML5.
-
SQL Server Bids Farewell to OLE DB After Denali
Denali will be the final edition of SQL Server to support OLE DB, because Microsoft considers ODBC to be the industry standard for relational data access.
-
31 Days of SQL Server Interview Questions and Answers
Pinal Dave has posted a 31-part series titled SQL Server – Interview Questions and Answers. It starts with general topics such as “What is Normalization?” and works its way to obscure topics such as “What is Difference between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE?”. Data warehousing is covered and there are even guest posts on SQL Azure.
-
Visual Studio Gets Better SQL Server Tooling – ‘Juneau’
SQL Server Development Tools (SSDT) - ‘Juneau’ - brings testing, debugging, version control, refactoring, dependency checking, and deployment to database development in Visual Studio. It was previewed recently along with SQL Server ‘Denali’ CTP.
-
SQL Server Denali’s FileTable: Turn SQL Tables into Folders
SQL Server Denali includes a new type of table called FileTable, which builds on FileStream functionality. FileTable is meant for storing and managing unstructured data in SQL Server, while also making it accessible via the file system.
-
SQL Server 2008 R2 SP1 Brings Easier Schema Upgrades, Improved Query Performance
SQL Server 2008 R2 SP1 brings several features such as DAC Framework for easier schema upgrades, new DMVs and XEvents for better supportability, Improved Query Performance with ForceSeek and ForceScan and Disk space control for PowerPivot.
-
SQL Server ‘Denali’ CTP Gets Self Service BI Capabilities
Microsoft recently announced CTP 3 for SQL Server ‘Denali’, which boasts of improved BI capabilities like Self Service Alerting, Self Service Reporting, improved Office integration, SharePoint Shared Service, better VS Tooling for developers and more.
-
LocalDB: A Lightweight SQL Express for Developers
LocalDB is a new version of SQL Express that offers many of the same features, but installs faster, has fewer prerequisites, and doesn’t require management of a database instance. It supports T-SQL, and uses the same client-side providers as other versions of SQL Server, but runs in-process, rather than as a service.
-
MVP Erland Explores SQL Server Performance Concepts
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.