Review of SQL Sentry (Lite)
Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps.
Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps.
This article shows some options to retrieve all the metadata you'll need to write scripts that write scripts. No, that's not a goof, this article is about code generation.
Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!
If you are (or want to be) a power user, this book should be on your shelf. How many books have you read that have you using a debugger to step into the sql server process? James gives it a thumbs up!
In this article by Steve Jones, he shows you how to manipulate strings.
One of the strengths of Visual Studio .NET is its features for rapid application development, or prototyping. If, for example, you want to develop a Windows form that lets you maintain the data in one table of a database, you can usually do that in 20 minutes or less. This article will show you how.
Do you have the need for more speed on your servers? How do you go about squeezing more speed out of the database when faced with an upgrade? Steve Jones walks through some of his thought process when looking at ugprade for one of his servers.
As Jeff says, "There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment". Well, now we have one that shows you how to do it!
Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers