Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Limitation of In-Memory OLTP in SQL Server 2016 – Seed and Increment value other than 1 not supported

Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than …

Continue reading Read more

0 comments, 58 reads

Posted in Kapil Blogs on 9 February 2016

Introduction to SQL Server: The Main Components

There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a new person just starting a career as a data professional using Microsoft's SQL Server data platform could use to learn all about the product. This made me think I written… Read more

0 comments, 75 reads

Posted in The SQL DBA in the UK on 8 February 2016

SQL Server 2016 Row-level Security and SSRS a perfect match

In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level Security (RLS) with SSRS.  Detailed steps including the TSQL script and SSRS project is provided at the end of this post.  To get started, you need to setup RLS.… Read more

0 comments, 84 reads

Posted in SQLDownSouth on 8 February 2016

Impersonation can give you the wrong answer

I use impersonation all the time to let me see additional permissions information I can only get that way and, sometimes to help me see what permissions error someone is getting.

For those of you who aren’t aware, with the right permissions you can impersonate another principal (server or database)… Read more

0 comments, 80 reads

Posted in SQLStudies on 8 February 2016

T-SQL Tuesday #75 Invitation: Jump into Power BI!

Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading this and thinking “crap, I’m not a BI person!”, don’t you fret. My intention is to make folks who normally don’t use BI on a day to day basis… Read more

0 comments, 50 reads

Posted in SQL Chicken on 8 February 2016

Database Log VLFs

Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files work in the background.  These are created automatically, but automatically doesn’t always mean perfect.  Here’s a practical view of what you need to know and how you can set them… Read more

0 comments, 52 reads

Posted in Simple SQL Server on 8 February 2016

Friend of Redgate 2016

I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and enables us to participate in the conversation around product and community development.

Last year was my first year… Read more

0 comments, 108 reads

Posted in Anthony Nocentino's Blog on 7 February 2016

Gartner Magic Quadrant for BI/BA and the Lone Three Leaders

History clearly confirms that good things come in threes.  As far as I know this is the first time that only the three most widely recognized Business Intelligence platforms have been placed in the top-right leaders/visionaries space of the Magic Quadrant for Business Intelligence and Analytics Platforms, as of February…

Read more

1 comments, 154 reads

Posted in SQL Server BI Blog on 5 February 2016

Power BI Publish to Web for Anonymous Access is Here

Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web” as a preview feature. This is HUUUUGE news! This was probably the top requested feature and its finally here thanks to the hard work and dedication of the Microsoft… Read more

0 comments, 160 reads

Posted in SQL with Dustin Ryan on 5 February 2016

Copying SSIS packages With DTUTIL

A frequent need when performing a server migration is to copy the SSIS packages from one server to a new server.  There are a couple of different ways to do this, including a wizard in SSMS. (See  The catch to this is that these are manual and they…

Read more

0 comments, 109 reads

Posted in Nebraska SQL from @DBA_ANDY on 5 February 2016

Using Custom File Delimiters in SSIS

File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field separator such as comma, tab, or pipe. However, occasionally you’ll get an oddly formatted file with an unusual delimiter. Although it’s not obvious in the Visual Studio designer, SSIS is… Read more

0 comments, 645 reads

Posted in Tim Mitchell on 5 February 2016

Its been a busy start to the year

Its been a busy start to the year at I have been involved in a Big Data training courses in Alexandria - a suberb of DC, followed by the same course running again in London a week later. This  was followed by a SQL Server 2012 skills upgrade course

Read more

0 comments, 111 reads

Posted in The SQL DBA in the UK on 5 February 2016

PASS Summit 2016 – call for Speakers…

PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals, with lot of the tech sessions covering a lot for the Database Development, Database Administration, BI, Cloud, Professional Developement, Training, Tips’n’Tricks and much more.

It is going to be… Read more

0 comments, 118 reads

Posted in Dukagjin Maloku - Dugi'DBA on 5 February 2016

Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)

On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group.  This session is based on five blog posts that I created in August 2015.

You can find the presentation here: Powering Up HDInsight with Power BI (pdf).

The details can be found in the… Read more

0 comments, 122 reads

Posted in DataOnWheels on 4 February 2016


I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a great class. Earlier in the week I got to hear Jes Borland (b|t) talk about extended events and do a session on… Read more

0 comments, 136 reads

Posted in The Scary DBA on 4 February 2016

Columnstore Indexes – part 76 (“Compression Delay”)

Continuation from the previous 75 parts, the whole series can be found at While playing with SQL Server 2016 CTP 3.2, I have found some interesting feature being mentioned inside the engine. The strange thing was called a compression…

Read more

0 comments, 162 reads

Posted in Niko's blog on 4 February 2016

Are SQL Server 2014 Table Variables Different From Temporary Tables?

What are the Table Variables in SQL Server?

In our previous blog we have discussed How to find free space In SQL Server database. Now, in this section we will elaborate about SQL Server 2014 Table Variables. SQL Server support features that allow users to work with temporary data… Read more

0 comments, 100 reads

Posted in Zora's SQL Tips on 4 February 2016

Loading a Text File with a Line Feed

Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but there are times that you might want to automate this without using SSIS. In those cases, it’s nice to know how to load data from a programmatic standpoint.

I had… Read more

1 comments, 194 reads

Posted in The Voice of the DBA on 4 February 2016

Scaling Azure SQL Database

One of the advantages Azure SQL Database has over on-prem SQL Server is the ease in which it can scale.  I’ll discuss the various options for horizontal scaling, vertical scaling, and other similar features.

Horizontal scaling refers to adding or removing databases in order to adjust capacity or overall performance.… Read more

2 comments, 150 reads

Posted in James Serra's Blog on 3 February 2016

Blogger questions: What if someone else wrote about the same subject?

I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a lot of posts (twice a week for > 3 years). Over 340 of them in fact. Because of this a friend asked me what I do if I write a… Read more

6 comments, 133 reads

Posted in SQLStudies on 3 February 2016

Older posts