Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

<< Newer    Items 41 to 60 of 13873    Older >>

Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.  Read more...
By Mickey Stuewe 2015/06/23 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,502 reads

SQL Server Downloads

A list of the free version, tools, and sample downloads.  Read more...
By Site Owners 2015/06/23 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 3,129 reads

SQLXML Bulk Loader Basics

SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way of heaving large quantities of data into SQL Server databases. SQLXML is very versatile, and once set up is wonderfully reliable ETL system, but isn't trivial to learn. Adam Aspin comes to the rescue with a simple guide.  Read more...
By Additional Articles 2015/06/23 | Source: SimpleTalk | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 3,553 reads

The Test of Time

IBM recently turned 100 years old and Steve Jones wishes more companies would try to build their business to grow to 100.  Read more...
By Steve Jones 2015/06/22 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 196 reads

The Case for Specifying Data Types and Query Performance

Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.  Read more...
By Chad Feghali 2015/06/22 | Source: | Category:
Rating: |  Discuss |   Briefcase | 5,512 reads

Learning SQL Server 2016

Here is a reference that lets you take a quick look at the new features in SQL Server 2016 and dig into the various items with a collection of links we'll maintain.  Read more...
By Site Owners 2015/06/22 | Source: | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 4,039 reads

Comparing Oracle and SQL Server Code - Part 1

In this tip, Daniel Calbimonte compares the SQL Server (T-SQL) and Oracle (PL-SQL) extensions of the SQL language. The tip will compare both T-SQL and PL-SQL languages with respect to retrieving data, creating databases, tables, variables, etc.  Read more...
By Additional Articles 2015/06/22 | Source: | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,781 reads

The Stress of a Former DBA

Rodney Landrum impresses on his audience the importance of attention to the finer details, during data analysis and reporting.  Read more...
By rodneylandrum 2015/06/22 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 153 reads

Does It Count?

This Friday Steve Jones asks how you track uptime. Does your scheduled maintenance count against your metrics?  Read more...
By Steve Jones 2015/06/19 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 168 reads

Trigger an Email of an SSRS Report from an SSIS Package

This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.  Read more...
By Stan Kulp 2015/06/19 (first published: 2013/03/19) | Source: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 17,059 reads

Script All Server Level Objects to Recreate SQL Server

Carla Abanes provides a guide on how to create a console application that will generate create scripts for server level objects for multiple SQL Server instances. This is handy in the event of a disaster and you need to create a clone of the SQL Server that is no longer available.   Read more...
By Additional Articles 2015/06/19 | Source: | Category: objects
Rating: (not yet rated)  Rate this |   Briefcase | 2,754 reads

Sweat Files and Practice Projects

Today we have a guest editorial from Andy Warren that looks at side projects and how you might actually grow our careers.  Read more...
By Andy Warren 2015/06/18 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 121 reads

A Syntax Mystery in a Previously Working Procedure

A previous working script show syntax errors on recreating (sp_helptext script line length limitation)  Read more...
By Marwa Joseph 2015/06/18 | Source: | Category: sp_helptext
Rating: |  Discuss |   Briefcase | 5,279 reads

Using R to Explore Data by Analysis - for SQL Professionals

What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with an interesting set of data, and some helpful suggestions that point out the parallels with SQL. Feodor provides the data and the helpful suggestions. The rest is up to you.  Read more...
By Additional Articles 2015/06/18 | Source: SimpleTalk | Category: r language
Rating: (not yet rated)  Rate this |   Briefcase | 4,038 reads

Culture Clashes and Arrogance

A guest editorial from Andy Warren looks at the disagreements between teams in technology.  Read more...
By Andy Warren 2015/06/17 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 168 reads

Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions

BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.  Read more...
By Bill Pearson 2015/06/17 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,573 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2015/06/17 (first published: 2013/08/14) | Source: Redgate | Category: transaction logs
Rating:  Rate this |   Briefcase | 66,114 reads

Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell

In this article, Tim Smith goes through a couple of options to automate heartbeat checks against Azure databases. This is useful if you're moved SQL Server databases to Azure and you want to have periodic checks to make sure the databases are responsive.  Read more...
By Additional Articles 2015/06/17 | Source: | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,330 reads

Data Mining Part 29: Programming with C# and AMO

In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.  Read more...
By Daniel Calbimonte 2015/06/16 | Source: | Category: data mining
Rating: |  Discuss |   Briefcase | 1,987 reads

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.  Read more...
By Additional Articles 2015/06/16 | Source: Database Journal | Category: pivot
Rating:  Rate this |   Briefcase | 3,683 reads
<< Newer    Items 41 to 60 of 13873    Older >>