On the Seventh Day…
So far this series has been a bit of fun. We have discussed a fair amount of useful things to date. And here we are only on the seventh...
2012-12-19
8 reads
Blog Posts
On the Seventh Day…
So far this series has been a bit of fun. We have discussed a fair amount of useful things to...
2012-12-19
1,431 reads
SQL Server Training in 2013–SQL Server Virtualisation and Consolidation
As we approach a new year many of you will be looking at your SQL Server Training needs for 2013....
2012-12-19
773 reads
Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,035 reads
Managing Schemas And Source Control For Databases
Visual Studio has a project type called “Database Project” that is used to manage a database schema and allows for...
2012-12-18
4,949 reads
On the Sixth Day…
What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras? No animals have been hurt in the making of this post! This...
2012-12-18
6 reads
SQL Saturday #143 - Washington, DC
Last week, I attended my very first SQL Saturday event in Washington, DC. Although I don't live anywhere near Washington,...
2012-12-18
554 reads
SQL Server 2008 Diagnostic Information Queries (Dec 2012)
Here is the December 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-12-18
1,071 reads
SQL Server 2008 R2 SP2 Cumulative Update 4
Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 4, which is Build 10.50.4270. I count 34...
2012-12-18
2,839 reads
SQL Server 2012 Cumulative Update 5
Microsoft has released SQL Server 2012 Cumulative Update 5, which is Build 11.0.2395. I count 28 fixes in the public...
2012-12-18
1,841 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
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