7/25
SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT. 7/24
With a single MERGE statement, you can easily implement insert, update, and delete logic to handle criteria for maintaining a table. Read on to learn how to use the MERGE statement.
7/21
MSAS
Architect Bill Pearson introduces the intrinsic MEMBER_NAME 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.
7/16
Part 3 of this series illustrates how to acquire
operating system and hardware related information from a host machine.
7/14
Learn how to monitor database-level actions and write audit
results to files.
7/11
This article is a brief overview of Service Broker's core features, which are available (in a somewhat limited capacity) in SQL Server 2005 Express Edition. The next installment will describe a sample application illustrating its operations and discuss its management, security, and routing characteristics.
7/07
Join Business Intelligence Architect Bill Pearson as he continues
his subseries surrounding components of the Analysis Services dimensional
model. In this article we conclude our introduction to dimension attributes, focusing
upon the Source group of attribute properties.
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.
