31 Days of SQL Server Interview Questions and Answers

by Jonathan Allen on  Aug 05, 2011

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’

by Roopesh Shenoy on  Jul 30, 2011

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

by Jenni Konrad on  Jul 28, 2011

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

by Roopesh Shenoy on  Jul 22, 2011

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

by Roopesh Shenoy on  Jul 15, 2011

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

by Jenni Konrad on  Jul 14, 2011

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

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.

Cloud-Based Server Management and Troubleshooting with System Center Advisor

by Jenni Konrad on  Jun 30, 2011

Microsoft System Center Advisor is a new cloud-based service that analyzes installations of Windows Server 2008 and SQL Server 2008 (and later versions). It tracks configuration changes and upgrades, and reports on potential issues due to missing security patches, incompatibilities, or deviations from best practices.

SQL Azure Database Scalability with Federations

by David Cooksey on  Jun 23, 2011

Cihan Biyikoglu introduced an upcoming feature for scalability in SQL Azure databases called Federations at Tech Ed 2011. Federations are objects inside the database which allow the data in their contained tables to be distributed across additional databases called federation members. Data can be re-distributed across Federation members at run-time.

SQL Server Denali: Microsoft Wants Your Feedback on Upgrade Paths and Supported Operating Systems

by Jenni Konrad on  Jun 16, 2011

Microsoft posted the proposed list of SQL Server Code Name Denali upgrade paths and operating systems, and is soliciting feedback on their selections. Windows XP and 2003 are excluded, and versions of SQL Server may require service pack updates before a new Denali installation.

Visual Studio Database Development with SQL Server "Juneau"

by Jenni Konrad on  Jun 09, 2011 3

SQL Server Development Tools (SSDT), codenamed "Juneau", provide a new Visual Studio-based development environment for SQL Server. Some of its features are already available in Visual Studio 2010 Ultimate, but SSDT includes some key new additions such as the close integration of Database and Application Projects.

Balanced Data Distributor: Improve SSIS Performance with Parallelism

by Jenni Konrad on  Jun 02, 2011 1

The Balanced Data Distributor is a multithreaded data flow transform tool for SQL Server Integration Services 2008. It's intended to improve performance in multi-core and multi-processor server environments by distributing data to multiple outputs.

SQL Server 2008 SP1 and Feature Pack CTP Bring New Features and Tools

by Abel Avram on  Apr 28, 2011

Microsoft has announced the availability for download of SQL Server 2008 R2 SP1 CTP, including all cumulative updates, and SQL Server 2008 R2 SP1 Feature Pack CTP1, containing a number of stand alone tools adding more value to SQL Server 2008.

Column-based Storage in SQL Server 2011

by Jonathan Allen on  Mar 07, 2011 4

Imagine ad hock data mining queries against a single table with 1 TB of data and 1.44 billion rows coming back in roughly a second. This is the scenario Microsoft intends to support using 32-core machines and their new column-based storage engine.

Partitioning and Sharding Options for SQL Server and SQL Azure

by Jonathan Allen on  Feb 14, 2011 1

Horizontal partitioning and sharding are important tools for developers working with extremely large datasets. We take a brief look at what’s available in SQL Server and what’s coming down the road.

General Feedback
Marketing and all content copyright © 2006-2015 C4Media Inc. hosted at Contegix, the best ISP we've ever worked with.
Privacy policy