Technical Article

Backup Basics Part 3: General Tips for a Backup Strategy

Knowing how to configure backup applications and select backup media is half the battle of designing a successful backup strategy. The other half is choosing how and when to back up the specific pieces of data that are stored on your servers, share points, and workstations. In this final article of his series on backup basics for new technicians and administrators, Ryan Faas offers some suggestions to help you make these important decisions.

External Article

Monitoring SQL Servers Availability

How many SQL Server instances are you running? Do you ever have customers calling you stating that their application is not working, then when you research the problem you find that the instance that supports their application is unavailable? Have you ever had someone mistakenly shutdown the SQL Agent service and forget to restart it, causing a number of scheduled jobs to not be run? One of the tasks of a DBA is to monitor the availability of all SQL Server instances and services.

SQLServerCentral Article

A Report to Display and Edit User 'Rights'

Reporting Services is quickly becoming one of the most popular parts of SQL Server and new author Jonathan Spink brings us an interesting use of this subsystem. He explains how Reporting Services can do more than just display data; it can also provide an easy interactive way to make changes without the overhead of a complete .NET application.

Technical Article

Tuning .NET - Part One

As server-side .NET development becomes more prevalent, Application Performance Management tools are becoming available to fine-tune .NET applications. And, as in the past, it seems that the ability to build new and more sophisticated applications always stays ahead of the ability to manage them.

SQLServerCentral Article

Adding In HTML Links

While the strength of SQL Server is not in string manipulation, it can be very handy when backing a web site to be able to automatically include links for some of your content. New author Grey Wilson brings us an easy technique to easily deliver results to developers with URLs embedded inside.

Technical Article

Using correlated sub-queries in SQL Server

A sub-query is a SQL Server statement embedded inside of another SQL Server statement. The database engine treats a sub-query as a virtual table for the execution of the query. A sub-query can be used as a table in a join statement, as a single value in a select statement, in the where clause of a SQL Server query, in the having clause of a SQL Server query, or incorporated in data manipulation statements.

Blogs

Rolling Back a Broken Release

By

We had an interesting discussion about deployments in databases and how you go forward...

A bespoke reporting solution doesn’t have to cost the earth

By

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Presenting with Visual Studio Code

By

A while back I wrote a quick post on setting up key mappings in...

Read the latest Blogs

Forums

Lots of FKs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lots of FKs

Real-time On-prem SQL Server Data in Excel – Over the Internet

By Cláudio Tereso

Comments posted to this topic are about the item Real-time On-prem SQL Server Data...

Can You Let Go of Determinism

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can You Let Go of...

Visit the forum

Question of the Day

Lots of FKs

In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?

See possible answers