Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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....
- 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
- Blog posts 2008-06-24
- << Previous
- page 1 of 553
- Next >>
Content Types
- Blog posts (388 results)
- Book chapters (79 results)
- Case studies (968 results)
- Discussion threads (36 results)
- Download resources (161 results)
- Image galleries (8 results)
- Presentations (12 results)
- Research reports (2 results)
- Resource centers (2 results)
- Software downloads (6,586 results)
- Technical articles (353 results)
- Tools & templates (2 results)
- Training (74 results)
- Videos (1 results)
- Webcasts (591 results)
- White papers (1,778 results)
Refining Tags
- Software (11,053 results)
- Enterprise Software (11,027 results)
- Data Management (11,024 results)
- Hardware (5,682 results)
- Storage (5,203 results)
- Microsoft Windows (4,044 results)
- Mobile (2,038 results)
- Operating Systems (1,637 results)
- Marketing (1,440 results)
- Software/Web Development (1,358 results)
- Microsoft Office (1,314 results)
- Management (1,303 results)
- Office Suites (1,290 results)
- Microsoft Corp. (1,268 results)
- Microsoft SQL Server (1,235 results)
- Software Development (1,156 results)
- Oracle Corp. (1,114 results)
- Business Intelligence (1,093 results)
- Tools & Techniques (1,091 results)
- Microsoft Access (855 results)
- Programming Languages (838 results)
- SQL (677 results)
- Apple Macintosh (672 results)
- Pricing (625 results)
- Data Mining (592 results)
- Internet (552 results)
- Open Source (538 results)
- Server (484 results)
- Productivity (467 results)
- mysql (457 results)
- Servers (409 results)
- Microsoft SQL Server 2005 (380 results)
- Finance (377 results)
- Human Resources (375 results)
- Webcast (340 results)
- Advertising & Promotion (325 results)
- Personal Technology (301 results)
- Storage Management (286 results)
- Workforce Management (283 results)
- Business Operations (276 results)
- Online Communications (273 results)
- Web Development (259 results)
- Performance (259 results)
- Marketing Research (258 results)
- Oracle Database (254 results)
- .Net (243 results)
- E-mail (237 results)
- Data Recovery (236 results)
- IBM Corp. (236 results)
- Security (233 results)
