Problem solve

Microsoft SQL Server 2008 R2

• Pros and cons of SQL Server 2012

  Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and “the unknown” might keep you away for now. Continue Reading

• Speed up execution times in Microsoft SQL Azure

  Compare the time cost of database calls to SQL Azure versus calls to a local server and get recommendations for improving the speed of database calls to SQL Azure. Continue Reading

• Microsoft SQL Server 2012 pricing, licensing packed with changes

  SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing. Continue Reading

• SQL Server stored procedures supercharged in recent, upcoming versions

  Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release. Continue Reading

• Parallel Data Warehouse has speed, space, special requirements

  Microsoft Parallel Data Warehouse is not like other software. The appliance for SQL Server 2008 R2 allows for mammoth workloads; it also has some specific data loading procedures. Continue Reading

• Putting SQL Server catalog views to work

  SQL Server catalog views are system views that provide an interface to a wide range of catalog metadata, including information about security objects, full-text search, database mirroring, partitions and more. Read on for an in-depth look at several...Continue Reading

• Pros and cons of the DACPAC with SQL Server 2008 R2

  Data-tier applications are among SQL Server 2008 R2’s most talked-about new features, though version-one limitations could minimize their impact in the short term.Continue Reading

• Getting set up for multi-server management with SQL Server 2008 R2

  One of SQL Server 2008 R2's most talked-about new features allows DBAs to monitor the performance of multiple instances with a single glance.Continue Reading

• How to use SQL Server 2008 hierarchyid data type

  SQL Server 2008 offers the new hierarchyid data type – an improved method for storing and querying data. Stored procedures can dynamically find their way up the employees' management tree but they make for complex, resource-intensive queries. ...Continue Reading