Did you mean
Microsoft SQL Server 2005 (573 results)
Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- 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
- 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
- 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
- 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
- Installing System Center Essentials 2007 for midmarket IT shops
- For the monitoring, system management, and software deployment side of the house in a mid-sized company, Microsoft offers System Center Essentials 2007. Here we walk through a sample installation and talk about the features. by Scott Lowe
- Blog posts 2008-06-17
- 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
- Using SQL Server 2005 Integration Services variables from a Script Task
- If you've written a SQL Server 2005 Integration Services SSIS package that uses variables, you may have occasion to manipulate those variables within a Visual Basic script task. Unlike much of SSIS, there's not really a visual editor to help you with this part. In my opinion, the process is...
- Blog posts 2008-04-28
- Creating variables in SQL Server 2005 Integration Services
- SQL Server 2005 Integration Services SSIS is really well thought out in terms of how it supports user-created variables inside the packages you create. It is, however, not always that intuitive how to create, consume, and manipulate those variables. So I'm going to take my next couple of blog posts...
- Blog posts 2008-04-14
- 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
- Implement custom paging with SQL Server 2005
- In previous columns, I covered the basics of using the .NET 3.5 ListView control and explained how to pair it with the DataPager control. Now I'll show you how to use these controls with a SQL Server 2005 backend to implement custom paging, in which only a subset of the...
- Blog posts 2008-03-25
- 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
- SQL Server 2005 Integration Services makes a good first impression
- You never get a second chance to make a first impression. This aphorism applies to so many things -- dating and job interviews come to mind. It also applies to software, which I was reminded of when I got to use SQL Server 2005 Integration Services SSIS for the first...
- Blog posts 2008-02-20
- 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
- Installing System Center Essentials 2007
- For some time, Microsoft has focused on large enterprises and small business, as evidenced by products such as Small Business Server. The midmarket (500 PCs, a couple dozen servers) has very similar needs as smaller and larger enterprises, but faces unique challenges. Whereas Microsoft provides some specific products for smaller...
- Technical articles 2008-02-06
- 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
- Capture execution plans with SQL Server 2005 Profiler
- Execution plans are one of the best tools for diagnosing problem queries and for performance tuning queries on your SQL Server. Prior to SQL Server 2005, the only options for query executions were text plans or graphical execution plans for queries run by hand. In SQL Server 2005, you can...
- Blog posts 2008-01-14
- << Previous
- page 1 of 29
- Next >>
Content Types
- Blog posts (49 results)
- Book chapters (16 results)
- Case studies (63 results)
- Discussion threads (75 results)
- Download resources (16 results)
- Image galleries (7 results)
- Q&A (2 results)
- Resource centers (1 results)
- Software downloads (12 results)
- Technical articles (47 results)
- Training (13 results)
- Webcasts (181 results)
- White papers (90 results)
Refining Tags
- Microsoft SQL Server (557 results)
- Software (438 results)
- Databases (403 results)
- Enterprise Software (402 results)
- Data Management (396 results)
- Microsoft Corp. (265 results)
- Webcast (168 results)
- Hardware (117 results)
- Storage (87 results)
- Microsoft Developer Network (77 results)
- Microsoft TechNet (76 results)
- Server (53 results)
- Tim Chapman (50 results)
- database (45 results)
- Software/Web Development (41 results)
- Business Intelligence (39 results)
- SQL Server Newsletter (31 results)
- Software Development (31 results)
- Microsoft Windows (28 results)
- Performance (28 results)
- SQL (27 results)
- Marketing (27 results)
- Security (26 results)
- Management (25 results)
- Servers (22 results)
- Analysis (22 results)
- Tools & Techniques (22 results)
- Tim (19 results)
- Pricing (18 results)
- Human Resources (16 results)
- Performance Management (16 results)
- sql server 2005 (15 results)
- Oracle Corp. (15 results)
- Operating Systems (15 results)
- Workforce Management (15 results)
- .Net (14 results)
- Semiconductors (14 results)
- Processors (14 results)
- Data Warehouse (14 results)
- Hewlett-Packard Co. (14 results)
- Components (14 results)
- Microsoft SQL Server 2005 Integration Services (13 results)
- Microsoft Visual Studio (13 results)
- Best Practice (13 results)
- Data Mining (13 results)
- XML (12 results)
- Replication (12 results)
- Mirroring (12 results)
- SAP AG (12 results)
- Programming (12 results)
