Does the Role of the DBA Need to Evolve?
With the amount of data being stored expanding exponentially, does the role of the DBA need to change from caretaker to interpreter?
Encryption Works
Encryption is supposed to protect data, and it appears to be working as police and authorities are often stymied by encrypted disks. Steve Jones recommends you encrypt your disks on all your machines.
TSQL Challenge 71 - Play mangled words game in TSQL
Your task is to process the input table that contains several mangled words and try to 'un-mangle' them and validate them against a 'dictionary' table.
Backup Verification: Tips for Database Backup Testing
A Backup system is merely part of a recovery system. If your backups can't be used to recover the database, then they're useless. Do you regularly make sure that you can restore a database from your backups?
Vote for the DBA in Space Finalists
There are 15 finalists in the DBA in Space competition. Cast your vote today, and every day, for the next 5 days to decide who is going into space.
A brief explanation and solution for the Double Hop problem
What on earth does “Login failed for user ‘(null)’, Reason: Not associated with a trusted SQL Server conn” mean?
The Employment Contract
This Friday Steve Jones wants to know if you'd like to have an employment contract of some sort. Do you want your duties, or maybe exlcusions, explicitly spelled out in an agreement?
How to Build a Resume (that doesn’t suck)
Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain key functions are very hard to perform. In this case, not having a resume makes the job-getting difficult.
Restoring a SQL Server Database – A Practical Example
Performing a Database Restore is a part of a DBA's daily life. A DBA may need to perform a Restore due to various reasons such as recovery, refreshing a database for testing purpose etc. Many times it can be difficult to perform a Restore due to corrupted media, low disk space on the server and so on. This articlel outlines one approach which can be used to Restore the backup of the Production Database a test environment.
Setup Alerts for PBM
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Pantai Indah Kapuk TLP/WA 08216977749
Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara, Kecamatan Penjaringan, Jkt...
BCA KCP Jembatan Lima TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Jl. KH.Moh.Mansyur No.15 F, Duri Pulo, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota...
BCA KCU DAAN MOGOT Hub.0851•8812•0691
BCA KCU DAAN MOGOT Hub.0851•8812•0691 Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers