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
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Alamat BCA KCU Mojokerto ??/Wa (0817)839777
Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers