Everyone wants to get ahead of the curve with SQL Server 2005, but many people don't have the time or desire to dig through a Google search. Steve Jones has gotten quite a few requests for resources, so here is a compiled list of some places that might help you get started.
2006-09-08 (first published: 2005-04-21)
45,324 reads
Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.
2006-09-08
4,926 reads
This article is a short summary of Windows utilities both GUI and command line intended for new SQL Server DBAs or those interested in learning some useful techniques.
2006-09-07
18,493 reads
A CTE is a "temporary result set" that exists only within the scope of a single SQL statement. It allows access to functionality within that single SQL statement that was previously only available through use of functions, temp tables, cursors, and so on.
2006-09-07
2,652 reads
Have you ever needed to build a job that could run within a certain period of time? Those long maintenance operations, like index rebuilds, need to fit within certain windows of time. New author Joe Doherty brings us a great technique for ensuring those jobs do not run over into your business day and impact normal operations.
2006-09-06
8,381 reads
Are you interested in a raise? Asif Sayed got one from a well written report. This time he brings us a beginners' looks at Reporting Services 2005 using a smart client for testing.
2006-09-05
11,594 reads
Microsoft IT developed strategies to reduce the duplication of sensitive data and improve the security of personally identifiable information in the Microsoft IT LOB application space. These strategies are based on the new security features and functionalities that Microsoft® SQL Server™ 2005 includes.
2006-09-05
2,039 reads
2006-09-04
5,971 reads
In this article, we examine some of the best new features and characteristics available in the 2005 version.
2006-09-04
1,994 reads
Danny Lesandrini shares a block of code that will allow users to modify (and save) datasheet layout when they are using a compiled MDE version of your Access applications.
2006-09-01
2,257 reads
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers