Home
Archive
November 2007

November 2007

2007:

Tricks to increase SQL Server query performance

Increase query performance in SQL Server by having a few tricks up your sleeve to avoid system table locking and improve query response time.28 Nov 2007
Database mirroring factors to consider before setup

Before setting up database mirroring in SQL Server 2005, consider a few pre-deployment factors. SQL Server MVP Hilary Cotter outlines database and server needs and network requirements that will gu...26 Nov 2007
SQL Server 64-bit applications and performance drawbacks

Common knowledge would suggest 64-bit applications perform better than 32-bit applications on SQL Server. Windows expert Serdar Yegulalp examines some drawbacks of the 64-bit architecture.19 Nov 2007
Reorganize permissions in SQL Server 2005 step by step

Are you a DBA trying to manage SQL Server permissions in an environment with dozens of servers, hundreds of databases and thousands of users? If you're reading this, chances are the answer is yes. ...14 Nov 2007
Why store sensitive SQL Server data if you don't have to?

Is your organization storing sensitive data indefinitely? IT security expert Kevin Beaver examines how organizations store data unnecessarily, a practice that can lead to data security risks and da...14 Nov 2007
Configure aliases for SQL Server databases and servers

Aliased names can save you from changing your code and configuration files when you need to point your application to another server or move the location of database objects. In this tip, you'll fi...12 Nov 2007
Stored procedure to find fragmented indexes in SQL Server

Fragmented indexes and tables in SQL Server can slow down application performance. Here's a stored procedure that checks for fragmented indexes in all servers and databases.07 Nov 2007
SQL Server backup and restore commands to limit downtime

Whatever SQL Server backup and restore solution you choose, you must be sure to back up your data in an acceptable amount of time and restore it in an acceptable amount of time. SQL Server MVP Hila...05 Nov 2007

More from Related TechTarget Sites

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

Business Analytics
- News recap: Data mining techniques help stop fraud, new IBM offerings
  
  In this news recap, federal agents use data mining techniques to stop fraud and IBM releases new self-service offerings.
- How to prep your big data architecture for better analytics
  
  Collecting big data sets doesn't mean you're ready to do big data analytics. Read these tips on setting the stage with big data architecture.
- Social media analysis: Valuable tool or overhyped technology?
  
  Companies need to ask some basic questions to determine whether they'll gain business value from social media analytics, says expert Mark Whitehorn.
Data Center
- Non-mechanical options for green data center cooling
  
  The local climate determines which green data center cooling technologies, such as free air cooling and water economizers, will keep servers happy.
- What's the highest server temperature you can handle?
  
  There's no correct inlet air temperature for all servers. Age, performance and design help determine how much heat your server can handle.
- PowerShell tutorial for Windows server admins
  
  A lot has changed with PowerShell 4.0. Whether you're new to the CLI or want new tricks in your server administrating bag, now's the time to bone up.
Data Management
- Former shadow IT worker helps bring analytics data into the light
  
  Ryan Fenner worked in a shadow IT unit at Union Bank for years. Now he's helping lead an IT effort to better manage BI data created in those shadows.
- Podcast report covers recent Enterprise Data World event
  
  This week's Talking Data podcast recaps Enterprise Data World and a mother lode of data quality information.
- Is data architecture comfortable in the cloud?
  
  Data architecture and cloud were strangers at first, as security concerned IT. That will change, say reporters in 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
- Lydall says no to Oracle's forced updates, upgrades with Rimini Street
  
  Rimini Street helped Lydall get away from forced updates and upgrade between two versions of Oracle EBS not supported by Oracle.
- Oracle Database hosting quiz: In-house, hosted or cloud systems?
  
  Take this 10-question quiz to find out if your Oracle databases should be run on-premises, in a hosted environment or in the cloud.
- Oracle takes on Google, SAP, Comcast in copyright protection lawsuits
  
  Oracle begins this spring in search of copyright protection with lawsuits against Google, SAP and Comcast.
Content Management
- Five key questions about social media monitoring and analytics
  
  For companies that want to derive business value from social media monitoring and analytics, our expert has answers.
- SharePoint 2013 analytics provides insight into public-facing sites
  
  For a more useful view on who's visiting your public-facing sites, try connecting SharePoint 2013 to a Web analytics engine.
- SharePoint 2013 analytics provides new insight on internal users
  
  Just as social media analytics tools mine customer data, SharePoint 2013 analytics allows enterprises to take stock of internal users' activities.
Windows Server
- Microsoft pushes Azure, leaves data centers in the dark
  
  Microsoft’s enterprise vision revolves around cloud computing, so where do users of products like System Center Configuration Manager stand?
- Two ways to deploy Windows Azure Pack
  
  There's more than one way to install Windows Azure Pack. We outline two methods to help you determine which is best for your company.
- Do I need Windows Azure Pack Update Rollup 1?
  
  Learn more about what's new in UR1 for Windows Azure Pack and how to decide if your organization should deploy it.

All Rights Reserved,Copyright 2005 - 2014, TechTarget