Additional Articles


Technical Article

Script to automatically restore needed log-backups

Given a backupfile with a lot of sequential log-backups, this script automatically restores just those backups out of the file, which are necessary to bring the database up to a given timelag relating to the original database.Params are path to backupfile, name of the db to restore to, timelag in minutes.

You rated this post out of 5. Change rating

2004-09-08 (first published: )

1,635 reads

Technical Article

Schemas in ADO.NET 2.0

When you decide on a connection string and add a Data Connection, each Data Connection also displays a tree of information about the database objects (like tables, views, and stored procedures) visible directly through the connection. But where does this information come from? Read this article from MSDN on the new features of ADO.NET.

2004-09-06

853 reads

Technical Article

Script to transfer logins to second server

Modification of DR_Script_Logins.sql by Bruce Canady.Puts out a script to add new logins or change the password of existing logins.I insert the output into a table in my production-db.   insert database.dbo.login_table exec master.dbo.dr_script_loginsThat way its backed up with the data, and the logins can be restored anywhere by the script i added at the […]

5 (1)

You rated this post out of 5. Change rating

2004-09-03 (first published: )

2,521 reads

Technical Article

Search for text in procedures and show context

This script will search for text within stored procedures and udf's. As a bonus, it will also diplay a user-configurable number of lines from each stored proc to show the search text "in context" so you can tell if it is something you need to deal with without having to open every proc manually.

You rated this post out of 5. Change rating

2004-08-30 (first published: )

245 reads

Blogs

Making a PostgreSQL Backup in a Container

By

I needed to back up a PostgreSQL database as a part of the repro...

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

Read the latest Blogs

Forums

RLS Causing RBAR

By danielfountain

Hi all, First I want to ask just a generic question.  Does RLS in...

SQL2019 STANDARD max memory is 128Gb yet my Bufferpool exceeds this value

By PearlJammer1

Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...

Having issues installing SSIS extension for VS 2022 Community

By daniel.manke

I have installed the SSIS extension for VS 2022 community. When I go into...

Visit the forum

Question of the Day

A Simple Choice

I have this data in a table?

CatIDCatName
3Monitors
What is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c
 

See possible answers