External Article

How to create and refresh development and test databases automatically, using SQL Clone and SQL Toolbelt

  • Article

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.


Technical Article

RE: special situation... full text search for anything?

  • Reply

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.


Technical Article

RE: pass-through query problems

  • Reply

The function is now working, though I  did have to specify the master database - it did not find xp_sendmail via "db_applications".  I am having trouble capturing the return code values (boolean) and/or result sets (from Books Online: Result Sets: xp_sendmail returns this message: "Mail sent").   I would like to return both.  I used your […]


Technical Article

Validating Stored Procedure results

  • Topic

Does anyone know a way to validate the results of a stored procedure?  I have a routine that checks for updates to procedures and validates the format of the data returned but the only way I can do that is to dump the results to a temp table.  I can't insert into a temp table […]


1 reads


Encrypting Your SQL Data Should be Your Default Option


Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Power BI Embedded: Using Row-Level Security for Multilingual Reports


Making multilingual reports in Power BI requires a lot of different elements. Translations can...

Daily Coping 29 Nov 2022


Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

Read the latest Blogs


Sql table join help

By SQL Bee

I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101,...

Why do Sql Server In operator behaves differently and return nothing?

By mehmood

I am using sql server 2017. I am trying to use the in operator,...

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers