Moving TempDB
One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.
Pimp My Data Center
Steve Jones talks about the changing capabilities and flexibilities of data centers as technologies change.
Alerts for when Login Failures Strike
When repeated SQL Server login failures occur, a DBA should investigate. It could just be someone repeatedly typing in the wrong password. Worst case is a virus attack flooding your network with connection requests. Receiving an e-mail while login failures are occurring allows DBAs to investigate and fix the issue as soon as possible. So how is DBA notified of login failures without flooding their inbox?
SqlCredit – Part 17: Exploring SQL 2005’s OUTPUT Clause
SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT.
Un-retiring
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
Un-retiring
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
Un-retiring
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
Pimp My Data Center
Steve Jones talks about the changing capabilities and flexibilities of data centers as technologies change.
Pimp My Data Center
Steve Jones talks about the changing capabilities and flexibilities of data centers as technologies change.
Pimp My Data Center
Steve Jones talks about the changing capabilities and flexibilities of data centers as technologies change.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers