Using AI for Security
Steve thinks AI might have a place in security, something Microsoft is investigating now.
Moving Dynamic Data Masked Data to New Locations - Step 5 of the Stairway to Dynamic Data Masking
In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.
The Art of the Code Review
Code reviews are a good way to not only improve your quality, but also raise the skill level of your staff.
“As DBAs, should we be worried about our jobs because of AI?” and other burning questions
We recently launched the State of the Database Landscape 2024 survey results, with information from almost 4,000 database professionals from around the globe. A clear picture emerged from the results, suggesting that 2024 is the year that skill diversification among database professionals is imperative.
SQL Server Clustered Index Seek Operation Generates Poor Query Performance
In this article, we look at why a SQL Server clustered index seek operation might not always be the most optimized approach for executing a query.
Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster - Part 3
I used the guide in a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 to install a SQL Server 2008 on a Windows Server 2008 failover cluster (WSFC). Now, I would like to upgrade and migrate my SQL Server 2008 failover clusters to SQL Server 2022 running on Windows Server 2022. What is the process for installation and configuration?
Software Updates, Outages, Processes, and Protocols
This past Thursday, February 22, AT&T had a major outage on their U.S. network. For upwards of 10 hours, hundreds of thousands of customers could not make phone calls, send or receive texts, or use mobile data for apps or browsing websites. Aside from not being able to communicate as normal, it also appeared to […]
Free SQL Server
There are a number of ways to run SQL Server for free (or low cost) for development. Read a bit about how to do this.
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