Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Reusability 2.0: The Key to Publishing Learning
- What would a person do if he or she had to develop and deliver personalized training to 900,000 employees, located in 34,000 different locations globally with a complex set of variables that changes training on a location-by-location basis? The key is reusability 2.0. While technology-delivered training has become mainstream in...
- Tags: Alliance, Chapman Co., Training, Workforce Management, Strategy, Human Resources, Management
- White papers 2007-04-01
- CIO finds balance between home and work
- How can a busy executive balance family and career? We'll share one CIO's secrets for "having it all" as well as some tried-and-true tips sent in by other TechRepublic members.Rick Chapman doesn't work weekends. The most "homework" he'll do is a brief overview of notes on a Sunday night to...
- Tags: Beth Blakely, Chapman Co., home life
- Technical articles 2002-01-30
- Geek Trivia: Advanced Python scripting
- Besides the six actual members of Monty Python -- Graham Chapman, John Cleese, Terry Gilliam, Eric Idle, Terry Jones, and Michael Palin -- who are the only two people ever credited as writers during the entire run of Monty Python's Flying Circus? by Jay Garmon
- Tags: Geek Trivia, Python, British Broadcasting Corp., Chapman Co., TV, Monty Python, Pythonite, Gilliam, Innes, Jay Garmon
- Blog posts 2008-09-30
Additional Resources
- IT Training Success Stories: M-Chapman
- Mark Chapman looked at different training companies while he was making a decision on who to train with. Mark came across lots of training companies who were just interested in selling a course. However, he found that Just IT came across very realistic about the job market and were more...
- Tags: Information Technology, Training, Workforce Management, Professional Development, Quality, Human Resources, Career, Business Operations
- Case studies
- 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
- Reviewing SQL Server Permissions
- SQL Server consultant Tim Chapman looks at the importance of database permissions and how you can use internal SQL Server system views to easily which users have access on your system. by Tim Chapman
- Tags: Permission, Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Tim Chapman, Login, Windows Login, JOIN, Storage, Hardware
- Blog posts 2008-11-03
- Using IntelliSense in SQL Server 2008
- Microsoft has finally released a SQL Server product that includes IntelliSense for writing TSQL statements. In this article, Tim Chapman shows the ins and outs of using IntelliSense in SQL Server 2008. by Tim Chapman
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, IntelliSense, SalesHistory, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-09-15
- 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
- Help! My SQL Server Log File is too big!!!
- Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems. by Tim Chapman
- Tags: Transaction Log, Transaction, Microsoft SQL Server, Backup, Server, File, Simple, Checkpoint, Transaction Log Backup, Database Mirroring Database Mirroring, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-09-22
- Introduction to Policy-Based Management in SQL Server 2008
- New to SQL Server 2008 is Policy-Based Management. This new technology allows for defining polices to ensure your database guidelines are met. In this article, SQL Server consultant Tim Chapman gives an overview of this new technology. by Tim Chapman
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Databases, Enterprise Software, Software, Data Management, Tim Chapman, Database Administrator, Policy, Storage, Hardware
- Blog posts 2008-10-15
- 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
- Defining SQL Server 2008 Policies
- You've already had a brief introduction to Policy Based Management, a new SQL Server 2008 feature that allows the Database Administrator the ability to define and enforce policies through the database engine.Tim Chapman now shows how you can use SQL Server Management Studio to define your own policies. by Tim...
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Policy, Databases, Enterprise Software, Software, Data Management, Tim Chapman, Stored Procedure, Condition, Facet
- Blog posts 2008-10-20
- 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
- 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
- Backup compression in SQL Server 2008
- New to SQL Server 2008 is the native ability to compress database backups. This great new feature results in a smaller backup file, which saves disk space and can lessen the time latency. Here's how it works. by Tim Chapman
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, SalesHistory, Backups, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-08-25
- More New SQL Server 2008 Features
- Microsoft updates SQL Server on a pretty regular basis. It's newest version, SQL Server 2008, includes some new features not found in older versions. Here's a list of some of them. by Tim Chapman
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Data, Server, Feature, Data Type, TSQL Intelli-sense SQL Server Management Studio 2008, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-09-02
- Script Table definitions using TSQL
- Generating scripts in SQL Server using TSQL has never been easy. In today's SQL Server tip, I will show you how you can use TSQL in SQL Server 2005 code to script a table's definition. by Tim Chapman
- Tags: Microsoft SQL Server, Server, TSQL, @TableName, CAST, CASE, @Definition, OBJECT_NAME, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-08-18
- 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
- Bulk importing data into SQL Server
- BULK INSERT is a TSQL command used in SQL Server to load an external file into a database table for using a specified format. Learn how to import data using the command, and find out how changing some of its options can make it more efficient to insert data. by...
- Tags: Microsoft SQL Server, Data, Server, Databases, Enterprise Software, Software, Data Management, Tim Chapman, Trigger, File, BULK INSERT BULK INSERT, SalesHistory, FIELDTERMINATOR, Tim, Storage, Hardware
- Blog posts 2008-03-24
- New Date Datatypes in SQL Server 2008
- SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Heres can you can use these new data types to your advantage in SQL Server 2008. by Tim Chapman
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Data, Data Type, GETDATE, DATETIME2, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-09-08
- << Previous
- page 1 of 1
- Next >>
