Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Secure SQL Server: Encryption and SQL injection attacks
- By Susan Sales Harkins and Mike GunderloyWelcome to the final installment of our series on SQL Server security. So far, we've explained how to set up your SQL Server, how to manage users and groups, how to manage objects and permissions, and how to set up application roles. Today we're...
- Tags: Databases, Enterprise software, Lark Group, Inc., SQL, SQL injection, Microsoft SQL Server, encryption, server, Secure SQL Server, security
- Technical articles 2003-10-17
- XPath provides an easier way to select information in Jet database
- If you're a power user or developer familiar with Microsoft Access or other products that use the Microsoft Jet database engine, you probably think of the SQL language when thinking about queries. In a traditional Access application, SQL is the language that you write queries in, and knowing SQL is...
- Tags: Databases, .NET, Lark Group, Inc., XPath, Dataset, XmlDataDocument, XML, OleDbDataAdapter
- Technical articles 2003-09-18
- SQL Server: Grant access but maintain security
- By Susan Sales Harkins and Mike GunderloyWhenever users try to do something in SQL Server, they're interacting with one or more objects. Their permissions on those objects determine whether they succeed. In this third installment of our series on SQL Server security, you'll learn about objects, ownership, and permissions.Builder.com's series...
- Tags: Databases, Enterprise software, Lark Group, Inc., Microsoft SQL Server, server, MyServer, database, security
- Technical articles 2003-08-26
- Why you should add MDX to your SQL Server toolkit
- By Mike GunderloyEven if you can’t know everything about the hundreds of languages and thousands of tools that might come in handy on future projects, you can know enough to help you choose tools when you need them. Take the Multi-Dimensional Expression MDX language supported by Microsoft SQL Server Analysis...
- Tags: Data mining, Databases, Lark Group, Inc., server, OLAP, cube, MDX, database, OLTP, Microsoft SQL Server
- Technical articles 2003-07-21
- TechRepublic Tutorial: Use Access as an alternative for departmental-level applications
- In most organizations, there’s a constant pressure to do more with less. This is the age of the stripped-down, streamlined, agile company—which in practice usually means trying to do the same amount of work with fewer employees. So it isn't unusual for any given department to have half a dozen...
- Tags: information technology, Lark Group, Inc., Microsoft Access
- Technical articles 2003-12-05
- Get started with the Microsoft application blocks
- By Mike GunderloyMost consultants understand instinctively that time is money: The less time it takes you to deliver a tested, working, complete solution, the higher your hourly rate. One of the keys to better productivity is code reuse. If you have previously tested code that fits the current project’s requirements,...
- Tags: Lark Group, Inc., Microsoft Corp., Microsoft Patterns
- Technical articles 2003-09-08
- Make sure your contract protects your intellectual property
- By Mike GunderloyWhen you agree to write a program for a client, you probably think you’re selling the client some code to run on its computers, and that’s it. Suppose you’re consulting for a chain of dry-cleaning stores, and they want a networked program to make it easier for them...
- Tags: intellectual property, Lark Group, Inc.
- Technical articles 2003-08-27
- Which is better for distributed applications: Web services or remoting?
- By Mike GunderloyOne of the constant factors of the consulting business is the need to learn new tricks. Although basic client needs don’t really change over time, the tools that we have to fill those needs are constantly evolving. Not long ago, creating a distributed application that used the Internet...
- Tags: distributed application, Lark Group, Inc., Web, Web service
- Technical articles 2003-08-18
- Decision Support: Choose the right Microsoft database for your development needs
- By Mike GunderloyMicrosoft has produced a dizzying array of software over the years. Think, for just a moment, about all of the varieties of Windows; if you go back as far as I do, you've probably worked with at least a dozen versions. Similar choices exist in other areas of...
- Tags: database, decision support, Jet, Jet Engine, Lark Group, Inc., Microsoft Access, Microsoft Corp., Microsoft Jet
- Technical articles 2003-07-31
- Configure authentication in your ASP.NET app
- It’s impossible to be a consultant these days without being aware of basic security concepts. Take Web applications, for example. When you’re installing a new ASP.NET application for a client, they’re very likely to want to limit who can use all or part of the application.To handle the client's needs,...
- Tags: authentication, Lark Group, Inc., Microsoft ASP.NET, Microsoft IIS Server
- Technical articles 2003-07-22
- Windows Application Verifier can help you build better code
- By Mike GunderloyYou’ve no doubt seen various versions of the “Certified for Microsoft Windows” logo over the years. Certainly, there’s a marketing component to this, but there are also fairly strict technical requirements. As Microsoft releases new versions of Windows, it also specifies the coding standards that applications must meet...
- Tags: Lark Group, Inc., Microsoft Corp., Microsoft Windows, Windows application, Windows Application Verifier
- Technical articles 2003-07-03
- InfoPath and OneNote: New Office applications on the block
- By Mike Gunderloy and Susan HarkinsGiven the phenomenal success of Microsoft Office over the years, it’s not surprising that Microsoft is always adding new applications to the Office family. With Office 2003, there are two new additions: Microsoft Office InfoPath 2003 and Microsoft Office OneNote 2003. In this article, we’ll...
- Tags: Lark Group, Inc., Microsoft InfoPath, Microsoft Office, Microsoft Office 2003, Microsoft Office OneNote 2003, XML
- Technical articles 2003-07-01
- FrontPage 2003 leaves the Office nest
- By Mike Gunderloy and Susan HarkinsEarlier versions of FrontPage have the reputation of being more of a tagalong Web tool in Office rather than being a serious competitor in the Web design market. FrontPage 2003, however, does seem to finally have the makings of a real Web design tool. Microsoft's...
- Tags: Lark Group, Inc., Microsoft FrontPage, Microsoft FrontPage 2002, Microsoft FrontPage 2003, Microsoft Office, tool
- Technical articles 2003-06-25
- Boost collaboration with Office 2003's SharePoint Services
- By Mike Gunderloy and Susan HarkinsIt’s time to consider one of the biggest selling points of Microsoft’s latest Office version: “Integrated Collaboration,” as Microsoft calls it. This bullet point in the marketing documentation covers a number of Office System features. High on the list are meeting workspaces and document workspaces....
- Tags: collaboration, Lark Group, Inc., Microsoft Corp., Microsoft Office, Microsoft Office 2003, Microsoft SharePoint, Microsoft SharePoint Portal Server, Microsoft Windows, Microsoft Windows Sharepoint Services, workspace
- Technical articles 2003-06-10
- Code generators help you deliver high-quality code quickly
- By Mike GunderloyReduced to its essentials, the job of a contract developer is pretty simple: Produce high-quality code that meets your customers' needs in the shortest possible time. There are many tools that can help you attain this goal. Requirements-management, bug tracking, source code control, and automated testing tools, for...
- Tags: code generation tool, code generator, generation tool, Lark Group, Inc., Microsoft .NET, Microsoft Visual Studio.Net, tool
- Technical articles 2003-06-03
- Improve code confidence with these three .NET code review tools
- By Mike GunderloySometimes software consultants seem to put themselves in the position of the cobbler’s children: The cobbler is too busy to make shoes for his own children, so they’re forced to go barefoot. In the same way, many consultants write fabulous code to solve their clients’ problems, without ever...
- Tags: FxCop, FxCop SDK, Lark Group, Inc., Microsoft .NET, tool
- Technical articles 2003-05-26
- Outlook 2003 offers many new features, but it will cost you
- By Mike Gunderloy and Susan HarkinsThe decision of which e-mail client to use is critical for many businesses, since this is the most commonly used and depended upon application in the office. From a management perspective, Outlook 2003 offers some valuable new features, but you’ll need to consider carefully the...
- Tags: Lark Group, Inc., Microsoft Outlook, Microsoft Outlook 2003
- Technical articles 2003-05-21
- Consolidating events with free Log Parser 2.0 tool
- By Mike GunderloySometimes, the challenge in software is not generating information, but making sense of it. Take this scenario that I ran across on a medium-size network: I collected all of the events from the event logs on a dozen or so Windows computers, and looked for interesting or worrisome...
- Tags: CSV, CSV File, Lark Group, Inc., Log Parser, Log Parser 2.0, Microsoft Windows, text-file, tool
- Technical articles 2003-05-20
- Equip ASP.NET with an error trap to catch unexpected errors
- By Mike GunderloySee how familiar this scenario sounds: You develop a new Web application and test it exhaustively in-house. Then you deploy it to the client’s server, and mystery errors start cropping up. Of course, Murphy’s Law being what it is, the client’s server is usually in a colocation facility...
- Tags: Application Error, Lark Group, Inc., Microsoft ASP.NET
- Technical articles 2003-05-13
- Windows Terminal Services tips for consultants
- By Mike GunderloyThere I was, in eastern Washington State with nothing more than a slow 56-KB Internet connection and a PC. And the client’s computer was in Chicago with a 500-MB SQL Server database that needed some serious reorganization. What next? Stop operations for two days to download the database...
- Tags: computer, Lark Group, Inc., Microsoft Windows, server, Terminal Service, terminal services
- Technical articles 2003-04-30
