Show All Related Tags
Did you mean
Microsoft SQL Server (1,951 results), Microsoft SQL Server 2005 (573 results), Microsoft SQL Server 2000 (191 results), Microsoft SQL Server Transact-SQL (55 results), Microsoft SQL Server 7.0 (25 results)more...
Show Fewer Related Tags
Did you mean
Microsoft SQL Server (1,951 results), Microsoft SQL Server 2005 (573 results), Microsoft SQL Server 2000 (191 results), Microsoft SQL Server Transact-SQL (55 results), Microsoft SQL Server 7.0 (25 results), Microsoft SQL Server 6.5 (3 results)fewer...
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
- 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
- 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
- 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
- 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 version of SQL Server are you running?
- I have run into the situation several times where I had to determine which version of SQL Server 2005 is running including service pack. To accomplish this task, connect to the SQL Server Management Studio and run the following TSQL statement: SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)...
- Blog posts 2008-06-22
- 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
- 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
- How do I... Identify and delete duplicates from SQL Server tables?
- Duplicate records in a database are bad. You can't tolerate them. At the very least, they'll produce misleading analysis. At the worst, they'll totally wreck everything. Your application will probably run, but everything it generates will be suspect. You have to find them and delete them or your client might...
- Blog posts 2008-06-03
- How do I configure SQL mail in SQL Server 2000?
- As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail. SQL Mail is a component of SQL Server that...
- Blog posts 2008-05-21
- 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
- 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
- High Availability with SQL Server and Double-Take
- I have been doing a lot of work with SQL Server and Disaster Recovery. Many of my clients are particularly fond of Double-Take. In this three part blog series, I will go over the fundamentals of configuring Double-Take. Note: All screen shots are located a the bottom...
- Blog posts 2008-04-23
- Hiring help at your fingertips
- You've all seen IT hiring kits advertised. The ones that include 80 job descriptions for only about a grand? They may be useful if you're the CIO for a company big enough to house 80 IT positions. But for most of us, our personnel needs are a little more focused....
- Blog posts 2008-04-22
- 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
- << Previous
- page 1 of 98
- Next >>
Content Types
- Blog posts (158 results)
- Book chapters (24 results)
- Case studies (116 results)
- Discussion threads (339 results)
- Download resources (50 results)
- Image galleries (16 results)
- Q&A (73 results)
- Resource centers (1 results)
- Software downloads (278 results)
- Technical articles (296 results)
- Training (19 results)
- Webcasts (377 results)
- White papers (199 results)
Refining Tags
- Software (1,293 results)
- Databases (1,169 results)
- Enterprise Software (1,162 results)
- Data Management (1,151 results)
- Server (752 results)
- Microsoft Corp. (679 results)
- Microsoft SQL Server 2005 (557 results)
- Hardware (386 results)
- Microsoft Windows (335 results)
- Webcast (314 results)
- Database (274 results)
- Storage (255 results)
- SQL (232 results)
- Microsoft SQL Server 2000 (184 results)
- Software/Web Development (145 results)
- Microsoft Developer Network (143 results)
- Microsoft TechNet (139 results)
- Microsoft SQL Server 2008 (131 results)
- Software Development (124 results)
- Tim Chapman (112 results)
- Performance (95 results)
- SQL Server Newsletter (86 results)
- Programming Languages (84 results)
- Security (80 results)
- Servers (80 results)
- Business Intelligence (76 results)
- Programming (73 results)
- Microsoft Access (62 results)
- Marketing (61 results)
- sql server (61 results)
- Microsoft Office (59 results)
- Management (57 results)
- Steven Warren (56 results)
- Human Resources (54 results)
- Office Suites (53 results)
- Operating Systems (52 results)
- Arthur Fuller (51 results)
- TechRepublic Inc. (50 results)
- Workforce Management (49 results)
- Oracle Corp. (47 results)
- Performance Management (44 results)
- Tools & Techniques (42 results)
- .Net (41 results)
- Networking (40 results)
- Microsoft SQL Server Transact-SQL (40 results)
- Hewlett-Packard Co. (39 results)
- Tool (39 results)
- Analysis (39 results)
- Tim (35 results)
- Susan Harkins (35 results)
