June 2008 | Archive by Month | SearchSQLServer.com

Home
Archive
June 2008

June 2008

2008:

Secure SQL Server from SQL injection attacks

Did you know that any Web application using dynamic SQL is at risk for a SQL injection attack? It's one of the most common security risks for Internet-facing SQL Server databases. In this tip, you'...25 Jun 2008
Tutorial: Migrating to SANs from local SQL Server disk storage

Making the leap to storage area networks (SANs) will ultimately improve performance in your SQL Server environment. Although SAN admins share responsibility, SQL DBAs must be involved from SAN setu...23 Jun 2008
How to restore SQL Server database to transition server during an upgrade

Part 2 of this series of articles describing a case history of a database upgrade from a Windows Server 2000/SQL Server 2000 Active/Active cluster focuses on using a transitional server. SQL Server...18 Jun 2008
Create a computed column in SQL Server using XML data

In this tip, SQL Server expert Robert Sheldon demonstrates how to create a function that runs the XQuery expression and then use that function within your computed column definition.16 Jun 2008
SQL Server memory configurations for procedure cache and buffer cache

To determine how much memory your SQL Server database uses for buffer cache and procedure cache, factor in the SQL version you're using, whether it's x86, x64 or Itanium and the amount of memory al...09 Jun 2008
How insiders hack SQL databases with free tools and a little luck

It only takes a few free security tools, a little luck and a malicious intent to put your SQL Server database at risk. IT security specialist Kevin Beaver walks you through a real-world scenario of...04 Jun 2008
Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003

This is the first in a series of articles describing the case history of a database upgrade from SQL Server 2000 Active/Active cluster running on Window 2000 Server to a Windows Server 2003/SQL Ser...03 Jun 2008

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