Sites anglophones


ITPro SnapShot: What Else Happened This Week? (Dec. 16 – 22, 2017)

Publié le 22 décembre 2017 sur sqlmag.com
 

ITPro SnapShot offers a short and snappy round-up on the week’s industry-related announcements and news around the globe. Here’s what happened in the last five days.

Alphabet's Schmidt Hands Reins to Google Founders, Leaders

Publié le 22 décembre 2017 sur sqlmag.com
 

Schmidt will become a technical adviser to Alphabet while continuing to serve as a director, the company said Thursday in a statement.

Sizing A New Server? Start With Maintenance.

Publié le 22 décembre 2017 sur brentozar.com
 

Clientele Most of out customers are on slightly (ahem) older (AHEM) hardware, and they have big questions: How do we know what kind of hardware we need? How do we load test it? How do we know what to change to make it better? The load test question is …

New Azure SQL Database Standard Tier Sizes

Publié le 22 décembre 2017 sur sqlservercentral.com
 

Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.

Securing Reporting Services Reports

Publié le 22 décembre 2017 sur sqlservercentral.com
 

Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.

Research: There are Now Close to 400 Hyper-Scale Data Centers in the World

Publié le 22 décembre 2017 sur sqlmag.com
 

There will be more than 390 hyper-scale data centers in the world by the end of the year. An overwhelming majority of those facilities — 44 percent — are in the US, China being a distant second, with 8 percent, followed by Japan, UK, and Germany.

Download and Install SQL SERVER 2017 Developer Edition for FREE

Publié le 22 décembre 2017 sur journey to sqlauthority
 

SQL Server 2017 has been released for a while. I have been using it for a while and it is a pretty stable release from Microsoft. The installation of SQL Server 2017 is pretty straight forward and very similar to previous versions of SQL Server. This w …

Bitcoin Intensifies Pain for Some as Ransom Demands Skyrocket

Publié le 21 décembre 2017 sur sqlmag.com
 

Once a niche market, ransom insurance is booming as hackers demand bitcoins in ransomware attacks.

Azure Stack Brings Microsoft's Cloud Outside Microsoft Data Centers

Publié le 21 décembre 2017 sur sqlmag.com
 

If cloud is a model and not a place, you should be able to have it anywhere.

SQL Server 2014 SP2 CU9

Publié le 21 décembre 2017 sur sqlskills.com - glen berry
 

On December 18, 2017, Microsoft released SQL Server 2014 SP2 CU9, which is Build 12.05563.0. By my count, this CU has seven public hotfixes, nearly all of which are for the SQL Engine of SQL performance. Since SQL Server 2014 SP1 and earlier are no lon …

Do Disabled Indexes Affect Missing Index Recommendations?

Publié le 21 décembre 2017 sur brentozar.com
 

I’m so glad you asked! Let’s take a look. Open up the Stack Overflow database, turn on actual execution plans, and run a query that will cause SQL Server to beg and plead for an index:SELECT * FROM dbo.Users WHERE DisplayName = ‘Hovercraft …

SQL Prompt Hidden Gem: Auto-fill the GROUP BY clause

Publié le 21 décembre 2017 sur sqlservercentral.com
 

Once you install SQL Prompt, you become aware immediately of how it enhances the native IntelliSense features of SSMS, but this can blind you to a lot of other features, hidden in various parts of the tool. In this post I share another gem of a feature …

Different Ways to Find SQL Server Orphaned Users

Publié le 21 décembre 2017 sur sqlservercentral.com
 

SQL Server orphaned users are a common thorny issue in auditing. In this post, Jeffrey Yao provides a few different ways of identifying orphaned users covering various scenarios.

An Introduction to PowerShell for a DBA

Publié le 21 décembre 2017 sur sqlservercentral.com
 

An introduction to PowerShell that covers basics alone with some more advanced features. It will walk you through from the very beginning to the writing of a few useful scripts.

Timeline for Windows Feature Released in RS4 Build 17063

Publié le 21 décembre 2017 sur sqlmag.com
 

Windows Insiders finally have access to the long-awaited Timeline for Windows feature in Redstone 4 Build 17063. But there is much more than just this one feature in the latest development build of Windows 10.


Pages :