Phil Factor shows how a set of Redgate tools can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers. Before tearing down and rebuilding a database to a new version, we take care to save any DDL changes made to the existing copy.
2019-04-10
Kendra Little shows how to get the WideWorldImporters database into version control, using SQL Source Control, and then set up an automated database build process, using Azure DevOps with SQL Change Automation.
2019-04-17 (first published: 2019-04-03)
This article shows how to download sqlserverbuilds.blogspot.com to build your own automated sql patch level check.
2020-12-24 (first published: 2017-07-03)
4,429 reads
Not exactly sure about your question, but : SELECT fulltextcatalogproperty('Catalogue_name', 'PopulateCompletionAge') Returns the difference in seconds between the completion of the last full-text index population and 01/01/1990 00:00:00. This can be manipulted according to the requirement.
2005-05-27
Does any one have a script handy that gives you the rowcount of all user tables on a database. I have one but it gets the result from sysindexes which sometimes is notuptodate. Also I wont prefer anything witha cursor as that might slow down the server. any scripts other than these two.Thanks
2005-05-27
Hello Everyone,Is there a way to get information on resource name that are locked using the stored procedure sp_getAppLock?The server seem to expose the first 4 characters of the resource locked but encode the remaining with headecimal values (if we look using sp_lock or in syslockinfo).We would avoid to try to lock the resource in […]
2005-05-19
65 reads
Public access gives the user what ever permissions are assigned to the public role.You can have one database owner, but many people in the dbo group. dbo's have full access to the database in question.
2005-05-18
2005-01-25
I think this may lead to some users picking up a phone and either complain about missing data or the error displayed or the funny rules that this field can only be so many chars when that field contains so x chars, etc. Secondly, if frontend apply the rules it should be ok, till some […]
2003-06-03
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers