Browse the archive
Shortcuts & tips from an Impatient DBA This series of short posts will demonstrate some lesser-known features, keyboard shortcuts, and other tips that make my day as a DBA more productive. None of these are groundbreaking super-secret features–they are the …
Continue readingQuestion Consider the following: CREATE PROCEDURE dbo.usp_trantest AS SELECT @@TRANCOUNT as trancount; GO When I call usp_trantest manually from within SSMS, the trancount is 0. If I run an SSRS report that contains a dataset that queries the same stored …
Continue readingShortcuts & tips from an Impatient DBA #4 This series of short posts will demonstrate some lesser-known features, keyboard shortcuts, and other tips that make my day as a DBA more productive. None of these are groundbreaking super-secret features–they are the …
Continue reading
