Sites anglophones

New Azure SQL Database Standard Tier Sizes

Publié le 22 décembre 2017 sur

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

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

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

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

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 - 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

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

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

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

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

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.

SAP’s blockchain strategy to build on supply chain base

Publié le 21 décembre 2017 sur

The enterprise software giant is leveraging its supply chain customer base and expertise to integrate blockchain technology into its core products.

Add 'Open Command Window Here' to Windows 10 Context Menu

Publié le 21 décembre 2017 sur

This how-to focuses on bringing back the option to launch the command prompt from the right-click Windows 10 context menu.

SQL SERVER – Fix: Error – VS Shell Installation Has Failed with Exit Code 1638

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

Recently I got called in by a regular customer for my On Demand (50 minutes) service. Every single day I keep two hours available to help DBAs who need urgent help with SQL Server. When I connected with a customer, I was expecting to solve their SQL Se …

Pages :