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

Content with tag SQL Rss

   Items 1 to 20 of 34    Older >>
 

PowerShell 3rd Party tool Memory Alert

Keeps a memory leak under control until the bug fix is developed and applied. Short term band aid.  Read more...
By Edward Pochinski 2017/04/25 | Source: SQLServerCentral.com | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 190 reads

Remove SQL Comments

This function takes in SQL code and returns the same SQL code but with any comments removed (i.e. "/**/", "--")  Read more...
By Jordan Ryder 2017/04/13 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 406 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,285 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,121 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,363 reads

Create reports in Azure SQL Data Warehouse 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 | 640 reads

Find UDF useage

Find all stored procedures that use UDFs  Read more...
By Jim Youmans 2017/03/21 | Source: SQLServerCentral.com | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 301 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 | 375 reads

Find all published tables with row counts and table size

This script will show you all the tables that are being published with sizes.  Read more...
By Jim Youmans 2017/03/16 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 344 reads

How to work with the command line in Azure SQL Data Warehouse

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 | 410 reads

SQL Login Password Audit

Audit you SQL Logins   Read more...
By Jim Youmans 2017/03/07 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 564 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,200 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,100 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 | 434 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 | 909 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,743 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,005 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,564 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,088 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,648 reads
   Items 1 to 20 of 34    Older >>
 
Tags
azure (8)    
data (8)    
powershell (6)    
server (6)    
warehouse (6)    
audit (2)    
database weekly (2)    
editorial (2)    
function (2)    
password (2)    
query (2)    
reporting services (ssrs) (2)    
ado (1)    
backup (1)    
bcp (1)    
c# (1)    
characters (1)    
charindex (1)    
command (1)    
comment (1)    
copy (1)    
create (1)    
csv (1)    
data mining (1)    
database (1)    
data-driven (1)    
dba (1)    
diagrams (1)    
documentation (1)    
export (1)    
files (1)    
git (1)    
github (1)    
infographic (1)    
integration services (ssis) (1)    
interface (1)    
join (1)    
line (1)    
linux (1)    
migration (1)    
mining (1)    
pal (1)    
patindex (1)    
perfmon (1)    
performance (1)    
pivot (1)    
point (1)    
productivity (1)    
profiler (1)    
prompt (1)    
recover (1)    
remote (1)    
replication (1)    
reporting (1)    
reportserver.dbo.catalog (1)    
repository (1)    
restore (1)    
services (1)    
smo (1)    
snippets (1)    
sql login (1)    
sqlcmd (1)    
stored procedure (1)    
studio (1)    
substring (1)    
task (1)    
team (1)    
text (1)    
trouble shooting (1)    
t-sql (1)    
uml (1)    
unpivot (1)    
visual (1)    
vnext (1)    
xml (1)    
xpath (1)    
xquery (1)