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 HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers