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

Latest Blog Posts

Outlier Detection with SQL Server, part 6.1: Visual Outlier Detection with Reporting Services

 By Steve Bolton

…………Most of the previous articles in this self-tutorials on using SQL Server to find outliers required us to implement statistical formulas, in order to derive measures that required some explanation before they could be interpreted correctly. In this segment of the series, we’ll be discussing a… Read more

0 comments, 111 reads

Posted in Multidimensional Mayhem on 21 April 2015

What Permissions do I need to generate a deploy script with SSDT?

It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you may not want to give the user or process that does this sysadmin permissions just so that it can generate a…

Read more

0 comments, 110 reads

Posted in Ed Elliott's Sql Developer Blog on 21 April 2015

Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking

For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate subnets – something that approximates what you’d see in an enterprise that has multiple remote data centers. I found bits and pieces of the configuration on other sites, but nothing… Read more

1 comments, 4 reads

Posted in The Data Files on 21 April 2015

Excel Tip #25: Overlaying Charts

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 120 reads

Posted in DataOnWheels on 21 April 2015

Speaking at IT/Dev Connections

I am very happy to announce that I will be presenting two sessions at this year’s IT/Dev Connections conference in Las Vegas! The conference is held September 14-17th at the ARIA Resort. My two sessions are:

Handle with Care: Virtual SQL Servers

Maintaining the performance of a mission-critical SQL Server… Read more

0 comments, 60 reads

Posted in Technobabble by Klee from @kleegeek on 21 April 2015

Query Hash Formula Changes Between Versions

The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on their 2014 instance in order to validate performance after an upgrade. The plan was to use query hash values. I was curious, so I set up a quick test. First,… Read more

2 comments, 112 reads

Posted in The Scary DBA on 21 April 2015

How to Configure E-mail in SQL Server Step by Step–TIP #96


For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL  Server provides E-mail functionality using “Database Email” feature. We can setup any E-mail  in few simple steps.

Let’s follow below steps

Step 1:- Open “ Read more

1 comments, 84 reads

Posted in Rajat Jaiswal-337252 on 21 April 2015

Follow the yellow brick what? My road to public speaking.

Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr

If you would have asked me 2 years ago if I had ever considered public speaking my response would have been a definitive no! In the words of the cowardly lion, “Not no way! Not no how!”.… Read more

0 comments, 1,527 reads

Posted in on 21 April 2015

SQL 2014 CU5

By David Postlethwaite

If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited GUI support for SQL Azure databases. Right click gives you very few options and there’s no designer for tables, views or logins. You will have to brush up on…

Read more

0 comments, 88 reads

Posted in The SQL DBA in the UK on 21 April 2015

In-Memory OLTP: Part 3 – Checkpoints

This post follows on from In-Memory OLTP: Part 2 – Indexes

So far in this blog series memory optimised tables have been created with the durability option of SCHEMA_ONLY meaning that data will not be retained. However there is another durability option of SCHEMA_AND_DATA which means that SQL will retain… Read more

4 comments, 81 reads

Posted in The DBA Who Came In From The Cold on 20 April 2015

The MERGE Statement – One Statement for INSERT, UPDATE and DELETE

Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant ways. A short definition of this new feature would be: it allows us to write a single statement to synchronize data in two tables by executing any combination of INSERT,… Read more

2 comments, 126 reads

Posted in Gorandalf's SQL Blog on 20 April 2015



Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement.  You can use this to record what workstation the transaction came from in your application or business intelligence processes.

HOST_ID will return the Process ID from the client… Read more

0 comments, 1,564 reads

Posted in Business Intelligence and Enterprise Architecture on 20 April 2015

The hidden security of msdb

To be fair it’s not actually hidden, just not so well known.

Have you ever wondered how to grant permissions to create/modify jobs? How about SSIS packages?

Every database has the following built in roles:

  • db_accessadmin
  • db_backupoperator
  • db_datareader
  • db_datawriter
  • db_ddladmin
  • db_denydatareader
  • db_denydatawriter
  • db_owner
  • db_securityadmin

However the msdb database has… Read more

3 comments, 144 reads

Posted in SQLStudies on 20 April 2015

Using the SSIS Object Variable as a Data Flow Source

Object variables in SSIS are incredibly versatile, allowing the storage of almost any type of data (even .NET objects). In my last post on this topic, I demonstrated how an SSIS object variable containing a .NET DataSet object could be used by the for each loop container as an… Read more

1 comments, 105 reads

Posted in Tim Mitchell on 20 April 2015

Tracking Table Usage and Identifying Unused Objects

One of the things I hate the most about “old” databases is the fact that unused tables are kept forever, because nobody knows whether they’re used or not. Sometimes it’s really hard to tell. Some databases are accessed by a huge number of applications, reports, ETL tools and God knows… Read more

2 comments, 143 reads

Posted in SpaghettiDBA on 20 April 2015

Techfuse MN 2015

Join me at Techfuse Minnesota 2015. I will be presenting on Excel Dashboards.

Read more

0 comments, 129 reads

Posted in DataOnWheels on 20 April 2015

Clustered Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”)

Continuation from the previous 50 parts, the whole series can be found at This post is dedicated to usage of one of the most important technologies in ETL space – SQL Server Integration Services and its integration with the…

Read more

4 comments, 143 reads

Posted in Niko's blog on 19 April 2015

Rebuild Indexes of database with fragmentation more than 30%

Rebuild of indexes is the prime job of a DBA as heavily fragmented indexes can degrade query performance and cause your application to respond slowly. We should reorganize indexed with fragmentation between > 5% and < 30% and rebuild indexes if fragmentation more than 30%. To rebuild indexes we…

Read more

0 comments, 175 reads

Posted in BI Expert on 18 April 2015

Windows Phone – What Should Microsoft Do?

I’ve been intrigued by Windows Phone as a platform. I’ve never owned one, and while I considered getting one, the dearth of apps led me to an Android instead. I really tried to get down to a list of core apps that I needed, which was 12 or 15 at… Read more

1 comments, 198 reads

Posted in The Voice of the DBA on 17 April 2015

Heraflux is Hiring

I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development. When we first started our company in September 2013, we had a number of short and long term goals about how we wanted to grow and scale our… Read more

0 comments, 112 reads

Posted in Technobabble by Klee from @kleegeek on 17 April 2015

Newer posts

Older posts