Managing Log Files Sizes the Easy Way
Learn an easy, rough, and ready way to manage log files in this piece.
Introduction to C# Scripting for SQL Server DBAs
Microsoft has introduced an interactive C# scripting technology inside the Visual Studio 2015 environment. In this post, Jeffrey Yao looks at how we can use this to perform SQL Server tasks.
Solving an SSIS Error – Cannot convert between Unicode and non-Unicode
When loading data with SSIS, sometimes there are various errors that may crop up. This article provides a solution when you get have a problem between Unicode and non-Unicode fields.
This is how to fail
Today we have a guest editorial from Tim Mitchell that talks about security and communications with your customers. Ultimately it pays to be open and honest.
Deploying schema changes to multiple databases using the SQL Compare command line
Feodor Georgiev explains how SQL Compare Pro makes it possible to automate the process of synchronizing a source and target database. By calling SQL Compare from a simple batch script, he shows how to make it work for a whole list of targets, one after another.
Listing Duplicate Values by Group
Without question, one of the most common tasks performed by Database Administrators (DBAs) is identifying and weeding out duplicate values in tables. Despite the inordinate number of queries written by other DBAs to locate duplicate values in their database tables, the real challenge is in locating a useable SQL statement to go by. Rob Gravelle presents a few solutions that will save you some time down the road.
The Hibernate ORM and SQL Server
Using an ORM with SQL Server introduces unique challenges. I have listed a few of my experiences, hoping it can help someone.
Retrieving SQL Server Query Execution Plans
Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about using DMVs, Extended Events or SET statements to get at the execution plans? To get the best use of execution plans you need to be able to get right information from the right plan at the right time. Robert Sheldon explains how.
DBAs Need to Learn to Develop
SQL Server is growing as a platform and Steve Jones says that DBAs need to learn development skills.
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers