Keynotes
This Friday we look forward to the various tech events of 2008 and which speakers you think are worth seeing. This editorial was originally published on Jan 11, 2008. It is being re-run as Steve is traveling.
Database Deployment: The Bits - Copying Data Out
Occasionally, when deploying a database, you need to copy data out to file from all the tables in a database. Phil Factor shows how to do it, and illustrates its use by copying an entire database from one server to another.
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes. This editorial was originally published on Apr 3, 2008. It is being re-run as Steve is out of town.
Red Gate Wins 8 Awards and You Can Get a Prize
Red Gate won 8 awards in the recent SQL Server Pro annual product reviews. As a celebration, we're giving away a few prizes.
SQL Server 2012 Integration Services - Implementing Package Security using Access Control
SQL Server 2012 Integration Services offers a wide range of powerful features that allow you to streamline and automate tasks involving data extraction, transformation, and loading. However, incorporating these features into your existing business intelligence framework frequently necessitates additional security measures ensuring that data which is being processed remains protected from unauthorized access.
Stairway to SQL Dialects Level 3: MySQL
As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment.
Type A, B, or C
Do personality types matter and did you know there are more than just A or B types? This editorial was originally published on Feb 26, 2008. It is being re-run as Steve is traveling.
Steps to add Log Shipping monitor into an existing SQL Server
I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation.
The Default DBA
Defaults are important since so many people just accept them. Steve Jones thinks that SQL Server needs to add more defaults to the setup program that might help DBAs better manage their systems.
Using SSIS to export data from a 64 bit server to Excel 2007
Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel
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
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
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers