Sites anglophones

Free eBook: SQL Server Internals: In-Memory OLTP

Publié le 9 janvier 2018 sur

In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your …

Azure DWH part 23: Data Mining

Publié le 9 janvier 2018 sur

SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.

SQL SERVER – Introduction to Log Space Usage DMV – sys.dm_db_log_space_usage

Publié le 9 janvier 2018 sur journey to sqlauthority

It has been quite a while since SQL Server 2017 has been introduced, however just recently I have been seeing interest for this project. Lots of users are just switching to SQL Server 2017 and I believe that is normal. In the year 2017 during my Compre …

This is my most difficult SQLBlog post ever…and almost certainly, my last

Publié le 8 janvier 2018 sur

The pain of parting is nothing to the joy of meeting again – Charles Dickens It amazes me, but I have blogged here for over 11 years. My first post was about some new functionality in SQL Server 2005, Service pack 2. It was cross posted to drsql.spaces …

Checking Your Meltdown and Spectre Mitigation Status in Windows

Publié le 8 janvier 2018 sur - glen berry

As I have previously discussed, there has been an explosion of information and speculation about the Spectre and Meltdown vulnerabilities. Here is the official information about all three vulnerabilities. Spectre CVE-2017-5753 (Bounds Check Bypass) CVE …

The 2018 Data Professionals Salary Survey Results

Publié le 8 janvier 2018 sur

How much do database administrators, analysts, architects, developers, and data scientists make? We asked, and 3,113 of you from 73 countries answered this year. I make my query bucks the hard way Download the 2018 & 2017 results in Excel. A few th …

6 reasons why your development team needs SQL Prompt

Publié le 8 janvier 2018 sur

While SQL Prompt cannot turn an unskilled database programmer into a SQL hero, it will drive up the productivity of a typical multi-skilled development team, and reduce reliance on specialist database developers.

Implementing Azure SQL Database Virtual Network Service Endpoints and Rules

Publié le 8 janvier 2018 sur

In previous articles, Marcin Policht has described the main characteristics of two new features known as Virtual Network service endpoints and Azure SQL Database virtual network rules. In this article, he focuses on the details of implementing this fun …

How to Change the File Extension for a Data File

Publié le 8 janvier 2018 sur

This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension

SQL SERVER – Puzzle – Solution – Why Does UNION ALL Work but UNION Produces Error?

Publié le 8 janvier 2018 sur journey to sqlauthority

Last week, I asked a very simple puzzle about SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?. The puzzle was very simple and interesting both together. I got quite a few valid answers to the puzzle so far. You …

How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155

Publié le 7 janvier 2018 sur journey to sqlauthority

Question: How to List All the clustered and nonclustered Indexes of Your Table in SQL Server? I have previously blogged about this few years ago but at that time SQL Server did not supported Columnstore Indexes as well other kind of indexes. I recently …

[Video] Office Hours 2018/1/3 (With Transcriptions)

Publié le 6 janvier 2018 sur

This week Brent and Richie discuss the latest big Intel CPU security flaw, distributed transactions, rebuilding indexes, SQL Server health check, GDPR regulations, Availability Groups issues, improving server performance, patching for instances th …

SQL SERVER – Log Shipping Monitor Not Getting Updated

Publié le 6 janvier 2018 sur journey to sqlauthority

One of my clients has implemented log shipping and everything was working fine. Recently they implemented a reporting tool which reported alerts that data missing for few log shipping tables. The data for “last_backup_file” and “last_ …

Blog moved

Publié le 5 janvier 2018 sur

Blog has been moved to: Follow me on twitter:

Automating Complacency

Publié le 5 janvier 2018 sur

There’s no Latin word for Robot I’m all for automation, especially when it comes to the boring stuff. As awesome as the automation routines we have for that are, I still see people messing it up. Right now, there’s no Clippy/HAL mashu …

Pages :