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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,796,828 DBAs, developers and SQL Server users

Rss
Headlines today   April 21, 2015

Data Mining Part 26: Microsoft Data Mining with Cubes

In this tutorial we will explain what are the SSAS cubes to use them in Data Mining.  Read more...
By Daniel Calbimonte 2015/04/21 | Source: SQLServerCentral.com | Category: data mining
Rating: (not yet rated) |  Discuss |   Briefcase | 286 reads

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image

There are several different approaches to automating deployment of SQL Server Infrastructure-as-a-Service virtual machines in Microsoft Azure. Marcin Policht examines an approach that involves uploading or creating a custom operating system image which is well suited for scenarios where you want to deploy a custom-configured SQL Server instance to multiple virtual machines with minimal effort and maximum consistency.  Read more...
By Additional Articles 2015/04/21 | Source: Database Journal | Category: iaas
Rating: (not yet rated)  Rate this |   Briefcase | 357 reads
Previous headlines

SSIS Design Pattern - Staging Delimited Flat Files

Learn how to use SSIS to load Delimited Flat Files to staging tables.  Read more...
Rating: |  Discuss |   Briefcase | 4,529 reads

How to Get SQL Server Data Conversion Horribly Wrong

One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit data conversion is a good feature for the expert but can cause a lot of trouble to the unwary. These boil down to seven ways of failing to get data conversion right. Rob Sheldon explains and gives sage advice on how to avoid the problems.  Read more...
By Additional Articles 2015/04/20 | Source: SimpleTalk | Category: data conversion
Rating: (not yet rated)  Rate this |   Briefcase | 3,242 reads

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL?  Read more...
By John Hick 2015/04/17 (first published: 2013/04/18) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 32,002 reads

Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery

Join us on Tuesday 28th April at 4pm BST (11am EDT) for a free webinar panel discussion featuring Brian A. Randell, Grant Fritchey, Steve Jones, and host, Stephanie Herr, on the topic of maintaining visibility and control in database continuous delivery.   Read more...
By Press Release 2015/04/17 | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,936 reads

How DBAs Can Adopt the Craftsman Mindset

The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen find that the better they get at the work, the more enjoyable the work gets, and the more successful they become. Deliberate practice, Specialization and an appetite for overcoming difficulty are good habits to deliberately adopt to successfully grow those craftsmanlike skills to the point that you become “so good they can’t ignore you”.  Read more...
By Additional Articles 2015/04/17 | Source: SimpleTalk | Category: dba skills
Rating:  Rate this |   Briefcase | 4,190 reads

How to Categorize Uncategorized Data

Using SQL to perform cluster analysis to gain insight into data with unknown groups  Read more...
By Stephan Calderon 2015/04/16 | Source: SQLServerCentral.com | Category: cluster analysis
Rating: |  Discuss |   Briefcase | 3,418 reads

Microsoft® SQL Server® 2014 Service Pack 1 (SP1) released

Service Pack 1 for SQL Server 2014 has been released.  Read more...
By 2015/04/16 | Source: Microsoft SQL Home | Category: sql server 2014
Rating:  Rate this |   Briefcase | 6,710 reads

Selecting Data Using the TOP Clause

There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.  Read more...
By Additional Articles 2015/04/16 | Source: Database Journal | Category: top
Rating:  Rate this |   Briefcase | 5,581 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

In Memory Optimized Table in SQL Server 2014

To increase performance of highly accessible tables, a new feature incorporated in Sql Server 2014 “In-Memory OLTP”.You can define a...  Read more...
By UmaShankar Patel 2015/04/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 290 reads

Exam Prep 70-463: Installing Master Data Services

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...  Read more...
By Colleen M. Morrow 2015/04/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 286 reads
Question of the Day

Illegal CTEs

By Steve Jones 2015/04/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 92 reads

I have a SQL Server 2014 database set to compatability level 120. I am building a recursive CTE for a report, but receive an error. Which of these items in...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
ArnoKwetters
816 816 SSC Eights!  
2.
Eirikur Eiriksson
458 3442 Hall of Fame  
3.
zzalina0
415 1339 Ten Centuries  
4.
Grant Fritchey
300 15049 SSCoach  
5.
daniel.plocinik
248 447 SSC-Addicted  
Latest forum posts