Additional Articles

All authors

External Article

Manage SQL Server Reporting Services in Management Studio

Most maintenance for SSRS is performed either in Report Manager online or within the Report Services Configuration Manager from the desktop. The SSRS Management Studio connection is certainly no replacement for either of these tools, however, several benefits can be obtained using SSMS. First, you are able to connect to the SSRS even if you are having browser issues; second, it is often quicker to just switch from using Management Studio for the Database Engine.

2013-09-24

4,676 reads

External Article

The PoSh DBA – Getting to know PowerShell

Although it was primarily designed for System Administrators, PowerShell is now extending its use to Database, SharePoint, Exchange and all Microsoft products. In this article Laerte Junior offers an introduction to PowerShell and describes how DBAs can use PowerShell to automate repetitive tasks. He also explains when to use PowerShell instead of, or in addition to, T-SQL and SSIS.

2013-09-23

3,686 reads

External Article

Databases and Dominoes

A Dominoes game of Texas 42 inspires Joe Celko to explore unusual uses for check constraints and views. Sometimes, the best way of discovering useful SQL techniques is to tackle the more unusual problems.

2013-09-19

2,976 reads

External Article

SQLServerCentral Webinar #17: Monitoring your SQL Server Instances

Join SQL Server MVP Brad McGehee to learn why it is so important to monitor your SQL Server instances and what you should consider when starting out. This webinar will also show you how you can use Red Gate's SQL Monitor for SQL Server monitoring and will include an overview of the new features released in v3.0, including the ability to create your own custom metric definition and to support different access permissions.

2013-09-18 (first published: )

3,412 reads

External Article

Backup to the Cloud: The Silver Lining

Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery.

2013-09-16

2,399 reads

All authors

Blogs

Monday Monitor Tips: Intelligent Alert Thresholds

By

At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...

A New Word: los vidados

By

los vidados – n. the half-remembered acquaintances you knew years ago, who you might...

In-Person CISA Training – April 13-16, 2026

By

I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...

Read the latest Blogs

Forums

String_agg not working as needed

By DaveBriCam

I'm trying to get this string_agg to put all the 'comments' into one result...

Vectors in SQL Server 2025

By Daniel Calbimonte

Comments posted to this topic are about the item Vectors in SQL Server 2025

Odd Sequences

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Odd Sequences

Visit the forum

Question of the Day

Odd Sequences

What values are returned from this code? 

CREATE SEQUENCE NumericSequence
    AS NUMERIC(5,1)
    START WITH 1.0
    INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO

See possible answers