Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log...
2012-04-02
857 reads
Blog Posts
Parallel Data Warehouse – Slowly Changing Dimension
Most of my day-to-day work is currently centered around Microsoft’s Massively Parallel Processing Appliance call PDW (Parallel Data Warehouse). Many...
2012-04-02
1,851 reads
Rebuilding System Databases
Today’s post is something I thought I would share as there is an awful lot of incorrect commands I have...
2012-04-02
814 reads
SQL Saturday #131 – Phoenix Schedule Posted
I got an email today from the SQL Saturday #131 crew with the schedule posted, showing me listed for two...
2012-04-02
940 reads
SQL Server 2012: SSAS enhancements
My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in...
2012-04-02
2,696 reads
SQL Server Log Backups
While presenting a session on Common Backup Problems both at SQL Saturday in Orange County and at SQL Connections in...
2012-04-02
1,059 reads
SSAS: Processing Cube Dimensions and Measures in SSMS
My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the...
2012-04-02
4,344 reads
Stress Thoughts-Part 5
Stress affects everyone, but it’s easy to forget that. Once you get sensitized to it, it’s amazing to pick up...
2012-04-02
731 reads
Unsupported Features in Excel Services SharePoint 2010
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a...
2012-04-02
1,488 reads
Which product was purchased the most? T-SQL
Suppose you had a list of product sales and were curious about which one was sold the most? It’s a...
2012-04-02
9,397 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers