June 2010 | Archive by Month | SearchSQLServer.com

Home
Archive
June 2010

June 2010

2010:

Is an Excel pivot table really business intelligence (BI)?

Although a pivot table is one component of Microsoft’s BI stack, it takes a lot more to create a full-fledged business intelligence solution.30 Jun 2010
Free sqlmap tool helps ward off SQL injection attacks

DBAs can minimize the risk of injection attacks on their databases with this open source utility designed for Microsoft SQL Server and other systems.24 Jun 2010
Applying algebraic and numeric functions in SQL Server 2008

Expand even more on T-SQL mathematical functions with this breakdown of algebraic and numeric functions, including details on how they can be used to retrieve data.22 Jun 2010
Getting ‘trigonometric’ with T-SQL mathematical functions

Mathematical functions in SQL Server 2008 can connect admins to system information that they may not know exists. Learn to apply these functions in this in-depth breakdown.22 Jun 2010
Scalability options for really big SQL Server databases

When a database outgrows its server, DBAs have the option of either scaling it out across multiple systems or moving to a more powerful server. Here are the factors to consider.18 Jun 2010
Walking through the database auditing process for SQL Server 2008 R2

SQL Server 2008 R2 features powerful tools for creating database auditing policies that can be implemented using either SQL Server Management Studio or T-SQL scripts.16 Jun 2010
Reporting Services 2008 R2 eases SQL Server report building

It’s true, Microsoft has put out a number of new BI technologies for SQL Server 2008 R2, but changes to existing tools like Reporting Services may hold the most value initially.14 Jun 2010
Cloud efforts advance, SQL Server evolves

MVPs Brent Ozar and Kevin Kline discuss the implications of Microsoft’s latest cloud computing efforts and what they mean to SQL Server BI, virtualization and more.10 Jun 2010
SQL Server backup and restore management tutorial

From system failure to catastrophic disaster, this guide features the backup and recovery know-how that can mean the difference between life and death for your SQL Server database.03 Jun 2010
SQL Server tools take the time out of database searches

Searching databases for specific objects can be frustrating – especially when you can’t recall exactly where said objects are. Fortunately, there are tools out there that can help.01 Jun 2010

More from Related TechTarget Sites

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

Business Analytics
- Retail analytics offers online stores an edge in holiday season
  
  The holiday shopping season is the most important time of the year for retailers, and they're increasingly turning to data analytics to try to get an advantage over their competition.
- Businesses moved beyond big data hype in 2014
  
  Big data has been hyped up for years, but this past year businesses started to move beyond all this hype to find ways to get real value out of the technology.
- Don't misfire on your targeted-marketing campaign
  
  Targeted-marketing campaigns don't always find their mark. When they go astray, the results can be ugly.
Data Center
- Network security professional says no to certs, yes to SDN
  
  Who needs security more than the government? Military man and network security pro, Brad Casey, talks certs and why sometimes, you just need to flip a switch.
- What's the best way to measure data center airflow?
  
  You can't measure airflow from raised floor tiles in the same way as any other air duct. Optimize data center airflow with the right tools.
- TIA standards, new ideas shape data center cabling
  
  TIA data center standards address cabling systems with performance, budget and future plans in mind. New concepts bear consideration as well.
Data Management
- Rules of thumb on handling DBA tasks, from author Craig Mullins
  
  Consultant and author Craig Mullins discusses some of his rules of thumb for helping database administrators contend with an increasingly complex set of responsibilities and duties.
- Mullins: Changing DBA responsibilities highlight profession in flux
  
  Author Craig Mullins discusses the evolving responsibilities of database administrators due to NoSQL systems and a growing need for mixed database management system environments.
- Mobile apps, machine data shape analytics trends in 2014
  
  The Internet of Things, the data lake and the "age of the customer" stole headlines this year. TechTarget editors explain why in this BizApps Today episode.
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
- Idexx uses Oracle EM for monitoring, plans EM provisioning
  
  Systems admin Brett Curtis proved the value of Oracle Enterprise Manager to Idexx. He uses EM for monitoring and he wants to move on to provisioning.
- Oracle builds up cloud engineering team, updates Solaris Studio
  
  Oracle added another high-level exec to its cloud engineering team, released Oracle Solaris Studio 12.4 and continued its legal battle with Oregon's state government.
- The seven deadly sins that lead to an Oracle audit
  
  Oracle is notorious for its confusing licensing policy. Robert Sheldon presents seven behaviors that can lead to an Oracle audit and costly audit fees.
Content Management
- Companies ignore social business strategy at their peril
  
  Companies that don't get on board with social business, the sharing economy and the Internet of Things do so at their peril, says an expert.
- What's disrupting the traditional ECM software market?
  
  Trends like the cloud, file sharing and mobile devices have changed traditional content management, said expert Ron Miller in this podcast.
- Search-based applications need the engine of taxonomy
  
  Designing functional taxonomies is one of the first steps in making search-based applications more effective. How can organizations map out classification schemes that will help return the most relevant search results?
Windows Server
- Windows Server cloud support unlikely bedfellow for Google
  
  Google's support of Windows Server mutually benefits both companies' platforms, but it may not be enough for a Microsoft shop.
- Avoid Windows Server 2003 upgrade gaffes
  
  When it comes to a move off of Windows Server 2003, know your migration risks with proper research, planning and management.
- Last Patch Tuesday of 2014 brings fixes for IE, Office
  
  Microsoft's last set of security fixes for the year brought critical fixes for Microsoft Office, VBScript and Internet Explorer.

All Rights Reserved,Copyright 2005 - 2014, TechTarget