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
0 comments, 26 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 25 July 2015
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS – Read Current Upload Data , Description: String too long. The adapter read a string that was 50331648 bytes long, and expected a string no longer than… Read more
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.
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
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
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
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
It involves connecting to the Analysis Service database as a connection and not an… Read more
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
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
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
Originally appearing at ForITPros.com.
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
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
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
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
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…