To See Which Vendors Are Serious About Your Cloud, See How Much Money It Makes Them
When evaluating the core components of IT right now — the cloud, machine learning, data storage and analysis, security, collaboration, productivity — it doesn’t hurt to see whether the tool you’ll rely on for business is the same one your v …
Extracting a DAX Query Plan With Analysis Services 2016 Extended Events
In this post, Koen Verbeeck shows how to use SQL Sever 2016’s Extended Events to find the query plan for a DAX query, just like you would for a T-SQL statement.
Responding to Ransomware: From Detection to Damage Control
Sponsored by: CloudBerry Lab
SQL SERVER – Move Database Files for a Mirrored Database Without Breaking Mirroring
Database mirroring is a very popular solution for high availability. Later on I am finding quite a many people DBAs opting for mirrored databases. As faster and faster drives are now available in the market and DBAs are moving their database to faster …
Is Raleigh the East Coast's Silicon Valley?
While the Raleigh area is proud of its booming IT economy, it’s not sure it wants to become Silicon Valley East.
IT/Dev Connections 2017 Draws to Successful Close
Today marks the end of the 2017 IT/Dev Connections in San Francisco. Over the course of the last 4 days we had almost 200 sessions covering topics encompassing a broad swath of products, services, and concepts across the information technology landscap …
New class: IEBISec on Securing Your BI Platform
We’ve added a second brand-new class to our Spring line-up in Chicago: Immersion Event on Securing Your BI Platform. It’s a 2-day class, taught by MVP and industry expert Stacia Varga, presented on May 3-4, 2018. By …
New class: IEBIStrat on Developing a BI and Analytics Strategy
We’ve added a brand-new class to our Spring line-up in Chicago: Immersion Event on Developing a BI and Analytics Strategy. It’s a 3-day class, taught by MVP and industry expert Stacia Varga, presented on April 30 …
Let’s mix things up with a new way to learn.
Because learning SQL Server is painful, we’ve been experimenting with new topics, new guest instructors, new ways of talking to other students during class, and much more. On October 30, I’m going to unveil our new live class lineup coverin …
Google’s ‘Quantum Supremacy’ Moment May Not Mean What You Think
Even those bullish on technology, including Google itself, think it will be another decade before either error-corrected or error-free quantum computing is possible.
Distributed Computing Principles & SQL-on-Hadoop Systems
A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.
SQL Monitor Quick Tip: Using the SQL static code analysis performance rules
This quick tip will review how SQL Monitor 7 has incorporated SQL Code Guard’s built-in set of Performance Rules for static code analysis. These rules are designed to highlight SQL syntax that could potential cause performance problems, and so in …
Data Starvation – Balance Your SQL Server – Part 2
In Part 1 I covered how much data your SQL Server should be processing and the effects if it isn’t. Here we check to make sure that you’re achieving that speed. Let us continue learning about data starvation in this blog post. We will …
FAQs: Windows Server 1709; Fixing Windows Store on WIndows 10; DHCP Scopes
Three times a week (Monday/Wednesday/Friday), John Savill tackles your most pressing IT questions. Read through the FAQ archives, or send him your questions via email.
SQL Server 2017 CU1 is Available
On October 24, 2017, Microsoft released SQL Server 2017 Cumulative Update 1, which is Build 14.0.3006.16. This CU has 68 hot fixes by my count, which is a fairly high count. This shows that Microsoft has been busy fixing issues that have shown up since …