Your presentation matters! Do it right!
This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov...
2015-08-31
907 reads
DotNine SQL Server and more
Speaking engagements for August and September
August and September are going to be some busy weeks!
In those two months I will be speaking on three SQLSaturday...
2015-07-03
546 reads
SQL Server 2016 Live Query Statistics
So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the...
2015-05-28
3,133 reads
Announcing Pro SQL Server Wait Statistics
I am very proud to officially announce my first ever SQL Server related book, Pro SQL Server Wait Statistics! As...
2015-04-14
645 reads
Speaking at SQLSaturday 376 Budapest
On April 18 2015 I will be speaking at SQLSaturday #376 in Budapest!
I will be speaking about one of my...
2015-03-23
550 reads
Hangout with Boris Hristov
A couple of days ago I had the great pleasure to join Boris Hristov in one of his awesome SQL...
2015-01-17
599 reads
In-Memory OLTP Part 2 : Memory-Optimized tables
In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements...
2015-01-11
4,199 reads
Looking back on 2014
When a new year comes around it is always a great time to reflect on the previous year.
2014 was a...
2015-01-06
421 reads
Video articles
While thinking of ways to improve the way I can get SQL Server information across to those who follow my...
2014-11-30
971 reads
In-memory OLTP Part 1: Introduction to In-memory OLTP
SQL Server 2014 introduced probably one of the biggest changes to the SQL Server engine since years, “In-memory OLTP” (or...
2014-11-27 (first published: 2014-11-21)
8,415 reads
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
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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