Additional Articles

SQL Server Reporting Services Basics: Deploying Reports

by Additional Articles

SimpleTalk

Reporting Services (SSRS)

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.

2015-01-21

9,039 reads

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.

2015-01-19

11,491 reads

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.

2015-01-16

10,316 reads

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.

2015-01-15

9,692 reads

Options to Improve SQL Server Bulk Load Performance

by Additional Articles

MSSQLTips.com

Bulk Load

In this tip Ben Snaidero looks at how to improve SQL Server Bulk Load performance. He focuses his performance tests on options using the BULK INSERT T-SQL command to judge how the various options affect speed.

2015-01-14

8,200 reads

Exploring Query Plans in SQL

by Additional Articles

SimpleTalk

Query plans

SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?

2015-01-13

9,693 reads

SQL Server PCI DSS Security Patching Checklist

by Additional Articles

MSSQLTips.com

Security

PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. How do you create a patching policy for SQL Servers?

2015-01-12

5,700 reads

Backing up your SQL Server to Amazon's Cloud in Three Easy Steps

by Additional Articles

MSSQLTips.com

John Grover explains how to set up Amazon S3 storage, install and configure the Amazon PowerShell module, and set up a Maintenance plan using SQL native backups and PowerShell.

2015-01-09

7,435 reads

Archiving Hierarchical, Deleted Transaction Using XML

by Additional Articles

SimpleTalk

When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.

2015-01-08

12,561 reads

Importance of Statistics and How It Works in SQL Server – Part 1

by Additional Articles

Database Journal

Query Optimizer

SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.

2015-01-07

8,382 reads

All authors

Additional Articles

SQL Server Reporting Services Basics: Deploying Reports

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

Returning Sorted Record Sets Using the ORDER BY Clause

Data Cleaning in SQL 2012 with Data Quality Services

Options to Improve SQL Server Bulk Load Performance

Exploring Query Plans in SQL

SQL Server PCI DSS Security Patching Checklist

Backing up your SQL Server to Amazon's Cloud in Three Easy Steps

Archiving Hierarchical, Deleted Transaction Using XML

Importance of Statistics and How It Works in SQL Server – Part 1

Blogs

The DIY Cost of Masking Test Data For Smaller Organizations

T-SQL Tuesday #196 – Two risky career decisions I made

T-SQL Tuesday #192: What career risks have you taken?

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility