Sites anglophones

In The Cloud: Azure Cosmos DB

Publié le 22 mai 2017 sur

Azure Cosmos DB is Microsoft’s new global scale, distributed database as a service that supersedes Azure Document DB. Cosmos is a technology that enables you to create applications that are unimaginable with a single conventional relational datab …

SQL SERVER – How to Change Database Compatibility Level?

Publié le 22 mai 2017 sur journey to sqlauthority

After watching my free webinar the most popular question, which I receive is about Database Compatibility Level. Here is the script which shows how you can change the database compatibility level to different version of SQL Server. Please note to under …

In The Cloud: Azure Portal and HTML5 Storage Capacity Exceeded

Publié le 21 mai 2017 sur

While preparing blog posts last week, the following message appeared in my browser window. I was in the Azure portal when the message appeared. It’s not an error with Azure or the browser. It could happen when using any website or browser. I trie …

[Video] Office Hours 2017/05/17 (With Transcriptions)

Publié le 21 mai 2017 sur

This week, Erik, Tara, and Richie discuss enforcing password expiration for SA logins, keeping things in sync between servers, development/prototyping missions of on-premise vs. cloud, ways of backing up databases, and more. Here’s the video on Y …

[OT] Never Bet Against Cloud Computing

Publié le 21 mai 2017 sur

Today at the Preakness horse racing event, Classic Empire dominated and led the race appearing to be the certain winner with Always Dreaming staying a close second and appearing to be a possible contender. At the end, Cloud Computing charged ahead leav …

How to Find Running SQL Trace? – Interview Question of the Week #123

Publié le 21 mai 2017 sur journey to sqlauthority

Question: How to Find Running SQL Trace? Once we know the trace exists, how to stop and delete them? Answer: There are two questions in this blog post and both are very interesting one. SQL Trace are marked to be deprecated for a while and it is r …

In The Cloud: Owner Role and Security Administration

Publié le 20 mai 2017 sur

Azure uses Role Based Access Control (RBAC), which is something people generally don’t pay at lot of attention to when initially learning how to use the Azure portal. Take a close look at the screen capture shown below. The Delete button is disab …

SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable

Publié le 20 mai 2017 sur journey to sqlauthority

A few months ago, I wrote a blog which tells us reasons about why we should use tools provided with the product rather than generic tools. Yeah, I am talking about services.msc vs. SQL Server Configuration manager. Why to Use SQL Server Configuration M …

What Do You Want to See in a Free Query Store Tool?

Publié le 19 mai 2017 sur

I love Query Plans No seriously, I love digging into query plans. Even writing XQuery to dig into them in sp_BlitzCache. I was both honored and horrified to take over development of it from Jeremiah. It’s a beast, but it’s my kind of beast. …

Do SQL Server 2017’s Adaptive Joins Work with Cross Apply or Exists?

Publié le 19 mai 2017 sur

I think I’ve mentioned that the most fun part of new features is testing them with old ideas to see how they react. It occurred to me that if Adaptive Joins didn’t work with APPLY, I might cry. So, here goes nothin’! Cross Simple Cros …

Deploying, Securing, and Updating Power BI Reports

Publié le 19 mai 2017 sur

Power BI app is used to provide updateable visualizations of an organization’s business data; its graphs, plots, tables, reports and other types of visualization. It is designed to make it easier and quicker to deploy summarizations of business d …

Continuous Database Deployment with Confidence

Publié le 19 mai 2017 sur

Overview Deploying many changes a day to a SQL Server database sounds hard; but as long as you have the tools and processes in place, and you understand the steps involved, then it is straightforward. In this article, I would like to show one example o …

Registration Now Open for SQL Cruise Alaska in August 2017

Publié le 19 mai 2017 sur

Forecasting with SQL

Publié le 19 mai 2017 sur

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.

Installing SQL Server Agent on Ubuntu Server

Publié le 19 mai 2017 sur

Manvendra Singh explains how to install SQL Server Agent on an Ubuntu server, so that you can create SQL Server Agent Jobs to schedule repetitive tasks.

Pages :