(Nicky van Vroenhoven) Whenever I restore a database from a customer in my development environment I have the issue of orphaned users: users in the database have no corresponding login on the server/instance.

(Jeffrey Yao) As a contract consultant, I frequently need to create scripts for various tasks, so over the years with different clients, I have accumulated lots of scripts and they are often located in complex folders on different computers, is there any good way to archive and manage these scripts?

(Thomas LaRock) Last week while building out some labs for my upcoming session at SQL Saturday Austin, I noticed this screen during the installation of SQL Server 2016 CTP3 (the green markers are mine, obviously):

(Marcin Policht) Traditional deployments of Azure SQL Database involve identifying projected resource requirements (in terms of expected database size and performance load) and selecting the corresponding service tier and performance level. These, in turn, determine the sizing of resulting Azure SQL

(Pinal Dave) While playing with linked server from SQL Server to SQL Server, I faced few errors and fixed them as well. It has become a custom to get errors working with Linked Servers almost every time. I personally thought it is worth blogging because I didn’t find any single blog having the cause

(John Miner) Power BI designer is based upon the Power Query formula language informally known as “M” and in this tip we look at how to convert and format numbers using the M language.

(Pinal Dave) Sometimes I go into these simple explorations that make me learn something new that gets me off the routine. SQL Server is always on the agenda and that passion will never die. This exploration was based on the fact when I was talking to someone about some of the super cool stuff people

(Shaun Stuart) Reader *** H. posted a comment on my last version of this script stating that he got an error when this was run against tables containing sparse columns. Data compression does not support tables with sparse columns, so they should be excluded from this process. I’ve modified this scri

(Jessica Sirkin) Microsoft has a new, simplified method for configuring SQL Server on a Microsoft Azure virtual machine. The simpler setup procedure will allow users to configure SQL Server on Microsoft Azure without the aid of a database administrator.

(Dennes Torres) SQL Server keeps a record to identify if a check constraint is trustable or not. When all the records in the database where checked against the constraint it’s trustable, otherwise it’s not.