TSQL Challenge 44 – Identify products that belong to each unique color
The first part of your job is to identify the unique color combinations of products and the second part is to identify the products that have the given color combination.
When a Dogma has had its' day
Phil points out that the SQL Server community has a role to play in making sure that the wisdom of SQL Server Pundits is regularly tested and challenged.
Custom sp_start_job to delay next task until SQL Agent Job has completed
The system stored procedure sp_start_job is a very useful T-SQL command that starts a SQL Agent job. The problem with this is that it starts the job and it doesn't wait until the job is finished and sometimes I want to start a job and wait until the job is finished and move on to another job or task that depends on the result of the previous job.
SQL Saturday #61 - DC
A day of free training near Washington DC in December. Come and learn how more about SQL Server.
An Example of Test-Driven Development, Part 5
The fifth installment of this fantastic series by MVP Andy Leonard looks at database versioning. Be sure to read this one to continue learning more about TDD.
Do You Talk Salary in the Interview?
This is a reprinted editorial from August 2, 2005. It is being republished as Steve is on vacation. Steve discusses the challenge of discussing salary in an interview.
Implicit Permissions Due to SQL Server Database Roles
I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?
Extending SQL's Inherent Hierarchical Processing Operation
This article covers multipath operations that require a different hierarchical logic than SQL naturally produced hierarchical processing. These include nonlinear data ordering, the renormalization of data to remove replicated data, and the processing of network structures.
Implementing Execution Log Reports on 32-bit SQL Server 2008 R2
This article covers how to implement the SQL Server 2008 Execution Log DB and package on SQL Server 2008 R2
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
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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