SQL Server

SQL Server Community

SQL Server Blogs

Follow /31 Jul 2014 at 5:19pm / SQL Server

Website Pulse

Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working as a DBA. They’ve now published the article, it can be found at the following link:- http://www.websitepulse.com/blog/for-dbas-think-of...
15 0 /
Tim Radney
Follow /31 Jul 2014 at 4:39pm / SQL Server

An error occurred while executing batch. Error message is: Arithmetic Overflow

Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records from the database. The error message the customer received was “An error occurred while executing batch. Error message is: Arithmetic...
16 0 /
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...
39 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...
51 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...
37 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...
18 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...
98 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...
53 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á...
36 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...
39 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...
79 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
65 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...
51 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...
55 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...
44 0 /