Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Rss

   Items 1 to 20 of 22    Older >>
 

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 | 1,965 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 | 419 reads

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 | 826 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,715 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 | 1,967 reads

Extracting string after and before a Character/Pattern

Finding characters/string before and after some character or pattern  Read more...
Rating: |  Discuss |   Briefcase | 1,556 reads

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,008 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 | 3,389 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,625 reads

A Tutorial With the Azure CLI (Command-Line Interface) and Azure SQL Database

In this article, we will show how to install Azure CLI and then create an Azure SQL Server and a SQL Database.  Read more...
By Daniel Calbimonte 2016/08/22 | Source: SQLServerCentral.com | Category: command
Rating: |  Discuss |   Briefcase | 724 reads

Backup Strategy in Azure SQL?

Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.  Read more...
By Daniel Calbimonte 2016/08/08 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 793 reads

Using Powershell to run queries on remote server .

This is a function written in powershell , which can used to run queries remotely   Read more...
By himanshu.sinha 2016/07/20 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 654 reads

Automatically Creating UML Database Diagrams for SQL Server

SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell. Phil Factor shows how.  Read more...
By Additional Articles 2016/05/27 | Source: SimpleTalk | Category: diagrams
Rating: (not yet rated)  Rate this |   Briefcase | 4,343 reads

Data Mining Part 37: The Data Mining query transformation task

This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task  Read more...
By Daniel Calbimonte 2016/04/14 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,047 reads

On formatting SQL code

How much SQL code formatting is too much?  Read more...
By Phil Factor 2016/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 145 reads

SQL, and Ye Shall Find

Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.  Read more...
By Phil Factor 2016/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 99 reads

Extracting string after and before a Character/Pattern

Finding characters/string before and after some character or pattern  Read more...
Rating: |  Discuss |   Briefcase | 1,556 reads

SQL Explained

A short explanation and infographic of what SQL is. For the non-SQL people in your life.  Read more...
By Additional Articles 2015/07/24 | Source: Other | Category: sql
Rating:  Rate this |   Briefcase | 8,342 reads

10 SQL Snippets For Faster, More Effective Code

How many hours per week do you spend writing the same SQL again and again?  Read more...
By Gaurav Vohra 2015/07/16 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 5,422 reads

Size of nvarchar(max)??

By Shiva N 2015/06/23 | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,978 reads
   Items 1 to 20 of 22    Older >>
 
Tags
server (6)    
azure (5)    
data (5)    
powershell (5)    
warehouse (3)    
database weekly (2)    
editorial (2)    
query (2)    
ado (1)    
bcp (1)    
c# (1)    
characters (1)    
charindex (1)    
command (1)    
copy (1)    
create (1)    
csv (1)    
data mining (1)    
database (1)    
data-driven (1)    
diagrams (1)    
export (1)    
files (1)    
git (1)    
github (1)    
infographic (1)    
integration services (ssis) (1)    
interface (1)    
join (1)    
line (1)    
linux (1)    
mining (1)    
patindex (1)    
performance (1)    
pivot (1)    
point (1)    
productivity (1)    
profiler (1)    
prompt (1)    
remote (1)    
repository (1)    
restore (1)    
smo (1)    
snippets (1)    
sqlcmd (1)    
studio (1)    
substring (1)    
task (1)    
team (1)    
text (1)    
t-sql (1)    
uml (1)    
unpivot (1)    
visual (1)    
vnext (1)    
xml (1)    
xpath (1)    
xquery (1)