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
Not So Unbreakable
Oracle touted its database software as unbreakable, but many security researchers think the company is not spending enough effort on security. Steve Jones has a few comments.
sp_prepexec and nHibernate
SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.
A DBA is a Data Professional
DBA (Database Administrator) is a Data Professional tasked with managing an organization’s data using some sort of database software, such as Microsoft SQL Server. They are concerned with gathering, storing and presenting data to data consumers, which includes virtually anyone in the modern world.
Extended Events - inaccurate_cardinality_estimate
Extended events have been a bit of a personal “Elephant in the room” for me. I know they are there and I should really get on a start using them but never *quite* have a compelling enough reason.
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers