Bypassing a Trigger - SQL School Video
Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.
2008-12-16
4,403 reads
Articles
Guest Editorial: That ain't a Database, it's a Spreadsheet
Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.
2008-12-16
87 reads
Guest Editorial: That ain't a Database, it's a Spreadsheet
Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.
2008-12-16
73 reads
Guest Editorial: That ain't a Database, it's a Spreadsheet
Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.
2008-12-16
75 reads
How do I assign permissions to users to see SQL Agent Jobs?
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server
2008-12-16
3,346 reads
Recover Data Using Database Snapshots
This article shows how database snapshots can be used to recover data in a source database
2008-12-16
2,470 reads
Versions of Disaster
Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.
2008-12-16
874 reads
Versions of Disaster
Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.
2008-12-16
842 reads
Scope: The drastic caveat with Logon Triggers.
In this article, Johan Bijnens shows how logon triggers can bite you in the back.
2008-12-15
9,168 reads
2008-12-15
584 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers