SQL Server

SQL Server Community

SQL Server Blogs

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...
24 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á...
19 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...
33 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
46 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...
41 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...
37 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...
32 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...
28 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...
44 0 /
Jason Strate
Follow /25 Jul 2014 at 5:00pm / SQL Server

Reblog: July 18 to July 24

Photo credit – Husso I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried...
52 0 /
Tracy McKibben
Follow /25 Jul 2014 at 1:00pm / SQL Server

Friday Followup For July 25, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Don’t Get Slimed By Bad Parameter Sniffing...
147 0 /
Follow /25 Jul 2014 at 1:45am / SQL Server

Cumulative Updates – SQL Server 2012 SP2 CU1

As part of their Incremental Service Modelling , Microsoft have released SQL Server 2012 Service Pack 2 Cumulative Update 1! In my article about SQL Server 2012 SP2 I shared a post about a bug that was not fixed in SQL 2012 SP2 which was in earlier...
179 0 /
Dinesh Asanka
Follow /23 Jul 2014 at 3:37pm / SQL Server

Cannot show the editor for this task.

I got this error in SSIS when I try to open Execute SQL Task. Then I tried to open already configured Execute SQL Task in some other SSIS packages. Still the error exists. I was wondering this is an error in SQL Server 2014 so I installed SQL Server 2012...
64 0 /
Stuart Ainsworth
Follow /23 Jul 2014 at 3:00pm / SQL Server

Determining the Primary Key of a table without knowing it’s name

So, I’ve been trying to find more technical fodder for blog posts lately in order to get in the habit of blogging on a regular basis, so I thought I would explore a few of my higher-ranked answers on StackOverflow and provide a little more detail than...
173 0 /
Kenneth Fisher
Follow /23 Jul 2014 at 1:00pm / SQL Server

Why am I getting a primary/unique key violation?

This may seem like a question with a simple answer but there is a bit more to it than you might think. In fact I know of 3 possible reasons (and there may be more I don’t know) for seeing a primary key error. Technically they occur for any unique...
65 0 /