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 565
- Next >>
Content Types
- Blog posts (397 results)
- Book chapters (77 results)
- Case studies (907 results)
- Discussion threads (36 results)
- Download resources (161 results)
- Image galleries (8 results)
- Presentations (12 results)
- Research reports (2 results)
- Resource centers (1 results)
- Software downloads (6,904 results)
- Technical articles (353 results)
- Tools & templates (2 results)
- Training (78 results)
- Videos (1 results)
- Webcasts (571 results)
- White papers (1,784 results)
Refining Tags
- Software (11,302 results)
- Enterprise Software (11,276 results)
- Data Management (11,273 results)
- Hardware (5,910 results)
- Storage (5,420 results)
- Microsoft Windows (4,086 results)
- Mobile (2,310 results)
- Operating Systems (1,630 results)
- Marketing (1,427 results)
- Microsoft SQL Server (1,402 results)
- Software/Web Development (1,374 results)
- Microsoft Office (1,359 results)
- Office Suites (1,335 results)
- Management (1,325 results)
- Microsoft Corp. (1,231 results)
- Software Development (1,168 results)
- Tools & Techniques (1,102 results)
- Oracle Corp. (1,097 results)
- Business Intelligence (1,081 results)
- Microsoft Access (874 results)
- Programming Languages (854 results)
- SQL (693 results)
- Apple Macintosh (681 results)
- Pricing (626 results)
- Internet (604 results)
- Data Mining (597 results)
- Open Source (533 results)
- Server (493 results)
- Productivity (491 results)
- mysql (454 results)
- Servers (411 results)
- Finance (378 results)
- Human Resources (372 results)
- Microsoft SQL Server 2005 (355 results)
- Personal Technology (337 results)
- Webcast (331 results)
- Advertising & Promotion (302 results)
- Online Communications (294 results)
- Storage Management (291 results)
- Workforce Management (287 results)
- Business Operations (278 results)
- Web Development (261 results)
- E-mail (260 results)
- Marketing Research (256 results)
- Performance (254 results)
- Oracle Database (250 results)
- Consumer Electronics (238 results)
- Data Recovery (237 results)
- .Net (236 results)
- IBM Corp. (235 results)
