7/02
Part 1 of this series discussed the difference between a Trace and Profiler. This installment examines additional preconfigured templates, how to synchronizing Profiler and Perfmon and how to run Profiler as a scheduled task. 7/01
Part two of this series illustrates how to access the Windows service on a remote machine using Windows PowerShell and WMI-Object to see if all of the windows services related to SQL Server are up and running.
6/27
BI Architect Bill Pearson continues
his hands-on demonstration of an approach to the parameterization of the
highly useful LastPeriods() function.
6/26
To manage and use the new date data types introduced in SQL Server 2008, Microsoft has provided a number of new system functions. In this article, Greg Larsen explores the new system functions and some of the old date functions that were available in older releases of SQL Server.
6/24
Enhanced variable declaration, one of the many enhancements that Microsoft added to SQL Server 2008 allows you to declare and initialize a value at the same time. This article shows you how to do it.
6/23
In the previous installment of our series, we presented a variety of reasons that might influence your decision to upgrade a full-fledged member of the SQL Server 2005 family. This article discusses the actual implementation of this process, pointing out additional factors that might affect its complexity.
6/20
Join
BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY
property. In hands-on exercises, we gain exposure to the use of the property
in generating simple lists, as well as datasets to support report parameter
picklists.
6/18
This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
6/13
Parameterization of MDX functions is
one of those things that cannot be delivered solely via graphical MDX Editor –
but then, you really didn’t think that you could avoid actually touching MDX at
all, did you? BI Architect Bill Pearson demonstrates a way to parameterize the
highly useful LastPeriods() function.
6/09
Part 24 of SQL Server 2005 Express Edition reviews the most common reasons that influence a decision to upgrade to a Workgroup, Standard, or Enterprise member of SQL Server 2005 family.
6/06
SQL Server 2008 February CTP introduces a new feature, SQL Server Audit. This feature facilitates auditing of Database Engine events by providing simple T-SQL statements to enable, store, and view audits on server and database objects. Part 1 of this series focuses on the server level events.
6/04
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
6/02
Profiler is a tool that monitors the events and activity running on a SQL Server. Using profiler, this monitoring can be viewed, saved, and replayed. This article focuses on using Profiler with SQL Server 2005, but the tool is also included with SQL Server 2000 and SQL Server 2008.
5/29
Business Intelligence Architect Bill Pearson continues his
introduction to dimension attributes, focusing upon the Parent-Child group of
attribute properties. This article continues our subseries surrounding
components of the Analysis Services dimensional model.
5/27
Greg Larsen examines the new SQL Server 2008 date data types, comparing them to the existing
data types that are available within older versions of SQL Server.
