SQL Server

SQL Server Community

SQL Server Blogs

Dinesh Asanka
Follow /31 Jul 2014 at 10:47am / SQL Server

Data Mining Cluster Analysis in SQL Server

Grouping is something we naturally do in our day to day life. We group foods depending on taste, we group friends depending on their different attributes. Clustering is an algorithm which finds natural groupings inside your data when these groupings are...
25 0 /
Jen McCown
Follow /30 Jul 2014 at 5:08pm / SQL Server

This Week in Awesome – Running at PASS, Cookie Jail, SQL Sats, Breakfast

If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week - consider signing up for the #SQLLongRun:  “We’ll do a minimum of 11 miles. Why? Because we can.” There is...
44 0 /
Kenneth Fisher
Follow /30 Jul 2014 at 1:00pm / SQL Server

The clustered index columns are in all of the non clustered indexes.

Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. Let’s take a look! First things first I’m going to use some AdventureWorks2012...
35 0 /
Follow /30 Jul 2014 at 12:31pm / SQL Server

Getting Started with SQL Server: Simple SELECT Queries

In this series of lessons you’re going to learn how to query Microsoft SQL Server using the SQL Select statement.  Once you have read this blog and viewed the series of videos you’ll be able to: Identify all the tables in a SQL Server...
9 0 /
Follow /29 Jul 2014 at 9:14pm / SQL Server

Tuesday Tips: Three Performance Objectives for Increased Proactivity

Take a minute and think about your typical day, which of course is much longer than nine to five. Of time spent on database management, whether in the office or remotely, how much is dedicated to proactive performance management versus reacting to performance...
95 0 /
Pradeep Adiga
Follow /29 Jul 2014 at 3:45pm / SQL Server

SQL Server Agent failing to start with the error “StartServiceCtrlDispatcher failed (error 6)”

Recently I worked on an issue where SQL Server Agent was failing to start. Before this there was some problems with the disks on the server and the databases were restored from backups. I started looking for errors in few of the logs System Event...
52 0 /
Ricardo Leka
Follow /29 Jul 2014 at 2:11pm / SQL Server

Testar Porta

Vocês sabem que se quiser testar uma porta TCP um dos métodos mais simples é basicamente um telnet Nome/IP porta. Se o prompt sumir e o cursor ficar piscando a porta está respondendo (claro,, tirando todas as implicações de liberação de firewall e blá...
35 0 /
Follow /29 Jul 2014 at 1:33pm / SQL Server

Get Ready to Learn SQL: 13. Introduction to Inner Joins

Note:  This is the second in a series of articles covering joins. The series starts with the article Introduction to Database Joins .  All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database...
36 0 /
Rohit Garg
Follow /29 Jul 2014 at 10:22am / SQL Server

Rename or Change SQL Server Standalone Named Instance

Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named Instance is almost same as SQL Server Standalone Default Instance. You can change a SQL server named...
78 0 /
Dinesh Asanka
Follow /28 Jul 2014 at 6:53pm / SQL Server

Report SQL Server Percentage Backup Completion and Time Completion

When executing a backup from a t-sql command, it is difficult to know what percentage has completed and when the backup will be complete. This FAQ tells how to do it. http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
64 0 /
Shaun Stuart
Follow /28 Jul 2014 at 2:00pm / SQL Server

Fixing Broken SSRS Subscriptions

SQL Server Reporting Services provides functionality to automatically generate a report on a recurring basis. These reports can then be emailed or written to a file. The method for doing this is called a subscription. It's common for a developer to...
50 0 /
Kenneth Fisher
Follow /28 Jul 2014 at 1:00pm / SQL Server

What is ANSI_NULLS and why will I be glad when it finally goes away?

Recently I wrote about what it means that a value is NULL . Right at the beginning I mentioned ANSI_NULLS and said I would discuss it later. Well it’s later. In the previous post I discussed how NULL is basically “unknown”. And any...
51 0 /
Basit A. Farooq
Follow /28 Jul 2014 at 11:21am / SQL Server

Book: SQL Server 2014 Development Essentials

I am very happy to announce that my first book “ SQL Server 2014 Development Essentials ” has now been published by Packt Publishing . SQL Server 2014 Development Essentials, ISBN: 9781782172550 SQL Server 2014 Development Essentials is...
42 0 /
Chris Webb
Follow /28 Jul 2014 at 10:00am / SQL Server

Calculating The Value Of Overdue Invoices Using Many-To-Many Relationships in SSAS Multidimensional

Recently I had to solve the same, rather complex, problem for three different customers within the space of two weeks, a variation of the ‘events-in-progress’ problem I’ve blogged about a lot in the past. It’s this one: how can you calculate the value...
40 0 /
Rohit Garg
Follow /27 Jul 2014 at 6:39am / SQL Server

Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 1 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are...
54 0 /