Introduction to Indexes: Part 3 – The nonclustered index
Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.
Security is Improving
Today Steve Jones notes that security is improving at many web sites. It's not great, but it's improving. That's a good sign, or is it?
What to look for in an employer
A Job interview for a database Developer is, or should be, a two-way process. They are sussing you out, and you are sussing them out.
Developing Low-Maintenance Databases
Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.
SQL Saturday #150 - Baton Rouge
Baton Rouge, LA. LSU. Free Training. Come visit, learn a few things, and enjoy meeting other SQL Server pros.
Map IP Address to a Geographical Location
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
Stack Ranking
This Friday Steve Jones talks performance reviews. The system in place at Microsoft is a tough one, which allows some to thrive, and some not to. Is it one you'd like to have in place?
Creating a Custom Report Template in SSRS
Arshad Ali shows you how to create standard/custom report templates in SQL Server Reporting Services (SSRS), to ensure consistency throughout the organization in both the look and feel of reports.
Single User Performance of SQLite v. SQL Server
A look at the performance of SQL Server compared to SQLite for single user applications.
Using Technology In New Ways
An interesting reuse of technology in a completely new way caught Steve Jones' eye. See if you agree that this is rather amazing.
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...
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,...
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