Creating One-Time Jobs - SQL School Video
SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.
2008-12-23
3,898 reads
SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.
2008-12-23
3,898 reads
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,414 reads
In this SQL School video, Andy Warren examines one of the new features in SQL Server 2005: mirrored backups.
2008-12-02
4,276 reads
Profiler is a fantastic tool for SQL Server DBAs to enable them to examine how batches and code is submitted to the server. Expert SQL Server trainer, Andy Warren, brings us a new article that exaamines how you can log that data in another SQL Server table for later analysis.
2008-09-25
4,151 reads
Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking about and I have a short story to support it.
2008-09-22
2,211 reads
One of the less used commands in T-SQL, the UNION command can come in very handy in a number of situations. SQL Server expert trainer, Andy Warren, discusses how you can use UNION.
2008-09-10
10,696 reads
Expert trainer and longtime DBA, Andy Warren, tackles the rather simple, but often understood, process of renaming a database. Learn about some of the issues you might encounter when trying to complete this task.
2008-09-02
9,725 reads
SQL Server makes it very easy for anyone to create a database. However it's worth spending a few minutes thinking about how you plan a database and SQL Server trainer Andy Warren brings us some thoughts on the subject.
2008-08-27
8,298 reads
SQL Server trainer and expert DBA, Andy Warren, thinks that everyone should have a philosophy about security. He starts this installment in looking about how to assign administrative privileges.
2008-08-12
4,576 reads
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.
2008-08-04
6,394 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers