Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates how to configure reports for native-mode deployment using Report Manager, and then deploy them from within SSDT-BI. She also explains how to use the Report Builder to provide "self-service" reporting to end users, allowing them to build custom reports based on report parts and shared datasets.

A Standard Database Security Script Generator

by Jefferson Elias

SQLServerCentral.com

Generator

A script generator for standard security compliance.

Taking Care of Things Today

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about procrastination today and how you might not want to do that with your SQL Servers.

Untrusted Foreign Keys with NOT FOR REPLICATION Option on the Key

by Brian Hibbert

SQLServerCentral.com

Untrusted Foreign Key

My Foreign Keys are STILL untrusted after the double CHECK. Here's how you can fix this issue.

Questions About Pivoting Data in SQL Server You Were Too Shy to Ask

by Additional Articles

SimpleTalk

pivot

Of all the basic SQL operations, the pivot seems to cause the most problems. It turns out that there are several questions that come to mind while learning about pivoting, but which are seldom asked on forums.

Returning Sorted Record Sets Using the ORDER BY Clause

by Additional Articles

Database Journal

order by

Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.

A Little Empathy

by Steve Jones

SQLServerCentral.com

Editorial

Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.

Prevent sp_ Procedures with SQLCop

by Steve Jones

SQLServerCentral.com

tSQLt

Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.

Data Cleaning in SQL 2012 with Data Quality Services

by Additional Articles

SimpleTalk

data cleansing

Feodor Georgiev provides a thorough walkthrough on setting up SQL Server's Data Quality Services (DQS) and creating the rules it uses to function as a first step towards data cleansing.

Hadoop and SQL Server

by Steve Jones

SQLServerCentral.com

Editorial

Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.

SQL Server Reporting Services Basics: Deploying Reports

A Standard Database Security Script Generator

Taking Care of Things Today

Untrusted Foreign Keys with NOT FOR REPLICATION Option on the Key

Questions About Pivoting Data in SQL Server You Were Too Shy to Ask

Returning Sorted Record Sets Using the ORDER BY Clause

A Little Empathy

Prevent sp_ Procedures with SQLCop

Data Cleaning in SQL 2012 with Data Quality Services

Hadoop and SQL Server

Blogs

KDA: Echoes of Deception - Case 6

Capturing My Own Metrics: #SQLNewBlogger

Red Flags in Your Query (T-SQL Tuesday #200)

Forums

BIT_COUNT II

I Can't Make You Learn

Why Your SQL Permissions Disappeared

Question of the Day

BIT_COUNT II