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

Articles with tag SQL Rss

Search for any content tagged sql

   Items 1 to 20 of 30    Older >>
 

Azure DWH part 13: Load data using Data Platform Studio

In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse  Read more...
By Daniel Calbimonte 2017/08/01 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 375 reads

SQL-On-Hadoop: Hive - Part I

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/07/26 | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 914 reads

The Louis Davidson custom style for SQL Prompt

In this article, Louis Davidson sticks his neck out, and offers what he believes is a sensible code formatting style, based on twenty-plus years of writing SQL. The result is the Louis Davidson custom SQL Prompt style that you can download using the link at the end of the post, try out, and adapt as required.  Read more...
By 2017/06/30 | Source: Redgate | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,487 reads

Validate Integer and Decimal Values in SQL Server

Bhavesh Patel shows how to validate specific use-cases for integer and decimal values in SQL Server.  Read more...
By Additional Articles 2017/05/31 | Source: MSSQLTips.com | Category: sql
Rating:  Rate this |   Briefcase | 2,626 reads

Doing Fuzzy Searches in SQL Server

A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.  Read more...
By Additional Articles 2017/04/27 | Source: SimpleTalk | Category: sql
Rating:  Rate this |   Briefcase | 5,378 reads

Using PerfMon and PAL to Diagnose SQL Issues

Free tools to help you find and diagnose SQL issues   Read more...
By Jim Youmans 2017/04/12 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,483 reads

Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.  Read more...
By Stan Kulp 2017/04/11 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,551 reads

SQL Login Password Audit

Audit your SQL logins to find passwords that have never been changed or that are very weak.  Read more...
By Jim Youmans 2017/04/04 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,581 reads

Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS

In this article, we will show how to create reports in ASDW using SSRS  Read more...
By Daniel Calbimonte 2017/03/27 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 705 reads

Backups in Azure SQL Data Warehouse

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.  Read more...
By Daniel Calbimonte 2017/03/20 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 427 reads

Azure DWH Part 5: How to work with the command line in Azure SQL DW

This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse  Read more...
By Daniel Calbimonte 2017/03/09 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 473 reads

In-Place Upgrade or Migration

To upgrade or migrate, that is the question. And I have an answer.  Read more...
By Jim Youmans 2017/02/28 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,219 reads

SQL Server vs SQL Server v.Next

An introduction to the basics of current SQL Server vs v.Next Performance Testing.  Read more...
By Henrico Bekker 2017/02/15 | Source: SQLServerCentral.com | Category: vnext
Rating: |  Discuss |   Briefcase | 2,136 reads

Azure SQL Data Warehouse with PowerShell

We will teach how to create a new SQL Azure Data Warehouse using Powershell  Read more...
By Daniel Calbimonte 2017/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 467 reads

Azure DWH part 2: Get Started with Azure Data Warehouse

In this article, we will learn how to use Visual Studio to query Azure SQL Data Warehouse tables and how to create a new table.  Read more...
By Daniel Calbimonte 2017/01/25 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 1,061 reads

Join Two CSV Files with a Common Column

In this example we will join two CSV files with a common column using SQL Server.  Read more...
By Daniel Calbimonte 2017/01/23 | Source: SQLServerCentral.com | Category: join
Rating: |  Discuss |   Briefcase | 1,767 reads

A Possible Alternative to SQL UNPIVOT

Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.  Read more...
By Paul Milligan 2017/01/16 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 2,030 reads

Azure DWH part 1:Common questions about Azure SQL Data Warehouse

This article compiles some common questions and answers about Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2016/12/28 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,510 reads

8 Ways to Export SQL Results To a Text File

This tip will show eight ways to export the results of a query to a text file.  Read more...
By Daniel Calbimonte 2016/10/26 | Source: SQLServerCentral.com | Category: export
Rating: |  Discuss |   Briefcase | 4,189 reads

PowerShell Solutions - Working with files

When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.  Read more...
By Daniel Calbimonte 2016/10/04 | Source: SQLServerCentral.com | Category: copy
Rating: |  Discuss |   Briefcase | 1,655 reads
   Items 1 to 20 of 30    Older >>