Natively Compiled Procedures and Execution Plans
The combination of in-memory tables and natively compiled procedures in SQL Server 2014 makes for some seriously screaming fast performance....
2014-06-05
1,362 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Add an Instance to SQL Server Azure Virtual Machine
How do you add an instance to your local SQL Server installation? You run the executable that you probably downloaded...
2014-05-19 (first published: 2014-05-13)
1,489 reads
Carolina Cruise
I’m going to speak at three user groups in three days in North and South Carolina. Evidently this is known...
2014-05-09
492 reads
Speaker of the Month, May 2014
Whoa! Another month gone by already? I guess I better pick a speaker of the month then. I went to...
2014-05-02
1,196 reads
Microsoft Azure Automation
Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it...
2014-04-24 (first published: 2014-04-16)
1,781 reads
Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,379 reads
I Am Better Than You
That is a patently false statement and total BS. It sure does crawl up your spine though doesn’t it? Why...
2014-04-22
933 reads
SQL Server First Aid
If you take basic first aid, say a CPR course, you’ll learn a handy mnemonic for the primary assessment you...
2014-04-15
1,118 reads
Sharing a Good Idea
I posted earlier about my experiments with Microsoft Curah!. (yes, technically the period should follow the exclamation since the exclamation...
2014-04-14
582 reads
Speaker of the Month, April 2014
I’m really enjoying picking a speaker of the month. It forces me to sit through a lot more sessions at...
2014-04-11 (first published: 2014-04-04)
1,204 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