At Best Software, we take pride in offering the best possible software solutions for small to medium-sized businesses. Our charter for MAS 90 and MAS 200 is to provide customers with broad and deep application functionality built on rock-solid, proven platforms. Most important of all, we want to sim

(Arthur Fuller) This article begins with a test. Look at the SQL below and determine, without using your computer, what the result set will look like.

(Lauren Walker) With the release of SQL Server 2005, Microsoft hopes to move in on the large-enterprise database management systems market formerly dominated by Oracle, IBM’s DB2 and Sybase by offering features and scalability more like theirs. (R)

(William Pearson) As most organizations implementing or evaluating MSSQL Server Reporting Services 2000 discovered, the application did not afford us an “out-of-the-box” way to support multiple value selections within a Report Parameter by a consumer at runtime. This caused frustration among many of

(Andrew Novick) I’m always looking for better tools for debugging, tracing and logging. You might recall the series of tracing tools that I’ve implementing in T-SQL and that were featured in issues #1 through #7 of this newsletter. The simple stored procedure in this issue use capabilities of the

(Srinivas Sampath) Native Web Services (also called HTTP Endpoints) is a new feature in SQL Server 2005. In fact, the concept of Endpoints itself is new, since you can also have other types of endpoints. Apart from the “native” aspect of web services, the concept of web services in SQL Server is how

(Carol Sliwa) Paul Flessner, senior vice president of server applications at Microsoft Corp., said the “game changers” that will set SQL Server 2005 apart from the competition’s databases are the integration of the company’s Visual Studio development environment and business intelligence capabilitie

After you configure drillthrough permissions on a virtual cube in Microsoft SQL Server 2000 Analysis Services, the drillthrough operation fails. Additionally, you may receive an error message that is similar to the following: Unable to drill through. Access denied to the cube BaseCube.

(Thomas Moore and Ed Tittel) This chapter deals with the physical components of a SQL Server database system. Beginning with the server hardware, organizing the data storage and creating the physical files is where a lot of future performance will be determined. There are many options to conside

(Marcin Policht) In one of our earlier articles dedicated to the WMI Event Watcher Task of the SQL Server 2005 Integration Services, we briefly mentioned SSIS logging functionality (which needs to be enabled in order to configure the ActionatEvent configuration WMI option). This allows us to verify