Azure Automation and SQL Index Maintenance
Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...
2017-08-21
956 reads
Blog Posts
Backup Log to Nul– #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21 (first published: 2017-07-31)
1,724 reads
Deploy an SSIS project to the SSIS catalog.
You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project...
2017-08-21
840 reads
Microsoft Azure – How to Check the availability of cloud services using PowerShell
Hello friends, in this blog we will learn how to check whether a cloud service is available to use with...
2017-08-21
475 reads
Monday Coffee: Posting error messages
I posted a couple of messages on twitter over the weekend giving any new bloggers advice that was given to...
2017-08-21
286 reads
New eBook with Pure Storage – Overcoming SQL Server Storage Challenges
My company, Heraflux Technologies, is proud to announce a new ebook as part of our joint partnership with Pure Storage!...
2017-08-21
245 reads
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to...
2017-08-21
117 reads
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to...
2017-08-21
300 reads
Start Your Engine’s with Startup Procedures
After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...
2017-08-21 (first published: 2017-07-31)
1,863 reads
Training and tips to get certified with Microsoft (Part 4 and last)
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL...
2017-08-21
136 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
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,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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