Getting results using less T-SQL
There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways to write simpler T-SQL code.
2022-05-23
Additional Articles
Change Management and Leadership Alignment
Successfully implanting change in an organization requires buy-in from leadership. Rohan Kapoor explains what’s needed to get leadership alignment.
2022-05-20
Flyway and Simple Source Control
How to integrate Flyway database development with Source control, so that you can track what changes were made and who made them as well as which objects changed between versions, and how.
2022-05-20
[Re-post] Tackling the Challenges of Hybrid Estates
It's an oldie but a goodie: Redgate Advocate Grant Fritchey takes us through how best to manage hybrid estates. Read on to find his expert recommendations.
2022-05-18
SQL Server vulnerabilities and assessment
SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to do a vulnerability assessment of SQL Server.
2022-05-18
The nuances of MySQL indexes
Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.
2022-05-16
Webinar: Introducing Database DevOps
Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover what we mean by Database DevOps, why you need to include the database in your DevOps initiative and the benefits its offer you, your teams, and your organization.
2022-05-16
Summit Learning Pathways Announced
Whatever your learning objectives or career goals are, Summit has the guided learning pathways you need to achieve them. Summit attendees can choose from 9 learning pathways, featuring over 40 industry-leading speakers, which have been designed to walk you through a specific set of learning outcomes to ensure that you leave Summit with the skills you need to make an immediate impact in your organization. Presenters include Ginger Grant, John Morehouse, Erin Stellato, Dustin Vannoy, and many more!
2022-05-13
The ins and outs of joining tables in SQL Server
Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server.
2022-05-13
A MySQL story: Can system engineers solve database issues using system tools?
A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan
2022-05-11
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