Sites anglophones

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.

SQL Server 2016 Cumulative Updates (May 2017)

Publié le 19 mai 2017 sur

Microsoft has released the following Cumulative Updates for SQL Server 2016 (RTM and SP1). Cumulative Update 6 for SQL Server 2016 RTMKB 4019914DownloadBuild number: 13.0.2204.0SQL Release Services Blog post Cumulative Update 3 for …

Passively Mine SSIS Data Flow Rows Loaded From the SSIS Catalog

Publié le 19 mai 2017 sur

As I wrote in Parsing SSIS Catalog Messages for Lookup Performance, v2 : I prefer to passively gather performance metrics – even if it’s a little convoluted and more work (for me). I don’t often need these metrics immediately availabl …

SQL SERVER – Login Failed – Server is in Script Upgrade Mode – Deleting Collection Set “Utility Information”

Publié le 19 mai 2017 sur journey to sqlauthority

I must confess that consulting has taught me much more than what I have learned in my regular job. Freelancing comes with advantages and disadvantages. For me, I am looking at advantages and I am happy with my decision. Let us see how to fix an error r …

BI Beginner: Stacked Charts in Power BI

Publié le 18 mai 2017 sur

People new to Power BI Desktop have asked me how to create a columnar chart where each column has different colors for different values stacked on top of each other. There’s no reason to be intimidated. Creating such a chart is very simple with o …

Building a Faux PaaS, Part 2: Choosing and Testing a Cloud Vendor

Publié le 18 mai 2017 sur

Background: I’m working with kCura to build a Faux PaaS: something akin to Microsoft’s Azure SQL DB, but internally managed. In Part 1 of this series, I talked about why we’re building it, and today, I’ll talk about where. The d …

How Redgate helped define a truly automated database deployment process

Publié le 18 mai 2017 sur

At the end of 2016, Redgate interviewed Bob Walker, a Lead Application Developer, to find out how he went about setting up automated database deployments using Redgate tools, and also to find out what lessons he learned during the process – the highlig …

Some of my greatest mistakes

Publié le 18 mai 2017 sur

You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.

Pages :