Sites anglophones


Announcing Group By: A New Kind of Free Community Conference

Publié le 29 novembre 2016 sur brentozar.com
 

Let’s try something new. Let’s build a free event by the community, for the community, where: Speakers submit abstracts publicly online. Anybody can submit an abstract on any topic – community members, software vendors, even Microsoft …

Determining What Happens When You Force an Execution Plan via the Query Store

Publié le 29 novembre 2016 sur simple-talk.com
 

In one of my previous articles about the Query Store I briefly touched on the subject of forcing an execution plan via the Query Store. There is, however, much more to relate than I could fit in the previous introduction article. In this article, I …

PASS SQL Saturday #567 Slovenia 2016 Sponsors

Publié le 29 novembre 2016 sur sqlblog.com
 

Time to expose our wonderful sponsors, who enabled the event! Please check their companies and their great product and services. And here is the list, with the link to the SQL Saturday #567 Sponsors page, where you can click individual links.

EzAdo Part 4

Publié le 29 novembre 2016 sur sqlservercentral.com
 

EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.

Quick SQL Prompt Tip – using the CDB snippet

Publié le 29 novembre 2016 sur sqlservercentral.com
 

There are a number of built-in snippets for SQL Prompt, and many of them are very simple, but they can greatly speed up your T-SQL coding if you learn what they are. Data Platform MVP Steve Jones shows how to make best use of the popular CDB snippet, f …

SQL SERVER – Error – Disallowing page allocations for database ‘DB’ due to insufficient memory in the resource pool

Publié le 29 novembre 2016 sur journey to sqlauthority
 

Keeping SQL Server up-to-date is something I recommend my customers from time to time. One of the tasks I undertake is to check the current SQL Server version information as soon as I get started to work. Though this recommendation looks trivial at the …

[Video] Office Hours 2016/11/23 (With Transcriptions)

Publié le 28 novembre 2016 sur brentozar.com
 

This week, Brent and Richie discuss their hardware setups, lazy spools, SQL 2016 Service Pack 1, Always On Availability Groups, Database IDs, GroupBy.org, SQL on Linux, and new features they would like to see in the new version of SQL. Here’s the …

SQL in the City Streamed

Publié le 28 novembre 2016 sur sqlservercentral.com
 

Register now for Redgate’s free virtual event offering a wealth of SQL Server sessions for you to live-stream on December 14 and 15.

How to Change an Analysis Services Instance to Tabular Mode

Publié le 28 novembre 2016 sur sqlservercentral.com
 

In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode

Migrating Databases to Azure SQL Database

Publié le 28 novembre 2016 sur sqlservercentral.com
 

Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step- …

SQL SERVER – Playing with Backups and Compression

Publié le 28 novembre 2016 sur journey to sqlauthority
 

The era of innovation with SQL Server administration side of things keep happening, it is strange that a lot of us miss these capabilities getting added into the system. I have seen processes define the way how DBA’s work. In a lot of places, the …

Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)

Publié le 27 novembre 2016 sur sqlblog.com
 

You’re coding away with SSIS, happy as a clam, and it’s now time to deploy your hard work to an instance of the SSIS Catalog. If you’re in Visual Studio, you right-click the project name in Solution Explorer and click Deploy. If you …

SQL Server 2016 SP1 Bug with Graphical Execution Plans

Publié le 27 novembre 2016 sur brentozar.com
 

Early adopters: if you’re rolling on SQL Server 2016 SP1, you may have noticed that when you click on query plans in sp_BlitzCache or sp_WhoIsActive, they sometimes render as ugly XML rather than the beautiful graphical showplan. Here’s a 3 …

How to Downgrade Database from SQL Server 2014 to SQL Server 2012 – Interview Question of the Week #099

Publié le 27 novembre 2016 sur journey to sqlauthority
 

Question: How to downgrade from SQL Server 2014 to SQL Server 2012? Answer: Not possible. Do not give up reading this blog post there is one workaround. Workaround You can script your entire database with Data and then execute the script on your new da …

SQL SERVER – System Function @@IDLE to Find System Ideal Time

Publié le 26 novembre 2016 sur journey to sqlauthority
 

Just the other day I got an email with user asking how does the @@idle function work with SQL Server as when he runs them it gives him some number but the number is not easy to interpret. I totally agree with the observation. When I was new to SQL Serv …


Pages :