Programmers, webmasters, Web services developers and database administrators (DBAs) are not strangers to the "Can we have it tomorrow?" request. That's why software and web developers have embraced a continuous stream of silver bullet technologies that promised to accelerate development. The developer community has experienced "web time", object-oriented programming (OOP), rapid application development (RAD), "extreme programming" and "agile development". Accelerated development schedules put a premium on understanding architecture and knowing how to match the tools to the job. That means understanding today's model of applications as services and what role a database can play. If you understand SQL technology, for example, you can adapt databases to application and service requirements by embedding logic in a database.

Review Armtech for SQL Server

by Dinesh Asanka

SQLServerCentral.com

Product and Book Reviews

How many times have you wished you could throttle the CPU use of SQL Server? Or for a database? Prevent your developers from using too many resources while sharing the server with production or QA. ArmTech for Windows can do this and Dinsesh Asanka brings us a review of how this product worked in his environment.

SQLTeam.com: Five Fabulous Years

by Additional Articles

SQLTeam.com

Rants

Just a little older than SQLServerCentral.com, SQLTeam.com has been another great community for SQL Server developers. A look back from Bill Granazio

Portable DTS Packages

by Jonathan Stokes

SQLServerCentral.com

Integration Services (SSIS)

Moving DTS Packages from one SQL Server 2000 server to another can be a real hassle. There are any number of issues that occur whenever you seek to use a package on different servers. New author Jonathan Stokes brings us a technique he's used many times to build portable DTS packages.

Managing and Deploying SQL Server Integration Services

by Additional Articles

TechNet Blogs

Integration Services (SSIS)

SQL Server Integration Services (SSIS) is an enterprise-level data integration platform. SSIS is an entirely new subsystem in SQL Server 2005. This paper tells you how to take advantage of the SSIS management and deployment features.

Just SQL Part I

by Additional Articles

Database Journal

Miscellaneous

How many of you have asked yourself what SQL is all about anyway? Join me as I begin a venture down the road of understanding SQL and how to take advantage of this language.

What can .NET code do from within SQL Server: Safety levels

by Additional Articles

Other

Development

The following excerpt, courtesy of Addison-Wesley, is from Chapter 6 of the book "A First Look at SQL Server 2005 for Developers" written by Bob Beauchemin, Niels Berglund and Dan Sullivan.

Easy Auditing a Shared Account

by Sergey Pustovit

SQLServerCentral.com

Security

Despite the major advances made with Profiler in SQL Server 2005, auditing changes isn't one of the strengths of the product. New author Sergey Pustovit brings us his technique that allows auditing of actions using shared accounts from an application. A few minor code changes, but overall this is a very interesting idea.

AMO Lets You Dig Deeper into Your Data from Your Own Applications

by Additional Articles

MSDN Communities

Analysis Services (SSAS)

AMO lets developers put their own programs into action. It facilitates client-side custom programming as Decision Support Objects (DSO), the object model in SQL Server 2000 Analysis Services. With AMO, a whole range of data mining questions can be answered at the operational level. This means that sales and marketing departments get answers more quickly and thus can make informed decisions. Specialized resources, like the IT team and analysts, can be brought in when they're needed most.

Automate New Logins Creation

by Leo Peysakhovich

SQLServerCentral.com

Miscellaneous

There are times when a new application or time period requires the creation of a number of logins for your clients. This can be a time consuming process, but Leo Peysakhovich brings us a way to make this go quickly.

SOA, Multi-Tier Architectures and Logic in the Database

Review Armtech for SQL Server

SQLTeam.com: Five Fabulous Years

Portable DTS Packages

Managing and Deploying SQL Server Integration Services

Just SQL Part I

What can .NET code do from within SQL Server: Safety levels

Easy Auditing a Shared Account

AMO Lets You Dig Deeper into Your Data from Your Own Applications

Automate New Logins Creation

Blogs

Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes

Reading SQL Server File Headers with DBCC FILEHEADER

T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP

Forums

The Vector Data Type

What Power BI DirectQuery does to your SQL Server (and how to fix it)

The New OS Wars

Question of the Day

The Vector Data Type