Learn to Use Books Online
One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...
2012-08-06
2,207 reads
Blog Posts
Recovering from out-of-disk space conditions for tempdb
Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...
2012-08-06
3,251 reads
Rollback TRUNCATE TABLE statement
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,439 reads
SQL Audit 201 – Creating an Audit Solution
Welcome back, folks!
Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s...
2012-08-06 (first published: 2012-07-31)
6,733 reads
SQL Server - Oracle Architectural comparison
This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...
2012-08-06
4,622 reads
SQL Server : Lost all Administrator Account in SQL Server and Forgot sa Account Password
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
7,991 reads
SQL Server: How Recursive Common Table Expression (CTE) Works ?
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,289 reads
The first record on data page.
TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...
2012-08-06
1,206 reads
Time Flies When You're Having Fun (Déjà Vu Edition)
Writing - be it a technical language like T-SQL, C#, PowerShell, etc. or blogging - is like exercise. When you do it...
2012-08-06
1,530 reads
What's new in Reporting Services 2012 Free Webinar
We are starting our free monthly webinars with 'What's new in Reporting Services 2012' on Wednesday August 8, 2012 at 12...
2012-08-06
1,325 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