Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- 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
- 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
- Convert a string array to tabular data in SQL Server
- Many DBAs using SQL Server 2000 or SQL Server 2005 are still not very comfortable parsing XML data to get an array of values. Check out this approach for converting arrays of string values to a dataset in SQL Server 2000 and later. by Tim Chapman
- Blog posts 2008-06-06
- Audit data using SQL Server 2005's COLUMNS_UPDATED function
- Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has been modified, it is also useful to track the individual field names that have been modified. This information is great for your auditing department, and it...
- Blog posts 2008-05-13
- Convert numbers to fractions using SQL Server
- I recently worked on an interesting problem that involved converting a decimal number to a fraction value in SQL Server. At first glance, it seemed reasonably simple, but after digging into the actual code a bit, I realized it was rather challenging. Here's how you can write...
- Blog posts 2008-04-30
- Generate synchronization scripts in SQL Server with TableDiff
- DBAs often have to find the differences between lookup tables in different database environments (i.e., development, quality-assurance, staging, and production). The data in these lookup tables are required to be the same across environments to ensure that your testing is accurate. There are a variety of great...
- Blog posts 2008-04-22
- Simplify SQL Server 2005 queries with a Dates table
- I find that it can be advantageous to use a Dates table, especially when doing a lot of date calculations. Learn what a Dates table is and how to create one, and then try it out for yourself. What is a Dates table? A Dates table stores a...
- Blog posts 2008-04-14
- Document Sarbanes-Oxley compliance with SQL Server 2005
- As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Oxley auditors to discuss the security and integrity of corporate data. In a nutshell, we're expected to answer any number of questions, via appropriate documentation, about who has access to our data, how access...
- Blog posts 2008-04-07
- Diagnose SQL Server performance issues using sp_lock
- A common misconception among IT pros is that "locks are bad," and you must do everything possible to ensure database locking doesn't prevent processes from running. In order to ensure a consistent database environment, the database engine must use a mechanism to acquire exclusive use of a resource when that...
- Blog posts 2008-03-31
- Build directory structures using SQL Server 2005
- If you ever work with directory structures on the filing system, you know how challenging it can be to traverse through folders to find specific files. If you store this type of information structure in the database, you are even more aware of what it takes to retrieve the data....
- Blog posts 2008-03-17
- Generate dynamic SQL statements in SQL Server
- When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. This article explores how you can use this functionality to generate SQL statements on the fly. Dynamic SQL statements A...
- Blog posts 2008-03-10
- Sorting character strings using SQL Server
- You are probably familiar with the built-in sorting abilities of SQL Server for columnar data, but what if you need to sort character strings stored in SQL Server fields? Even though this may not be a common need for most users, this issue may come up from time to time. I'll demonstrate...
- Blog posts 2008-03-03
- You promised it could do what?
- Owing to the overwhelming response to my first three-part story in which Harold did NOT get fired but I did, I would like to try your patience with another fine tale, told in three installments. This one takes place in the far distant past, early in my career when I believed...
- Blog posts 2008-02-27
- Monitor database file sizes with SQL Server Jobs
- The ability to automate administrative tasks is vital in almost any SQL Server database environment. In the SQL Server world, this scheduling of work is known as a "Job." It allows you to perform such tasks as database maintenance, invoke executables, ActiveX script, Integration Services packages, and business transactions. ...
- Blog posts 2008-02-25
- Capturing SQL Server 2005 database file size information
- It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information....
- Blog posts 2008-02-15
- Easily correct data casing with SQL Server
- Whether data is entered into your SQL Server system from a Web site, internal applications, or through files, the presentation of the data is always a concern. In this tutorial, I will create a function that will be useful in terms of updating data or just displaying data to end...
- Blog posts 2008-02-11
- Finding dependencies in SQL Server 2005
- Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used. ...
- Blog posts 2008-02-04
- Find blocking processes using recursion in SQL Server 2005
- Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set or subset of records. This causes the second process to wait until the first process is done so it can acquire the records; this...
- Blog posts 2008-01-28
- Monitor query performance with the SQL Server 2005 procedure cache
- In SQL Server 2005, you only need to recompile the statements inside stored procedures. This is much different than SQL Server 2000, where the entire procedure or batch may be recompiled. The benefit to the statement level recompile in SQL Server 2005 is that typically just a few statements inside...
- Blog posts 2008-01-17
- << Previous
- page 1 of 4
- Next >>
Content Types
Refining Tags
- Software (41 results)
- Microsoft SQL Server (35 results)
- Tim Chapman (34 results)
- Databases (33 results)
- Enterprise Software (33 results)
- Data Management (33 results)
- Microsoft SQL Server 2005 (19 results)
- Hardware (15 results)
- storage (14 results)
- server (12 results)
- Microsoft Windows (11 results)
- Mobile (9 results)
- Statement (8 results)
- windows (7 results)
- Software/Web Development (7 results)
- Operating Systems (7 results)
- TABComputers2002 (7 results)
- sql (6 results)
- Microsoft Corp. (6 results)
- Database (6 results)
- Software Development (6 results)
- Data (6 results)
- Procedure (5 results)
- sales (4 results)
- Function (4 results)
- Index (4 results)
- Programming Languages (4 results)
- SalesHistory (4 results)
- Table (4 results)
- E-mail (3 results)
- tim.williams@... (3 results)
- performance (3 results)
- Sales Strategy (3 results)
- SSIS (3 results)
- Information (3 results)
- Timothy J Collins (3 results)
- information technology (3 results)
- Human Resources (3 results)
- Trigger (3 results)
- Execution Plan (3 results)
- Microsoft Outlook (3 results)
- Internet (3 results)
- Tom Mochal (3 results)
