September 2010 | Archive by Month | SearchSQLServer.com

Home
Archive
September 2010

September 2010

2010:

Do you need to harden SQL Server 2008 R2?

Some say systems like R2 come so secure out of the box that traditional hardening need not apply. But when it comes to security, there’s still plenty to do beyond the defaults.28 Sep 2010
BI for SMBs: What's good for the big boys might be bad for you

Microsoft’s business intelligence stack is just one of the options available for midsized companies looking to implement a customized (and cost-effective) BI strategy.22 Sep 2010
Exploring T-SQL metadata functions in SQL Server 2008

Metadata functions in T-SQL can help uncover information about database names, objects and more. Learn the basics of metadata functions and how to apply them here.20 Sep 2010
Inspecting property settings with T-SQL metadata functions

There are plenty of other uses for SQL Server 2008 metadata functions beyond just the basics. This includes the ability to view object properties, such as columns and data types.20 Sep 2010
Uncovering database file information with T-SQL metadata functions

Admins can use metadata functions to reveal detailed information about SQL Server files and filegroups, including file names, IDs and file properties.20 Sep 2010
SQL Server 2008 R2 Express ready for install

Microsoft has upped the maximum database size for SQL Server 2008 R2 Express in what amounts to a major upgrade over previous versions.15 Sep 2010
Using file_guid as a unique identifier for SQL Server instances

DBAs can use the file_guid property to create a globally unique identifier for one or all of their SQL Servers by following a few simple steps.14 Sep 2010
Top seven things you don’t know about SQL Server 2008 R2

By now, everyone knows about PowerPivot and MDS. But while high-profile features like those have gotten most of the press, other changes to R2 have fallen under the radar.13 Sep 2010
Top five things you’re doing wrong with SQL Server

Are you hindering SQL Server without even knowing it? Check out the top mistakes DBAs often make with some quick fixes for better performance.08 Sep 2010
Project Houston offers cloud alternative for SSMS

Microsoft’s new Silverlight-based app provides database management from a browser, a convenience that could be extended to non-cloud databases in time.01 Sep 2010

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