HASHBYTES: Is CHECKSUM really required?
When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.
Steve Jones and Grant Fritchey at SQL Intersection
SQL Server Central’s Steve Jones and Red Gate’s Grant Fritchey will be among a stellar line-up of speakers at SQL Intersection conference in Las Vegas on the 8th to the 11th of April.
What Do You Want to Know About I/O?
Steve Jones is looking forward to learning more about I/O. There is a panel of experts, taking questions at SQL Intersection in a few weeks.
SQL Server 2012 Integration Services - PowerShell-Based Project Deployment
You have the option of using PowerShell when automating management of SQL Server 2012 Integration Services. While this functionality is not as straightforward as those accustomed to traditional PowerShell cmdlets might expect, the steps required to accomplish the most common SSIS administrative tasks follow a relatively consistent pattern.
A Good Security Response
Evernote recently had a security incident and forced all users to reset their passwords. Many people thought this was a good response to a security incident. Would your company act in a similar manner?
Data Mining SQLIO Results
Learn how to use Analysis Services Data Mining to identify the influence of RAID level and IO Pattern on Latency.
Red Gate brings SQL in the City back to London for the third year running
Data professionals are invited to attend Red Gate’s free SQL in the City event for a day of SQL Server training in London.
SQL Server's Auto Update Statistics Async Option
I have been trying to tune my SQL Server and I noticed a few database settings for statistics. I also read the previous tip on automatic statistics updates. Could you please describe the Auto Create Statistics Async option? How is this configured and when should I use it and when should I avoid using it?
Car Data
Today's automobiles might collect more data than you think. All that might data gives us opportunities to find new and interesting ways to use this data with software.
Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks
You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.
Blogs
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...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
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
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
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