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
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers