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 …
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.
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.
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.
SAP’s blockchain strategy to build on supply chain base
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
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
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 …
Apple Is Said to Have Plan to Combine IPhone, IPad, Mac Apps
Starting as early as next year, software developers will be able to design a single application that works with a touchscreen or mouse and trackpad depending on whether it’s running on the iPhone and iPad operating system or on Mac hardware.
Docker CEO Tries to Navigate Business Threat From Google
While Docker and Kubernetes serve slightly different purposes, customers who choose Google’s tool can avoid paying Docker.
Live online training from Kimberly in early January!
We’ve been considering doing some live, online training classes for a while now, and with the demand for Kimberly to teach an Immersion Event on partitioning, we’ve decided to take the plunge and present our first live, online class in Janu …
Introduction to Agile with SQL Server
Overview of Agile Agile software development can be broken down into several methodologies, such as Scrum and XP (Extreme Programming). For the purposes of this article I’ll be referring to Scrum but the theories apply to Agile as a whole. Agile …