Introducing Windows Server 2012 – Get the FREE eBook!
Introducing Windows Server 2012 - can be downloaded for free here.
This book provides the early, high-level information you need to begin preparing...
2012-07-14
2,265 reads
Blog Posts
Lost in Translation – Deprecated System Tables – syscolumns
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-13 (first published: 2012-07-04)
2,684 reads
Not enough available space on destination..495GB available!
I bought a USB hard disk recently that I wanted to use to backup some VMware Workstation and some Hyper-V...
2012-07-13
1,004 reads
SQL Cruise! SQL Saturdays! Summit! SQL-SQL-SQL!
We’re drawing to the end of our third season of DBAs@Midnight (our weekly webshow by DBAs, for DBAs), and to the...
2012-07-13
756 reads
SQL Error 18456
18456 is probably one of the most common errors people come across and in this article we try to cover...
2012-07-13
792 reads
SQL Server: Instant Blocking Alert Using WMI in Your Mailbox
As a DBA, it is important for all of us to get real time alert on various issues in our...
2012-07-13
6,748 reads
Two Socket Database Servers vs. Four Socket Database Servers
Fujitsu has submitted a new TPC-E benchmark for a two socket, Sandy Bridge-EP system that had a tpsE score of...
2012-07-13
1,938 reads
Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value
Not another comma separated string blog post I hear you say! I know that this topic has probably been done...
2012-07-13
6,805 reads
View SQL Server information using Transact-SQL script
Recently one of our clients requested information about their SQL Server infrastructure which we manage. In order to complete this...
2012-07-13 (first published: 2012-07-04)
9,062 reads
Denali – Memory: “any size” page allocations
I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided...
2012-07-12
907 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