TechRepublic : A ZDNet Tech Community

11294 Resources for

databases

  • Subscribe to this listing via:
  • RSS
  • Email

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
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
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
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
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
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
Calculating Access fields with Null values
Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes. by Mary Ann Richardson
Tags: Microsoft Access, Formula, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
Blog posts 2008-07-01
Define custom error messages in SQL Server 2005
By defining custom error messages in SQL Server 2005, you can use the severity of these messages to illicit certain types of behavior from the database engine. Tim Chapman provides ideas on how to use custom error messages in your shop. by Tim Chapman
Tags: Message, Microsoft SQL Server, Microsoft SQL Server 2005, Error, Error Message, Custom Error Message, RAISERROR, CATCH, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-06-30
How do I quickly back up a database in SQL Server 2005?
This quick tip from Steven Warren shows you how to perform a simple backup in SQL Server 2005. by Steven Warren
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Backups, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Steven Warren
Blog posts 2008-06-27
What does a DBA do all day?
Data integrity is a DBA's number one responsibility, but do you know what else they do all day? Bob Watkins outlines some of the basic duties of a DBA. by Bob Watkins
Tags: Database Administrator, Data Integrity, Data, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Bob Watkins
Blog posts 2008-06-26
Save time and keystrokes with a Save Record button
Changes to an Access record aren't saved until the user moves to the next record -- which can sometimes mean tabbing through a bunch of controls just to execute the save. See how to add a Save Record button that lets the user save a record immediately after a change....
Tags: Microsoft Access, Command Button, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
Blog posts 2008-06-24
Is your site safe from SQL injection attacks?
Microsoft and HP announced yesterday that they are providing free tools to help network administrators to deal with the increase in SQL injection attacks over the last six months. by Andy Moon
Tags: Vulnerability, SQL, SQL Injection, Attack, Programming Languages, Security, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Andy Moon
Blog posts 2008-06-24
  • << Previous
  • page 1 of 565
  • Next >>


IT Professional's Guide to Policies and Procedures, Third Ed
Whether you're creating policies for management, training, personnel, support, privacy, Internet/e-mail usage, security, or inventory, you'll meet the needs of your entire enterprise with this one download!
Buy Now
Creating and Configuring Home Networks
Learn how to determine the best type of Internet connection for your needs, how to select a reliable provider, and how to set up your network for maximum efficiency, whether wired or wireless.
Buy Now

Boost Business Productivity