Disk Partition Alignment–MCM Prep
Does disk partition alignment matter to SQL Server? Without a doubt. When new disk partitions are created, there could be...
2011-01-21
1,461 reads
Blog Posts
Free SQL Server Training for the week of January 24, 2011
We're finally getting a handle on things with the new baby. 🙂 As a result, I've started this weekly accumulation of...
2011-01-21
838 reads
PowerShell Week at SQL University – Post 6
Yesterday we went over some loop constructs to get information out of SQL Server. While getting the information out is great, as Data Professionals our very next concern is...
2011-01-21
19 reads
PowerShell Week at SQL University – Post 6
Yesterday we went over some loop constructs to get information out of SQL Server. While getting the information out is...
2011-01-21
1,474 reads
Read from the Right End of the Index: BACKWARD Scans
Optimizing queries is the most fun when you don’t need to add indexes. There’s nothing quite so nice as finding...
2011-01-21
1,892 reads
Speaking at SQLSaturday #66 in Colorado Springs on February 12
I recently found out that I will be one of the speakers at SQLSaturday #66 on February 12 in Colorado...
2011-01-21
705 reads
SQL Saturday Tampa Follow Up
This past weekend, I had a talk on SQL Server Reporting Services down in Tampa Florida for SQL Saturday 62....
2011-01-21
752 reads
31 Days of SSIS – DTSConfig Configuration (19/31)
31 Days of SSIS
The last two posts in the 31 Days of SSIS talked about the use of environmental variables...
2011-01-20
1,256 reads
31 Days of SSIS – No More Procedures (20/31)
Time to shift off of configurations and environments and talk more about SSIS packages and best practices. If you haven’t...
2011-01-20
1,832 reads
January 2011 Meeting Recap
One week ago today the Las Vegas User group held our monthly meeting. One week ago today, at that meeting, we had our best attendance in over a year....
2011-01-20
9 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