TechRepublic : A ZDNet Tech Community

14381 Resources for

data management

  • Subscribe to this listing via:
  • RSS
  • Email
Related Tags: enterprise data management (8 results)

TechRepublic Resources

How do I assign permissions to users to see SQL Agent Jobs?
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server. by Tim Chapman
Tags: Job, Permission, Microsoft SQL Server, SQL, SQLAgentReaderRole, SQLAgentUserRole, SQLAgentOperatorRole, NULL, INT, END, Recruitment & Selection, Advertising & Promotion, Databases, Human Resources, Workforce Management, Marketing, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-08-06
How do I change the name of my SQL Server?
Did you know that when you change the name of a server that you also have to change the name in SQL Server? It's not that difficult, but if you don't you'll cause problems. Steven S. Warren shows you how. by Steven Warren
Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren
Blog posts 2008-08-05
Fine-tune your Access queries to remove duplicate entries from your mailing lists
If you query your Access database to generate a mailing list, but the list contains duplicate names and addresses, this helpful trick will save you some time. See how tweaking the query properties can ensure a list with unique entries. by Mary Ann Richardson
Tags: Microsoft Access, Query, Mailing List, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
Blog posts 2008-08-04
Using SQLCMD to execute SQL scripts
If you use the same SQL scripts repeatedly, you can save a lot of time by creating a batch file for them. SQLCMD can help you build those batch files. Steven S. Warren shows you how to use SQLCMD to execute scripts in SQL Server 2005. by Steven Warren
Tags: Script, SQL, Batch File, Databases, Enterprise Software, Software, Data Management, Steven Warren
Blog posts 2008-07-31
An outage: Lessons learned
Westminster College does not currently have a backup generator protecting its data center and telephone system. That is about to change. Backup generators are no longer optional. That--and other lessons learned--from recent outages at the college. by Scott Lowe
Tags: Phone, Data Center, Payroll, Outage, Backup Generator, Data Centers, Storage, Backups, Payroll Solutions, Operational Accounting, Hardware, Data Management, Finance, Scott Lowe
Blog posts 2008-07-30
Visually group Access data with lines, rectangles, and back color
With a few simple formatting tweaks, you can make your Access reports far easier to read and interpret. by Mary Ann Richardson
Tags: Microsoft Access, Rectangle, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
Blog posts 2008-07-29
Removing Duplicate Records using SQL Server 2005
Removing duplicate records from tables is sometimes an arduous task, especially if the source table does not contain a primary key field. Here's how you can take advantage of a new SQL Server 2005 feature to remove duplicates quickly and efficiently. by Tim Chapman
Tags: Microsoft SQL Server, Record, Microsoft SQL Server 2005, Table, SalesHistory, SaleDate, SalePrice, SELECT, Productivity, Databases, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-07-29
How to reference an Access subform
Referencing a control on an Access form is easy. Referencing a subform and its controls is a little more complex. To Access, a subform isn't a form at all, but a control, so you must reference it as such. by Susan Harkins
Tags: Microsoft Access, Control, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
Blog posts 2008-07-28
Dell launches high performance 2U desktop that lives in the data center
With the Precision R5400, Dell has opted for performance over space savings and cost trimming for its data center-hosted desktop solution. See why there might be an interesting ROI case to be made for all this computing power. by Jason Hiner
Tags: Dell Computer Corp., Data Center, High-performance, Precision R5400, Workstations, Data Centers, Desktops, Roi/Tco, Servers, Storage, Hardware, Data Management, Finance, Managerial Accounting, Jason Hiner
Blog posts 2008-07-24
Coming soon to your data center... freaking huge workstations!?
Dell has released a new centrally managed workstation that consists of a full PC and a remote access terminal. Is there a market for this? Will Dell start to contribute to further sprawl in the data center? Scott Lowe ponders these questions. by Scott Lowe
Tags: Desktop, Dell Computer Corp., Data Center, Workstation, ClearCube Technology, Scott Lowe, Data Centers, Remote Access, Storage, Hardware, Data Management
Blog posts 2008-07-24
Use Access table validation rules to protect data integrity
When the validity of data in one field depends on what's entered in another field, you'll want to build a validation rule. Here's a step-by-step look at the process. by Mary Ann Richardson
Tags: Microsoft Access, Field, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
Blog posts 2008-07-22
Four ways to reduce energy costs and environmental impact
With green IT, it doesn't take a whole lot of effort to make an impact in your organization. Here are four ways to get started and see the impact on ROI. by Scott Lowe
Tags: Desktop, Disk, Data Center, SAN, ROI, Server Consolidation Project, Server Consolidation, Roi/Tco, Data Centers, Servers, Hardware, Finance, Managerial Accounting, Storage, Data Management, Scott Lowe
Blog posts 2008-07-21
Avoiding Cursors with SQL Server 2005
Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. Tim Chapman shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them. by Tim Chapman
Tags: Microsoft SQL Server, Cursor, Microsoft SQL Server 2005, Inventory, InventoryDate, InventoryCount, DATEADD, GETDATE, SELECT, BigScreen, PoolTable, Databases, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-07-21
The "real skinny" on green computing
Virtualization also fits in very nicely with the idea of "Green Computing"; by consolidating servers and maximizing CPU processing power on other servers, you are cutting costs saving money and taking less of a toll on our environment. As a decision maker in your company, coming up with ways to...
Tags: Data Center, Virtualization, Power Consumption, Computing, Green Computing, Server Consolidation Initiative, Data Centers, Storage, Server Consolidation, Servers, Hardware, Data Management, Steven Warren
Blog posts 2008-07-20
Build related tables with the Access 2007 Lookup Wizard
The Access 2007 Lookup Wizard makes it easy to create a related table. This walk-through demonstrates how it works. by Mary Ann Richardson
Tags: Job, Microsoft Access, Job Title, Table, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
Blog posts 2008-07-15
How do I... Reseed a SQL Server identity column?
Microsoft SQL Server’s identity column generates sequential values for new records using a seed value. Seeding and reseeding an identity column is easy and relatively safe, if you do it correctly. Susan Sales Harkins shows you how it works. by Susan Harkins
Tags: Microsoft SQL Server, Server, Column, Value, Identity, Table, Identity Column, Seed Value, Term Seed, TRUNCATE TABLE, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management, Susan Harkins
Blog posts 2008-07-15
Navigating the Access 2007 Navigation Pane
Access 2007's Navigation Pane displays only tables unless you tell it otherwise. Find out how to set it so that other objects show up there, too. by Mary Ann Richardson
Tags: Microsoft Access, Access 2007, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
Blog posts 2008-07-08
Create custom looping procedures in SQL Server 2005
Tim Chapman shows how to create system stored procedures that will allow you to loop through and execute statements against any type of object in SQL Server 2005. by Tim Chapman
Tags: Stored Procedure, Microsoft SQL Server, SQL, Microsoft SQL Server 2005, CLR, Exec, N, Tim, System Stored Procedure, NVARCHAR, Databases, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-07-08
IT employment holds steady despite job losses in broader U.S. economy
The U.S. economy lost 62,000 jobs in June for the sixth straight month of employment losses with an unemployment rate of 5.5 percent, but underneath the technology sector is holding up well, according to Labor Department statistics. by Larry Dignan
Tags: Data Centers, Data Management, Hardware, Human Resources, Information Technology, Job, Job Loss, Larry Dignan, Management, Recruitment & Selection, Storage, Strategy, Technology Sector, U.S. Department Of Labor, Workforce Management
Blog posts 2008-07-03
Take advantage of undocumented SQL Server iteration procedures
Here's a look at how you can use two built-in system stored procedures -- sp_msforeachdb and sp_msforeachtable -- to iterate through SQL Server tables and databases. by Tim Chapman
Tags: Microsoft SQL Server, Server, Tim, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-07-03
  • << Previous
  • page 1 of 720
  • Next >>


Quick Reference: Linux Commands
Reduce stress and speed up resolutions with the easiest command references right at your fingertips. You'll receive a PDF file covering Linux, packed with the most common commands you'll need and use daily.
Buy Now
500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now

Popular Sanity Saver Videos