SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
Covering Index using Included Columns
This article from Josef Richberg details the benefits of included columns for use in creating a covering index to improve performance.
Configure Windows Firewall to Work with SQL Server
Windows Firewall is an OS level software firewall. It can be a crucial part of OS level security if you are not using other firewall hardware or software. Since I do not have another firewall I have a need to enable Windows Firewall for my SQL Server database server. In this article I go through the process of configuring Windows Firewall for different scenarios along with the associated considerations.
Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
Newsletter Changes for Yahoo Mail
We have recently made a few changes in our newsletter sending process and been working with Yahoo to ensure delivery. If you are just receiving this newsletter to a Yahoo account, welcome.
The Best Laptop
Steve Jones recently went on a search for a new laptop, looking for the "best" one for him. But what it the best? And is it worth pursuing?
Time Bomb Coding
Do your system contain a time bomb in the code? David Poole looks at some potential situations where you might be experiencing performance issues and delves into why.
Find Efficiencies or Add Horsepower?
In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...
Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS
Learn how the Analysis Services Processing Task can be used to process analysis services objects such as cubes, dimensions and mining models.
An Administrative Security Hole?
Is it a problem for SQL Server to have a backdoor that lets a Windows Administrator connect as a sysadmin? Steve Jones thinks so and gives a reason why this might be a problem.
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers