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

Content with tag SQL Rss

   Items 1 to 20 of 38    Older >>
 

SQL Server 2016 Storage Limits

By Stanley Kapfunde 2017/06/01 | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 915 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,450 reads

SQL Server 2014 system databases

By Stanley Kapfunde 2017/05/30 | Category: sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,010 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,014 reads

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: |  Discuss |   Briefcase | 288 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 | 486 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,440 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,483 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,523 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 | 674 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: |  Discuss |   Briefcase | 328 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 | 403 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 | 373 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 | 444 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 | 629 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,209 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,123 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 | 452 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 | 963 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,756 reads
   Items 1 to 20 of 38    Older >>
 
Tags
azure (8)    
data (8)    
server (8)    
powershell (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)    
databases (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)    
search (1)    
services (1)    
smo (1)    
snippets (1)    
sql login (1)    
sqlcmd (1)    
storage (1)    
stored procedure (1)    
studio (1)    
substring (1)    
system (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)