July 2012 | Archive by Month | SearchSQLServer.com

Home
Archive
July 2012

July 2012

2012:

SQL Server training benefits for non-DBAs

DBAs know the value of SQL Server training. But what are the benefits for non-DBAs? This tip by Serdar Yegulalp examines who should learn more about SQL Server.19 Jul 2012
T-SQL tricks for SQL Server 2012: T-SQL functions

In this second in a series of tips about new T-SQL features in SQL Server 2012, expert Robert Sheldon explores more tricks for getting the most out of T-SQL functions.17 Jul 2012
Compare and synchronize databases with SQL Compare

Do you frequently need to compare or synchronize your databases? Read this tip by SQL Server expert Roman Rehak to learn the secrets of effective database synchronization using SQL Compare.13 Jul 2012
T-SQL tricks for SQL Server 2012: The joy of data values

In the first article in a series by about changes and new features in T-SQL in SQL Server 2012, expert Robert Sheldon explores the PARSE and TRY_PARSE functions.03 Jul 2012
Fault tolerance and backups and snapshots, oh, yes

They are vital tools all DBAs depend on. But what are the best products on the market these days? Expert Don Jones lets us know some of his favorites.02 Jul 2012

More from Related TechTarget Sites

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

Business Analytics
- Bring data analysis methods to the masses
  
  Many members of the general public, which includes business executives, don't really understand what analytics is all about. It's up to data scientists to educate them.
- Self-service analytics needs strong data architecture foundation
  
  The adoption of self-service BI and analytics tools continues to grow. But understanding how to support their use is a must -- and that starts with a solid architecture for analytics.
- Streaming data systems take big data analytics into real-time realm
  
  Technologies that support real-time data streaming and analytics aren't for everyone, but they can aid organizations that need to quickly assess large volumes of incoming information.
Data Center
- What's the effect of network switch buffer in a data center?
  
  What's causing buffer? How much buffer should ideally be available in a network switch? Is there any standard available for buffer?
- Address common problems in mainframe testing concepts
  
  Accurate mainframe testing data is hard to obtain. This overview covers testing concepts, problems and tool options for improving test data management.
- Avoid common server racking issues
  
  Increasing physical demands of modern IT gear can pose problems for classic rack enclosures. Watch for these factors when buying new racks or equipment.
Data Management
- Key considerations for determining if a NoSQL DBMS meets your IT needs
  
  NoSQL represents the fastest-growing type of DBMS being adopted today. Is it right for you?
- For some companies, business applications in the cloud is first choice
  
  Cloud applications are no longer curious IT experiments -- now they're often on shortlists of deployment options.
- Couchbase, VoltDB pursue more database scalability in big data apps
  
  New database updates address large-scale applications. Included are Couchbase Server 4.0 with multidimensional scaling support and VoltDB 5.0 with links to Hadoop data streaming tools.
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
- Federal Court returns patent lost in Google vs. Oracle case
  
  During the Google vs. Oracle court case, a lower court ruled to invalidate an Oracle patent. Now, a federal court has given Oracle the patent back.
- Oracle Marketing Cloud uses big data to help higher ed
  
  Oracle releases Oracle Marketing Cloud products for colleges and data-as-a-service users, and a judge decides to keep the Oregon lawsuit in-state.
- Constant currency-tinted lenses make for a better looking Q3
  
  Oracle's third-quarter financial results look very similar to last year's, but with constant currency the picture is much brighter. And the Oracle cloud business was particularly strong, company execs said.
Content Management
- Using IoT technologies to fuel interconnected experiences
  
  IoT technology and mobile apps generate new concerns, including how to create interconnected digital experiences for users.
- Does my mobile WCM need apps or a responsive site?
  
  Responsive design can help a website display properly on a wide range of devices, but sometimes mobile apps are better suited to business needs.
- Is SharePoint in the cloud the right fit for your company?
  
  SharePoint Online can reduce costs and ease management headaches, but not without a few functionality tradeoffs. Companies should be familiar with shortcomings before making the move into the cloud.
Windows Server
- This PowerShell module takes control of NTFS permissions
  
  One simple install of the File System Security PowerShell Module can help manage NTFS permissions for user access to folders.
- Five must-read Windows administrator books
  
  With plenty of titles on the market, it's tough to whittle down a reading list. Our expert has made a list of required reading.
- What are some free or cheap Windows resources for server admins?
  
  You don't have to break the bank when it comes to finding resources for managing Windows Server.

All Rights Reserved,Copyright 2005 - 2015, TechTarget