Reporting Services Basics: Overview and Installation

SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like Power BI, SSRS is still a popular tool for paginated reports. In this article, Kathi Kellenberger explains the architecture of SSRS and walks you through installing an SSRS development environment on your workstation or laptop.

SQL in the City Summits – UK, US & Down Under

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today. Register now

Stairway to SQL Server Security

Stairway to SQL Server Security Level 5: Schemas and Security

In this stairway level you’ll learn how you can give principals access to groups of objects by assigning permissions on schemas instead of individual tables, code modules, and other objects. You’ll also learn about the benefits of user-schema separation and how it can increase object security, and how using default schemas for users and groups can simplify object access management and security.

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

Blogs

Attending a climate protest for the first time

By Matthew McGiffen

This is a blog devoted to databases, but for once I’m going to go...

What’s the Mashup Engine?

By Steve Jones

I was testing something the other day and ran sp_who2 on a test instance....

Join me for a PASS Summit Pre-Con

By Monica Rathbun

I am very excited to announce I will be delivering a pre-conference session on...

Read the latest Blogs

Forums

CU14 for SQL 2017 – R and Python CAB file issues

By quackhandle1975

Hi, have a standalone Dev SQL 2017 instance that is was at CU13 build...

Convert DATETIME to a date in ISO format

By Edvard Korsbæk

I have a field, DATO, which is formatted as DATETIME. There is no time...

Time difference

By hrvvoda

How to calculate time difference between up and down rows?   So, I need...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers