Script a cube using Windows PowerShell and AMO
This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.
2009-05-12
1,985 reads
Additional Articles
SQL Server Audit: Magic without a Wizard
In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or most highly-regulated industries. SQL Server 2008 Enterprise Edition includes all of the features, whereas SQL Server 2008 Standard Edition only provides a subset. What is most attractive about it, is that it is easy to administer, as Thomas LaRock explains.
2009-05-12
2,638 reads
Database Mail and SQL Agent Mail setup by using a script
In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.
2009-05-11
4,009 reads
Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)
For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance.
2009-05-11
2,257 reads
Attribute Discretization: Using the Automatic Method
Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
2009-05-08
2,182 reads
SQL Server Optimization
This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.
2009-05-08
5,250 reads
Patterns For High Availability, Scalability, And Computing Power With Windows Azure
Now, Internet-hosted distributed applications with connectivity to internal applications—often referred as Software plus Services (S+S)—are gaining popularity. Organizations are leveraging datacenters hosted by third parties to alleviate concerns about hardware, software, reliability, and scalability. These are just some of the new architecture trends that help you build interoperable applications that scale, reduce capital expenditure, and improve reliability. Cloud computing offers many of these benefits.
2009-05-07
2,230 reads
Scaling up vs. scaling out with SQL Server 2008
To scale your SQL Server properly means to make it bigger and better. But what is the best method for 2008?
2009-05-07
2,973 reads
Auditing Failed Logins in SQL Server
An auditor has taken a look at our SQL Servers and has told us that we need to audit login failures to the SQL Servers themselves. How do we do this?
2009-05-06
3,583 reads
Median Workbench
SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why.
2009-05-06
2,024 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers