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

Latest Blog Posts

Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016?)

Continuation from the previous 53 parts, the whole series can be found at This is a not very deep technical post, which is describing the upcoming news and changes in SQL Server 2016. Since there is no public CTP…

Read more

0 comments, 30 reads

Posted in Niko's blog on 27 May 2015

SQL F.A.D. – CSV List of Columns - WaterOx Consulting

Reading Time: 2 minutes

I had a project once that was using change data capture (CDC)...

The post SQL F.A.D. – CSV List of Columns appeared first on WaterOx Consulting.

Read more

1 comments, 35 reads

Posted in WaterOx SQL on 27 May 2015

PASS Board Update: May 2015

I’ve had a busy month on the Board.

You may have seen some tweets going by about our compliance with international laws regarding SPAM. This has been something of an education, so anything I say wrong below, it’s because I’m wrong, but not malevolent (at least in regards to this… Read more

0 comments, 40 reads

Posted in The Scary DBA on 27 May 2015

High Performance T-SQL using Code Patterns

What exactly does this mean?  We’ve heard of “code patterns” in other programming languages, but what does it mean to use T-SQL code patterns to develop high performance T-SQL?  Having now been called out by a couple of folks in the SQLverse that I respect, most recently the editor of… Read more

0 comments, 64 reads

Posted in DwainCSQL on 27 May 2015

Speaking at ITPROceed 2015

This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT professional. The conference takes place the 11th of June at Utopolis Mechelen. My session is situated in the Data Platform & Internet of Things track and is titled Demystifying… Read more

0 comments, 46 reads

Posted in Koen Verbeeck on 27 May 2015

Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot. I’ve also done a bit of Power Pivot work…

Read more

1 comments, 68 reads

Posted in SQL Server BI Blog on 27 May 2015

Native Client Aliases don’t like Trailing Spaces

I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that it deserved a shout out to the community.

When you create an alias in the SQL Server Configuration Manager, make sure that the alias name contains no spaces,… Read more

0 comments, 52 reads

Posted in SpaghettiDBA on 26 May 2015

New Articles About Datazen, Microsoft’s Mobile Dashboard Platform

I’m pleased to share the first two articles in a series for SQL Server Pro Magazine.  Here’s a short excerpt from each with a link to the full article:   Getting Started with Datazen, Microsoft’s New Mobile Dashboard Platform (Part 1) Microsoft Datazen is a new tool from Microsoft built…

Read more

0 comments, 72 reads

Posted in SQL Server BI Blog on 26 May 2015

Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP

Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored procedure(With Execute as Owner), and was getting an error –


Could not obtain information about Windows NT group/user ‘Domain\UserName’, error code 0x5.

My first reaction was to… Read more

0 comments, 55 reads

Posted in on 26 May 2015

Migrating SQL Agent Jobs with Schedules using T-SQL

I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like. One thing I have not found readily is the ability to create jobs while maintaining the scheduling in place. For those who may not be aware, the easiest way to… Read more

0 comments, 71 reads

Posted in Jared Zagelbaum's Blog on 26 May 2015

Tuesday Morning SQL Break – May 26, 2015

It’s Tuesday (Monday was a holiday for me this week) and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information… Read more

0 comments, 58 reads

Posted in StrateSQL on 26 May 2015

Database Engine Tuning Advisor

I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that I included a chapter on it in my query tuning book (all updated for SQL Server 2014 by the way). Let me tell you why we need to pull… Read more

2 comments, 71 reads

Posted in The Scary DBA on 26 May 2015

SQL Agent Job Wrapper Part 3 – Handing the Errors in the Wrapper Script

This is the 3rd installment in a small series of blog posts on how to create a PowerShell wrapper for running SQL Server Agent Jobs. Here are the links to the 2 previous posts and I recommend reading them because all of the posts build on the previous one.

Creating… Read more

0 comments, 56 reads

Posted in on 26 May 2015

Default database

The default database is one of the options when creating a login in SQL Server. This is the initial database that the login will connect to when logging in. Unless of course you specify a different database in your connection string.

-- Creating a login with a…

Read more

0 comments, 74 reads

Posted in SQLStudies on 26 May 2015

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite

Once you have created your database you can now start to manage and configure it.

There are six menus for a SQL Azure Database: -

  • Dashboard
  • Monitor
  • Scale
  • Configure
  • GEO-Replication
  • Auditing and Security
The Dashboard

The Dashboard gives an overview of the state of your Azure database.… Read more

0 comments, 61 reads

Posted in The SQL DBA in the UK on 26 May 2015

SQL Server 2016 features I’m interested in

Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can download the datasheet they’ve posted from here.

The features that have caught my attention are:-

  • Enhancements to In-Memory OLTP
  • The Query Data Store
  • Temporal Database
  • Stretch Database
  • Automatic failover…

Read more

0 comments, 121 reads

Posted in The DBA Who Came In From The Cold on 26 May 2015

Row Numbers and Running Totals in SSIS

During data load or transformation processes, capturing a distinct row number for incoming data can be beneficial for the ETL process itself, as well as for use in the destination database. Having an arbitrary, incrementing row number assigned to each row can help to determine the order in which the… Read more

0 comments, 88 reads

Posted in Tim Mitchell on 26 May 2015

Read the Transaction Logs in SQL Server


In this tutorial we will know about, how to read a transaction log in SQL server and also we will learn all the reading methods of a transaction log. From this tutorial you will know why MS SQL permits you to read the transaction logs. As we know very…

Read more

0 comments, 103 reads

Posted in Zora's SQL Tips on 25 May 2015

Changing NULL to NOT NULL – Dealing with Data

I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple way. However I didn’t cover some of the cases where you have data in the column, or other restrictions that you might need to deal with. In this post, I… Read more

0 comments, 120 reads

Posted in The Voice of the DBA on 25 May 2015

Database Administration via CrowdSourcing

According to Wikipedia:

 Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group of people, and especially from an online community, rather than from traditional employees or suppliers.

Every DBA must have googled something to address his/her technical issue, and… Read more

0 comments, 89 reads

Posted in DBA Philosophy on 25 May 2015

Older posts