Do You Have Scary Code?
Many organizations have code no one wants to touch. Steve Jones notes that's a bad place to be.
Introduction to PolyBase in SQL Server 2016 - Part 1
One of the features introduced in SQL Server 2016 is PolyBase. The goal of PolyBase is to make interacting with unstructured, semi-structured and non-relational data stored in Hadoop as easy as writing Transact-SQL statements. Edwin Sarmiento explains.
A big thank you
Grant Fritchey shows his softer side, extending his appreciation to all DBAs who work tirelessly to keep our software running in the face of adversity.
How to Add a Drive as a Clustered Physical Disk Resource in Windows
This article is covers how to add a drive as a Clustered Physical Disk Resource in Windows 2003.
Implementing Continuous Integration for Databases
Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated regularly and tested by an automated build system, and highlights problems early in the development process. But what about database development? Can the same advantages of CI be applied to production databases? Where do you start? How do you tackle it? Sjors Takes relates his experience.
The Lost Laptop Crisis
Losing a laptop isn't something most of us would want to deal with, usually because of the expense. However, there may be other implications that concern you. Share your worries with us today.
How to Create Ten 200GB Test Databases in 60 Seconds
In a recent survey run SQL Server Central, 58% of respondents admitted that their test database is an exact copy of their production database. Many of these respondents concede that they should be removing sensitive data, but aren’t. It seems that the desire to have realistic data will, for many, trump the requirement to keep sensitive data out of development and test environments. In this blog post, Redgate's Jason Crease introduces the new 'SQL Instant Clone' and explains how it could help.
Crossing Azure Borders
Steve Jones is pleased to see some changes at Azure that make the database a stronger platform.
Blogs
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...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers