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

Latest Blog Posts

Security-Fixes for SQL Server and why Security Best Practices Matter / Sicherheitsfixe für SQL Server und warum Sicherheits Best Practices wichtig sind (MS15-058 SQL Server Security Bulletin)

Ziemlich genau ein Jahr nachdem die für 5 Jahre ersten Sicherheits-Bugs in SQL Server gefixt werden mussten, gibt es nun, seit 14.7.2015, wieder einen Grund, seine Security-Patching-Policy zu testen.

- Wenn man denn eine solche für SQL Server hat.

Und damit möchte ich jetzt niemanden anprangern. Denn: die letzten Jahre… Read more

Change in sys.dm_exec_query_stats in SQL Server 2016

Sys.dm_exec_query_stats is most commonly used DMO used by DBA and developers to find out the information about queries involving query …

Continue reading Read more

0 comments, 169 reads

Posted in Kapil Blogs on 25 July 2015

MDW Data Collector – Collection Set jobs not working


Error Message 1 :

Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS – Read Current Upload Data [1], Description: String too long. The adapter read a string that was 50331648 bytes long, and expected a string no longer than… Read more

0 comments, 118 reads

Posted in MSSQLFUN on 24 July 2015

Columnstore Indexes at PASS Performance Palooza: Recording and Materials

Yesterday I participated in PASS Performance Palooza.

I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.

The recording is already up:


The scripts and slide deck can be downloaded from here.

The post Columnstore Indexes at PASS Performance Palooza: Recording and Materials Read more

0 comments, 138 reads

Posted in Matan Yungman on 24 July 2015

Power BI Desktop: A Guide for Excel Users

Today Microsoft officially released the new development tool for Power BI called Power BI Desktop.  First of all let me share my excitement in what this release means for Power BI.  The team at Microsoft has done an incredible job and the results are something they can truly be proud… Read more

1 comments, 646 reads

Posted in Devin Knight on 24 July 2015

Get Away from the Heat and Learn some Database Version Control

I have enjoyed the trips I’ve made to New Orleans and Baton Rouge in the past. It’s a good getaway, stopping in the French Quarter for a few minutes before an easy drive up the road. However it’s warm, and I can’t ever get my wife or kids to come… Read more

2 comments, 69 reads

Posted in The Voice of the DBA on 24 July 2015

013 – The Start of Something Big! - WaterOx Consulting

Reading Time: 4 minutes

Together we can make a difference in the data world! In WOxPod!,...

The post 013 – The Start of Something Big! appeared first on WaterOx Consulting.

Read more

0 comments, 148 reads

Posted in WaterOx SQL on 24 July 2015

Boost your OLTP database performance with SQL Server 2014 in-memory tables

Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-Memory OLTP. In-Memory OLTP (project Hekaton) functionality was designed to expedite the processing of typical OLTP-operation in SQL Server. As you know, server load can be divided into… Read more

0 comments, 186 reads

Posted in Forrards Group Database Blog on 24 July 2015

Setting Up and Using Azure VM SQL Automated Backup (and Restore)

This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots. I have always used my Powershell scripts described here to create my test systems and with a new job taking up a lot of my time had missed the announcement… Read more

0 comments, 193 reads

Posted in SQL DBA With A Beard on 24 July 2015

Power Bi Desktop Release Today

You can download the much hyped up Power BI Desktop (formerly Power BI Designer). There are many blogs about the new features, but I am going to mention one here that I have been waiting for.

It involves connecting to the Analysis Service database as a connection and not an… Read more

0 comments, 117 reads

Posted in The Smiling DBA on 24 July 2015

Speaking on Standardized SQL Installations – Script Review & Demo – SQLSaturday (Sacramento)

Prakash Heda will show you how to do multiple versions of SQL Server installations using single scripts with all best practices baked in, This session is mostly demo-focused. I will cover prerequisites for scripts and demonstrate how to Streamline SQL Server implementations.

Read more

0 comments, 140 reads

Posted in SQLFeatures on 24 July 2015

My SQL Server Service Account Philosophy

Recently someone sent me a question about service accounts. They weren’t sure how they should go about setting accounts up for various instances and services in their environments. Specifically they asked me about having domain accounts, or accounts separate for services.

Note that I’ve managed SQL Server for years this… Read more

2 comments, 30 reads

Posted in The Voice of the DBA on 23 July 2015

Forgot sa password for your SQL Server?

It may happen so that you don`t know the password of sa user for SQL Server you inherited from somebody. Actually it can happen cause of many reasons. We`ll try to resolve this issue now.

So here is a step by step guide for resetting forgotten sa password.

1. First… Read more

1 comments, 2,840 reads

Posted in Forrards Group Database Blog on 23 July 2015

Without Borders – Getting Involved

One of the things I enjoy about the SQL community is the many people that you come into contact with. Whether it is speaking, interacting, listening, or collaborating one can meet many data professionals from all walks of life. With that you get to know, invest, and follow individuals. Two… Read more

0 comments, 126 reads

Posted in The SQL Professor on 23 July 2015

Professional Development – Set the Bar High

Originally appearing at

Henry Ford is reported to have once said, “Whether you think you can or think you can’t – you’re right.”

That’s great insight. Too often people place self-imposed and artificial limitations on themselves. They tell themselves that they cannot accomplish something because they aren’t smart… Read more

0 comments, 101 reads

Posted in Kevin E. Kline on 23 July 2015

Reblog: Star Schema The Complete Reference – Review

SQLKover update: 1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on dimensional modelling around. Recommended/obligatory reading!

I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit,… Read more

0 comments, 1,296 reads

Posted in Koen Verbeeck on 23 July 2015

SQLSaturday #386 - SQLSaturday in Albany, NY

Coming this Saturday, upstate rules, the official capitol of New York State is #SQLSat386, in Albany! Check out their event home page for more details of speakers, sponsors, sessions, and registration.  The event will be held at SUNY Albany Campus -  Map, July 25, 2015 at SUNY Albany,… Read more

0 comments, 169 reads

Posted in Pearl Knows on 23 July 2015

SQL server 2016 CTP 2.2

Microsoft has announced that The SQL Server 2016 Upgrade Advisor Preview and SQL Server 2016 Community Technology Preview (CTP) 2.2 are now available for download!

This first look at SQL Server 2016 Upgrade Advisor showcases a new platform for the database upgrade tool.  upgrade advisor  also introduces the Stretch Database… Read more

0 comments, 142 reads

Posted in SQLSERVERS’dba on 23 July 2015

Changes in In-Memory OLTP in SQL Server 2016

In SQL Server 2014 a new feature In-Memory OLTP was introduced which was referred as ‘Hekaton’. This feature was introduced …

Continue reading Read more

0 comments, 162 reads

Posted in Kapil Blogs on 23 July 2015

AdventureworksCI Step 5 Adding tSQLt to the solution

This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server database into source control? What issues do we face and how hard is it? Then how do we build a continuous…

Read more

0 comments, 680 reads

Posted in Ed Elliott's Sql Developer Blog on 22 July 2015

Newer posts

Older posts