ITPro SnapShot: What Else Happened This Week? (Dec. 16 – 22, 2017)
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
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.
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
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
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
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
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
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
If cloud is a model and not a place, you should be able to have it anywhere.
SQL Server 2014 SP2 CU9
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?
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
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
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
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
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.