Sponsored White Papers, Webcasts, and Downloads
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
- 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
- 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
- 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
- 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
- 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
- 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
