Everything I've read about the built-in configuration options is that you can retrieve values from a SQL Server table, an XML file, etc. but I really prefer to just use the command line options. I'm currently specifying 10 or more command line options on average. Do you have any ideas on a better way to do this?
2009-08-18
3,212 reads
Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.
2009-08-18
4,515 reads
How to move databases from one server to another with limited downtime
2009-08-17
8,138 reads
In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.
2009-08-17
3,444 reads
SharePoint administrators can minimize data loss by selecting the appropriate SQL Server recovery model. But which model is right for your enterprise?
2009-08-17
4,000 reads
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-17
2,916 reads
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
2009-08-17
647 reads
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
2009-08-17
653 reads
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
2009-08-17
657 reads
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-17
976 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Butuh panduan penggunaan QLola BRI? Melalui whatsapp 08136035412 Butuh panduan penggunaan QLola BRI? Hubungi...
Layanan support QLola BRI tersedia melalui WhatsApp 08136035412 untuk membantu berbagai kebutuhan Anda, mulai...
Layanan bantuan QLola BRI melalui whatsapp 628136035412 Layanan bantuan QLola BRI kini lebih mudah...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers