Francis


build_restore_script

This script originally created by Greg Larsen has been modified by me. This procedure is used to create the restore commands needed to restore a database using the lates full and any transaction or differential backups. The parameter @dbname was added to just create the restore statements for a particular database. Leaving off this parameter […]

4.8 (5)

2005-06-07 (first published: )

1,217 reads

dropUnusedLogins

For those site using SQL Server ids as opposed to Integrated security there may be instances where occasionally SQL Server logins might get 'orphaned'. That is the login is not a member of any server group that has general database access nor does that login have specific access to any particular database.  Compile this proc […]

2004-03-01

273 reads

Blogs

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Removing a Deleted Column from a Data Masker Masking Set

By

Data Masker for SQL Server is a great tool ensuring the data you use...

Containers: A Short Rant

By

I find myself doing more and more work with containers. Yet, I also find...

Read the latest Blogs

Forums

Invalid cursor state

By thbaig

HI, Version : Microsoft SQL Server 2014 (SP3-CU4-GDR) (KB4583462) - 12.0.6433.1 (X64) I have...

Page number in forum topic

By ShaunHardy

Hi all. I’m not even sure if this is the right section to post...

Metadata-Data-Ratio in a table

By sean redmond

Hi all, My understanding about the structure of data within SQL Server is that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers