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