Sites anglophones

Informal Poll: What Are Your Favorite Error Log Messages?

Publié le 11 mai 2018 sur

I Know You Have Yours Gone Fishin’ I have mine. When I go looking at a server for the first time, I wanna know about stuff like corruption, stack dumps, 15 second I/O warnings, frozen I/O, and non-yielding schedulers. You know, the real meaty, ha …

Where Clustered Index Keys Dare

Publié le 11 mai 2018 sur

Colonel Clustered We’ve blogged a couple times about how clustered index key columns get stored in your nonclustered indexes: here and here. But where they get stored is a matter of weird SQL trivia. You see, it depends on how you define your non …

Automatic Provisioning of Developer Databases with SQL Provision

Publié le 11 mai 2018 sur

This article shows a simple proof-of-concept workflow that allows an organization to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process.

Strange Filtered Index Problem

Publié le 11 mai 2018 sur

What I thought was a strange filtered index problem but turned out to be a DB settings problem

Create Azure VMs with PowerShell Part 1

Publié le 11 mai 2018 sur

Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather informa …

SQL SERVER – Error: Could not Load File or Assembly Microsoft. SqlServer. management. sdk. sfc Version

Publié le 11 mai 2018 sur journey to sqlauthority

My virtual machines are my playground and I do install/uninstall a lot of stuff there (of course related to SQL Server learning). When things break, I get to learn something new. In this blog we would talk about how to troubleshoot and fix Could not lo …

Converting a Database to In-Memory OLTP

Publié le 10 mai 2018 sur

Microsoft In-Memory OLTP was introduced with SQL Server 2014. In the pre-release mode, I saw quite a few videos that demonstrate the strength of this new technology. When the final release came to light, I was very disappointed. First, this technology …

Book Review: Microsoft SQL Server Training, Volume 1

Publié le 10 mai 2018 sur

Last week, I shared a few pictures out of Ron Soukup’s Inside SQL Server 6.5 book. You had a blast with that one, so I figured I’d share some more pictures from another, uh, let’s call it “well-preserved” book about S …

Power BI – Part 1: Introduction

Publié le 10 mai 2018 sur

The series so far: Power BI – Part 1: Introduction Microsoft’s Power BI is not just a cloud service. It’s a suite of integrated business intelligence (BI) tools for accessing and consolidating data and then presenting it as actionable insig …

SQL Compare Snapshots: a lightweight database version control and rollback mechanism

Publié le 10 mai 2018 sur

SQL Compare snapshots provide an easy way to keep track of changes during development work, whether they are small changes between iterations, or significant changes between releases. Snapshots can be used to quickly generate rollback scripts during re …

One Million Tables

Publié le 10 mai 2018 sur

A quick experiment to create one million tables in a database.

Setting up SQL Server on Red Hat Linux in AWS – Part 1

Publié le 10 mai 2018 sur

In this post, Pinakin Patel looks at the preliminary steps you need to peform to build an instance in AWS to run SQL Server on Red Hat Linux.

SQL SERVER – Why Suddenly DBCC CHECKDB Running Very Slow?

Publié le 10 mai 2018 sur journey to sqlauthority

Recently during Comprehensive Database Performance Health Check, I was asked a fascinating question. They wanted to know why suddenly their DBCC CHECKDB process started to run very very slow. My customer who has no full-time DBAs in their organiza …

Importing JSON Collections into SQL Server

Publié le 9 mai 2018 sur

It is fairly easy to Import JSON collections of documents into SQL Server if there is an underlying ‘explicit’ table schema available to them. If each of the documents have different schemas, then you have little chance. Fortunately, schema …

When Query Plans Lie Part 2

Publié le 9 mai 2018 sur

Getting Weirder In Part 1, we looked at how query plans can tell us little lies. Now we’re going to look at how those little lies can turn into bigger lies. Adding An Index Right now, this is our query:SELECT u.UpVotes, u.DownVotes FROM dbo.Users …

Pages :