Click here to monitor SSC
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 8 of 8   
 

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,138 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,020 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 | 134 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 | 94 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,220 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,410 reads

Converting to data-driven code

How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs  Read more...
By Mike Tanner 2015/03/16 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 6,566 reads

Data Mining Part 24: SQL Profiler and Data Mining

In this chapter we will detect the Data Mining activity using SQL Server Profiler.  Read more...
By Daniel Calbimonte 2015/02/09 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 2,939 reads
   Items 1 to 8 of 8