(Hilary Cotter) As a SQL Server DBA, you must not only be concerned with the SQL Servers you manage, but also with the non-production machines running Microsoft SQL Server 2000 Desktop and Personal editions. (R)
Tag: sql server
Introducing Distributed Messaging using Service Broker in SQL Server 2005
(Akram Hussein) Microsoft SQL Server 2005 introduces a new distributed messaging framework that allows for asynchronous programming support. The Service Broker is a new platform for building asynchronous – distributed database applications. In this article I will give a brief overview of the def
Dynamic ‘Sales by Week’ Procedure in SQL Server
(Mike Ellison) Presented in this article is an approach for creating a categorized “Sales by Week” report in SQL Server, in which weeks are represented as columns, categories as rows, with values totaled by those categories. Before describing the stored procedure, where we’ll parameterize this d
Exporting and importing service listings into a database
(Rushi Desai) You implemented a Service Broker service and now want others to be able to talk to it. But they will have to first create your message types and contracts to be able to begin a dialog and send messages to your target service. If their service does not reside in the same SQL Server inst
Microsoft English Query
(Mike Chapple) Most database developers are plagued with user requests on an almost daily basis: “How do I get X information out of the database?” or “Your program doesn’t let me ask the database question Y, is that possible?” Wouldn’t it be nice if all of your users simply understood SQL and could
Top 10 security enhancements in SQL Server 2005
(Adam Machanic) As database systems continue to be more widely used to back stores of networked applications, it is increasingly necessary to focus on security. Although much of the buzz surrounding SQL Server 2005 has been from a development perspective, Microsoft’s new database management syst
iSeries and SQL Server Integration
In this Webcast, learn about the different ways that you can integrate data on the iSeries with SQL Server. In the first part of this presentation, Michael Otey, senior technical editor for iSeries NEWS and president of TECA, Inc., will show how to setup an ODBC and OLE DB connection between the two
When Applications And Databases Collide
(Clint Boulton) Once thought of as two separate worlds, applications and database software are converging due to the increasingly distributed nature of modern computing.
Alter every table in a SQL database
(Arthur Fuller) All developers make mistakes from time to time; sometimes this happens because we fail to build in obvious but unstated requirements.
Introduction to MSSQL Server Analysis Services: Introducing Data Source Views
(William Pearson) The release of MSSQL Server 2005 ushers in a plethora of enhancements over the feature set available within MSSQL Server 2000. Proclaimed as the “BI Release” for good reason, the integrated Microsoft business intelligence solution has witnessed advances in power, scope and user fri
