SQL Server Alerts provide a great way for the server to notify a DBA that some event has occurred, usually something bad that they need to fix. However alerts can also be used to drive business logic processes and enable some types of actions to be safely performed without requiring extraordinary rights by a user. Author Leo Peysakhovich brings us some ideas on how we can use alerts to implement business logic processing.
2004-08-10
22,147 reads
Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.
2004-07-27
30,526 reads
SQL Server DTS is an amazing ETL tool. Parallel processing is not only possible, but author Leo Peysakhovich shows us how he does it in this article about his index rebuild process. By bundling DTS into SQL Server for free, Microsoft gave us a platform for not only ETL, but also many basic tasks that all DBAs are stuck working on. Read on to see if parallel processing of index rebuilds is something you can use.
2004-07-13
9,838 reads
Do you know which of your databases are being backed up? Everyone answers "Yes", but I'm sure that there are times that someone creates a new database and you don't know about it. I know in my job, with hundreds of servers, it happens. Here's a technique for keeping track of those databases from Leo Peysakhovich.
2004-05-24
13,480 reads
How can you tell if your code if performing well? Do you know what you want to look for when starting to analyze code? Here's an article from Leo Peysakhovich that looks at some of the things that you can use at a high level to improve the performance of your code.
2004-05-11
12,456 reads
Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps.
2004-04-12
4,440 reads
New Author! We've run a couple articles on similar topics, this one takes a slightly different approach. It's a short article and has two scripts included.
2004-03-01
9,099 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
Comments posted to this topic are about the item When Page Prefetching Takes a...
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers