Naming Conventions for SQL Server Objects
Phil Factor feels that as a community we can do more to help people who are wrestling with SQL coding standards.
How to Linux for SQL Server DBAs — Part 2
SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security works in Linux. In this article, Kellyn Pot'Vin-Gorman demonstrates how to manage user accounts in Linux and why working while logged in as root is a bad idea.
The Real World: Implementing Data Compression in SQL Server 2008 R2
Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008
Your SQL Server is Bored: What Low Wait Times Mean
In which you ask your assistant to fetch your coffee, and time them.
Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server
Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server Level Audit Group.
Using your critical eye to see something positive
As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.
Creating Machine Learning Applications using Azure Cognitive Services
Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.
Installing the Database Server - Level 2 of the Stairway to SQL Server on Linux
In this next level, we learn how to install SQL Server on Linux and verify that everything is working.
Using Tools That Fit
The right tool is important for a good job. Andy Warren asks if you're thought about the tools you use on a daily basis.
Using Azure Quickstart Templates
In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.
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