SQL Prompt Hidden Gems: The SSMS Results Pane
Louis Davidson explores the hidden treasures within SQL Prompt right-click context menu when working in the SSMS grid format results pane.
Converting Trace to Extended Events
A walkthrough of a conversion of a SQL Trace setup to an Extended Event session. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes o …
In-Memory OLTP – SQL Server In-Memory OLTP Internals Overview
In-Memory OLTP (project “Hekaton”) is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve significant improvem …
SQL SERVER – Transfer Logins Error: Msg 15419: Supplied Parameter sid Should be Binary(16) – sp_help_revlogin
While I was writing my earlier blog, I came across another interesting issue with sp_help_revlogin script. In this blog we would learn about the cause of Msg 15419, “Supplied parameter sid should be binary(16)” while transferring the login …
AMD Ryzen Threadripper 2990X CPU-Z Leaks?
On June 5, 2018, during the Computex show in Taiwan, AMD revealed some details about its upcoming 12nm 2nd generation Ryzen Threadripper processor family that will have up to 32 physical cores (and 64 threads with SMT) that will work on existing X399 m …
How to Fix sp_BlitzIndex Aggressive Indexes Warnings
sp_BlitzIndex gives your indexes a psychiatrist-style evaluation. It’s a lot like a real psychiatrist: it’s just flagging behaviors, and there’s not necessarily anything wrong with being a hoarder, or a workaholic, or a furry. Th …
Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3
The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Desktop provides a p …
Welcome to the new world of curating data, not owning it
Faced with the new challenges of data protection – and increased levels of oversight – many of us working with SQL Server have come to the same conclusion. Quite simply, the column names and free text descriptions available to us to describ …
Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes
SQL SERVER – Unable to Install Reporting Service Add-In for SharePoint – System.ArgumentException
There are so many components in SQL Server and sometimes there is an error in installing components which I have not used at all. One such component is SSRS with SharePoint. To use this, we need to install Reporting Service Add-In for SharePoint. In th …
Performance and Stability Related Fixes in Post-SQL Server 2016 SP2 Builds
As of May 30, 2018, there has been one Cumulative Update (CU) for the Service Pack 2 branch of SQL Server 2016. There have been a large number of hotfixes in each of these cumulative updates. If you are running on the SQL Server 2016 SP2 branch (which …
A Surprising Simplification Limitation
When It Comes To Simplification Rob Farley has my favorite material on it. There’s an incredible amount of laziness ingenuity built into the optimizer to keep your servers from doing unnecessary work. That’s why I’d expect a query lik …
Databases with MAXSIZE Set
Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database. When t …
SQL Server Database Corruption Detect
How to detect DB corruption ASAP…
Reducing risk with Smart Recommendations in SQL Census
Redgate are reducing risk with Smart Recommendations in SQL Census