Find Efficiencies or Add Horsepower?
In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...
2010-02-10
794 reads
Articles
Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS
Learn how the Analysis Services Processing Task can be used to process analysis services objects such as cubes, dimensions and mining models.
2010-02-10
1,883 reads
Professional Microsoft SQL Server 2008 Integration Services - Sample Chapter
Get a feel for this book from
2010-02-09
2,115 reads
Introducing SQL Server 2008 and 2008 R2 Integration Services
The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.
2010-02-09
3,387 reads
Sending SSIS Errors to the Windows Event Log
In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS...
2010-02-09
3,564 reads
A guide to recover a database out from Suspect mode
This is a guide to bring back a database back from Suspect status. This covers common causes and the steps to resolve the situation.
2010-02-08
19,001 reads
PASS Virtualization Presents: SQL Meets Virtual CPUs, Memory, and Storage
Upcoming webcasts in February on the 9th and 10th of the month.
2010-02-08 (first published: 2010-02-04)
1,950 reads
Performing SSAS Database Backup
In this post, we will look the steps to backup a SQL Server Analysis Server Database.
After logging to the Analysis Services,
in...
2010-02-08
1,703 reads
SQL Server Third Party Application Requirements Document / Checklist
In August 2009 I wrote a tip concerning checklists for third-party applications running against Microsoft SQL Server. I thought it was a good time to revisit the topic and provide an added bonus: a requirements document that you can download and customize for your own uses.
2010-02-08
2,823 reads
TSQL Challenge 23 - Calculate the uptime and downtime of a system by reading the data from an audit log
It is again time to play with some date/time values. This challenge involves reading the audit log entries generated by a monitoring application and create a report that shows the up-time and down-time of a system that the application is monitoring.
2010-02-08
2,225 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
Make your moments memorable with Fildena 200mg
Make your moments memorable with Fildena 200mg, a high-strength option designed to support men...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers