SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 61 to 80 of 16732    Older >>
 

Cache Snapshots And History Snapshots in SSRS 2016

The various Snapshot options in Reporting Services 2016 explained.  Read more...
By Suresh Kumar 2018/04/03 | Source: SQLServerCentral.com | Category: ssrs 2016
Rating: |  Discuss |   Briefcase | 403 reads

An Easier Way of Transposing Query Result in SQL Server

T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT statement, but it doesn’t quite accomplish the task. In this article, Darko Martinovic shares another method using a SQLCLR stored prodedure.  Read more...
By Additional Articles 2018/04/03 | Source: SimpleTalk | Category: sqlclr
Rating: (not yet rated)  Rate this |   Briefcase | 4,769 reads

Take the SQL Estate Data Mapping Survey and help shape Redgate’s products

Help Redgate to learn more about how SQL Server teams keep on top of sensitive data. If you're planning, or are already implementing, an information audit or data-mapping exercise for your SQL Server estate, please complete their short survey.  Read more...
By 2018/04/03 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,163 reads

Paying It Forward

Today we have a guest editorial from Andy Galbraith that looks at the ways in which he has helped others in his career.  Read more...
By Andy Galbraith 2018/04/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 223 reads

Storing a variable with a SELECT, and why it didn't work.

Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.  Read more...
By Kenneth Fisher 2018/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,774 reads

A New New Microsoft

Microsoft reorganizes their divisions again.  Read more...
By Steve Jones 2018/04/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads

How to Back Up SQL Server to Azure Blob Storage

When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,784 reads

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

This article shows how to use the SQL Prompt actions that you can apply as part of the Format SQL command. These actions are designed to help improve the overall quality of your SQL code, in various subtle but meaningful ways, such as qualifying object names, standardizing the use of aliases, adding semicolons to the end of statements, and removing unnecessary square brackets around object names.  Read more...
By 2018/04/02 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,861 reads

Exam 70-462: Using Azure for the Practice Setup

A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.  Read more...
By Nathan Bell 2018/03/30 (first published: 2015/08/25) | Source: SQLServerCentral.com | Category: certification
Rating: |  Discuss |   Briefcase | 5,144 reads

SQL Server Authenticated Users, why are we still using them?

AD Authentication in SQL Server has been around for a long time, so why do we still use SQL Authentication?  Read more...
By Ben Kubicek 2018/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads

Troubleshooting Parameter Sniffing Issues the Right Way: Part 1

Tara Kizer explains that many of you are troubleshooting Parameter Sniffing issues the wrong way in production. In this three-part series, she will show you how to troubleshoot it the right way.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,657 reads

When to use the SELECT…INTO statement

SELECT…INTO is a good way of making a table-source temporarily persistent as part of a process, if you don’t care about constraints, indexes or special columns.  Read more...
By 2018/03/30 | Source: Redgate | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,373 reads

Scripting All Objects from SSMS in to a VCS

A short tutorial on scripting objects in SSMS.  Read more...
By Steve Jones 2018/03/29 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 1,050 reads

Driving up database coding standards using SQL Prompt

This article will demonstrate how a team can use SQL Prompt to establish and share coding standards, through code analysis rules, formatting styles and code snippets.  Read more...
By 2018/03/29 | Source: Redgate | Category: coding standards
Rating: (not yet rated)  Rate this |   Briefcase | 3,451 reads

dbatools is Growing Up

The dbatools project is rapidly expanding.  Read more...
By Steve Jones 2018/03/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads

SQL Server Graph Databases – Part 1: Introduction

SQL Server 2017 now includes a new feature to represent complex relationships in data called Graph Databases. Robert Sheldon introduces Graph Databases in the first article of this new series.  Read more...
By Additional Articles 2018/03/29 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 4,033 reads

The Nightmare Letter

The GDPR may bring nightmare letters like the one linked to from the editorial.  Read more...
By Steve Jones 2018/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory

Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.  Read more...
By Mike McQuillan 2018/03/28 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 248 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2018/03/28 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 69,110 reads

How does GDPR impact your SQL Server Recovery Plans

With GDPR on the imminent horizon, there are many things that Data Platform engineers need to consider with regards to the rights of data subjects. Primary among these is understanding the impact of requests to be forgotten and updates to a person's data when it comes to restoring databases. If you have data that is within the scope of the GDPR then here are some thoughts on extra processes for your DR planning.  Read more...
By Additional Articles 2018/03/28 | Source: MSSQLTips.com | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 3,104 reads
<< Newer    Items 61 to 80 of 16732    Older >>