July 2010 | Archive by Month | SearchSQLServer.com

Home
Archive
July 2010

July 2010

2010:

SQL Server tool alleviates documentation headaches

Many database pros dread the hassle of SQL documentation. Fortunately, the right tool can speed up and simplify the process considerably.29 Jul 2010
Evaluating the ROI of a SQL Server 2008 R2 upgrade

Cool new features may not impress management, but return on investment always will. Speak an executive’s language when making the hard pitch for a SQL Server 2008 R2 upgrade.22 Jul 2010
Weighing the performance impact of SQL Server indexes

While the right indexes can boost readability, the wrong ones can really slow down write operations. DBAs need to strike the proper balance to ensure peak performance.20 Jul 2010
T-SQL subquery basics: When and how to apply them in SQL Server

Subqueries in T-SQL give admins flexibility when it comes to analyzing the inner details of subsets of data. Learn how to apply subqueries with this comprehensive rundown.16 Jul 2010
Combining T-SQL subqueries with operators in SQL Server

Using subqueries with different operators allows admins to collect even more information from T-SQL statement. Learn the basics of each and how to implement them here.16 Jul 2010
Latest SQL Server 2008 service pack beefs up R2 support

In addition to the usual updates and hotfixes, SQL Server 2008 SP2 will take better advantage of R2’s multi-server management and DAC capabilities.16 Jul 2010
Master data management without a SQL Server 2008 R2 upgrade

With careful planning, DBAs can get similar functionality to Microsoft’s MDS feature -- without migrating to R2 -- by taking advantage of older SQL Server technologies.13 Jul 2010
Microsoft Visual Studio 2010 spotlight

Visual Studio 2010 is the latest version of Microsoft’s application development platform, equipped with a slew of add-ons and new features. Learn more about what’s new here.08 Jul 2010
Programming SMO applications for improved management, automation

SQL Server Management Objects can be very helpful when used with (or even instead of) T-SQL, particularly when it comes to monitoring database backups and space utilization.07 Jul 2010

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Nate Silver lays out data-driven business strategy
  
  A lack of standards and best practices can hold back businesses from becoming more data-driven, says Nate Silver, founder and editor in chief for FiveThirtyEight. But they can overcome challenges.
- HP Vertica users put limits on using Hadoop for analytics
  
  Hadoop is one of the most popular big data technologies. But when it comes to predictive modeling and data visualization, its utility is somewhat limited, users of HP's Vertica system say.
- New business intelligence skills in, BI developers out
  
  Consultant Lee Feinberg says organizations need to build up their data storytelling and visualization capabilities -- and details a competition for finding people with the right business intelligence skills.
Data Center
- Network bottleneck looms when data center storage improves
  
  The high-IOPS, low-latency potential of SSDs moves bottlenecks to the network. SDN offers provisioning adjustments to avoid any slowdown in the data center.
- Colocation pricing morphs into cloud pay-per-use model
  
  Cloud computing users have been able to pay just for what they use, but that hasn't been an option for colocation customers -- until now.
- Is IT service continuity only for the rich?
  
  Technologies like cloud and virtualization mean IT service continuity no longer requires an extra data center or two.
Data Management
- IBM pushes MPP engine to boost cloud database services line
  
  IBM has added massively parallel processing and R language support to its dashDB software -- important steps for a data warehouse database tailored for distributed cloud computing.
- Swim fast with a Hadoop data lake architecture -- or sink
  
  The Hadoop data lake concept presents plenty of challenges for organizations. But the experiences of early adopters point the way toward successful data lake architecture deployments.
- Data preparation process comes under new scrutiny
  
  Data preparation processes are changing as business users cope with big data in all its variations, according to the latest Talking Data podcast.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- How to make sense of Oracle licenses for VMware environments
  
  Oracle licenses are a tricky subject and Oracle licensing for VMware environments doubly so. Find out about the important documents and policies that guide Oracle licensing and VMware.
- Oracle announces its new, lower-cost SPARC processor
  
  At Hot Chips 27, Oracle presented its new, lower-cost SPARC processor, Sonoma, which puts Oracle into competition with Intel x86 and the Xeon chip.
- Oracle Mobile Cloud will integrate with Xamarin platform
  
  Oracle Mobile Cloud Services will integrate with the Xamarin platform, which lets developers build, test and model mobile applications in C#.
Content Management
- Experts highlight potholes in the Office 365 roadmap
  
  Office 365 provides new options for lightweight collaboration, but experts at SPTechCon Boston said some features aren't ready for prime time yet.
- SharePoint 2016 beta is solid, but don't expect fireworks
  
  SharePoint 2016 beta makes some solid improvements for the user experience, but feels more like an update than a major new release, said one expert.
- Are text analytics tools the future of records management?
  
  In recent years, text analytics tools have simplified the time-consuming and onerous work of records management.
Windows Server
- With Azure Key Vault, cloud security no longer up in air
  
  Admins with an Azure subscription can use Azure Key Vault to protect and encrypt keys and data. Here's how to set it up with PowerShell.
- Control IT access with JEA PowerShell toolkit
  
  Just Enough Administration restricts administrative access to the bare necessities for user tasks, giving organizations more control over security.
- Tips for landing the best Windows administrator jobs
  
  Whether you're looking for the best Windows Server job or have been in your position for years, these five tips will help you strengthen your skills.

All Rights Reserved,Copyright 2005 - 2015, TechTarget