Sites anglophones


Today’s Press Conference Transcript: I’m Running for Database Administrator General

Publié le 14 mai 2018 sur brentozar.com
 

Thanks for joining me today – I know you reporters are all really busy, and I appreciate you taking the time to attend this press conference. I’d like to start off by formally announcing my candidacy for Database Administrator General. Ther …

Auto assign Column Data Types for Flat file Source Import

Publié le 14 mai 2018 sur sqlservercentral.com
 

A tip to auto detect data types for flat file sources in SSIS. Never manually enter them ever again!

SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database

Publié le 14 mai 2018 sur sqlservercentral.com
 

The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships.

SQL SERVER – FIX: Msg 22004 – The Log File is Not Using Unicode Format

Publié le 14 mai 2018 sur journey to sqlauthority
 

Recently, I was playing with some settings in SQL Server Agent and encountered an interesting issue. In this blog we would learn about how to fix error Msg 22004 – The log file is not using Unicode format. When I tried to open SQL Server Agent Lo …

How to Find Last Full Backup Time and Size for Database? – Interview Question of the Week #173

Publié le 13 mai 2018 sur journey to sqlauthority
 

Question: How to Find Last Full Backup Time and Size for Database? Answer: What makes me unhappy during any of my Comprehensive Database Performance Health Check is DBA and Developers often not taking backup of their database. It is really sad to …

SQL SERVER – DPM Backup Failure – E_COORD_LOG_CHAIN_BROKEN – The Backup Failed Because of a Gap in The LSN the Log Files

Publié le 12 mai 2018 sur journey to sqlauthority
 

If you are a SQL DBA then this blog might be a quick refresher for you. I am writing this for Data Protection Manager (DPM) Administrators who are not aware of the cause of the issue. In this blog, we would learn about how to fix error raised by DPM …

Informal Poll: What Are Your Favorite Error Log Messages?

Publié le 11 mai 2018 sur brentozar.com
 

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 brentozar.com
 

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 sqlservercentral.com
 

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 sqlservercentral.com
 

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 sqlservercentral.com
 

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 12.0.0.0

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 simple-talk.com
 

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 brentozar.com
 

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 simple-talk.com
 

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 …


Pages :