Join MSAS Architect Bill Pearson in the first of a pair of articles focusing upon the powerful TopCount() function, where we experience “hands-on” some of the possible ways it can offer multi-perspective decision support.
So far, in our series of articles, we have presented the most significant new and enhanced features available in Microsoft’s SQL Server 2005 Beta 2, but neglected to provide you with information regarding its installation.
Creating databases in SQL Server 2000 can be an easy process if you understand the terms. Steven Warren examines the key terms related to database design.
MAK demonstrates how to use the user defined function, udf_CheckFileStatus, to avoid waiting for a file to be copied and how to run a process more efficiently.
In the past, you had to tweak your SQL Server settings manually to find the ideal configuration. Now, Microsoft has released a tool called the Microsoft SQL Server Best Practices Analyzer. In this article, Steve Warren shows you how it works.
This article provides a simple walk-through on creating and displaying a report in an ASP.NET Web page using Reporting Services.
Though case insensitiveness makes the life of the database developers and database administrator’s easy, there are situations where case sensitivity should be enforced just as password checking is enforced
MSAS Architect Bill Pearson explores the set and string versions of the powerful GENERATE() function, and leads practice in its operation.
Learn how to take advantage of VB-scripting, the OSQL command line utility and an MS-Dos batch file to consolidate and check the status of all of the rebooted SQL Servers on the network.
This month Greg Larsen explains what a correlated subquery is, and shows a number of different examples on how to use a correlated subquery in a T-SQL statement.
