SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2012/10/27 to 2012/11/03

SQL Server Function to return a range of dates

A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.  Read more...
By Additional Articles 2012/11/02 | Source: MSSQLTips.com | Category: date manipulation
Rating:  Rate this |   Briefcase | 4,883 reads

Last chance for a day of free SQL Server training at SQL in the City 2012

SQL Server developers and database administrators have one last chance for a full day of free training and networking at SQL in the City 2012.  Read more...
By Press Release 2012/11/02 (first published: 2012/10/25) | Source: Redgate | Category: sql in the city
Rating: |  Discuss |   Briefcase | 3,867 reads

Parsing Parameters in a Stored Procedure

This article shows a clean non-looping method to parse comma separated values from a parameter passed to a stored procedure.  Read more...
By Diego Buendía 2012/11/02 (first published: 2010/08/10) | Source: SQLServerCentral.com | Category: array
Rating: |  Discuss |   Briefcase | 28,619 reads

Manipulating XML Data in SQL Server

When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from SQL, it is often done 'at arms length'. A shame, since effective use of techniques that go beyond the basics can save much code,  Read more...
By Additional Articles 2012/11/01 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,857 reads

MDX Guide for SQL Folks: Part I - Navigating The Cube

Learn all you need to know about MDX, by drawing only on your current SQL knowledge.   Read more...
By Frank A. Banin 2014/06/13 (first published: 2012/11/01) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 20,549 reads

SQL Server Reporting Services 2012 Permissions

As you begin developing reports for deployment to a Report Server, what security considerations need to be taken into account in order to grant users access to run a report.  Read more...
By Additional Articles 2012/10/31 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,832 reads

Stairway to SQL Dialects Level 1: Overview

In the first level of his Stairway to SQL Dialects, Joe Celko looks at the origins of the SQL language and how the language has spawned the various different dialects in use today.  Read more...
By Joe Celko 2012/10/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,504 reads

SQL Server 2012 Integration Services - Unattended Execution of SSIS Packages

Quite often, tasks accomplished via SSIS are a part of procedures that run unattended, either scheduled to launch at a particular date and time or triggered by some arbitrarily chosen event. Marcin Policht shares a typical approach to implementing such a scenario.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,366 reads

Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Merry Christmas from SQLServerCentral. We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it’s the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2. And it's free.  Read more...
By Press Release 2012/12/25 (first published: 2012/10/30) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 18,097 reads

Routine Dependency Visualizer

This article contains a T-SQL script that can show you the dependency of all objects in your SQL Server database.  Read more...
By Angel Rapallo 2012/10/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,039 reads

Stairway to XML: Level 7 - Updating Data in an XML Instance

You need to provide the necessary keywords and define the XQuery and value expressions in your XML DML expression in order to use the modify() method to update element and attribute values in either typed or untyped XML instances in an XML column. Robert Sheldon explains how.  Read more...
By Rob Sheldon 2012/10/29 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,682 reads

The PoSh DBA: Solutions using PowerShell and SQL Server

PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much more than getting information from SQL Server instances via PowerShell; it can also be run from SQL Server as part of a system that helps with administrative and monitoring tasks.  Read more...
By Additional Articles 2012/10/29 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 3,231 reads