Have Availability Groups Gotten Easier Lately?
Easy Lover I don’t blog a lot about AGs. If we’re being honest (and I do try to be honest with you, dear reader), I just like performance tuning topics way more. When new features get announced for AGs, some of you may ooh and aah, but not …
An Overview of STRING_SPLIT()
Learn how to use the STRING_SPLIT() function in T-SQL. 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 of disk I/O bottlenecks, in …
SQL Server Logical Reads – What do they really tell us?
In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading
Treating SQL Server as an Object with PowerShell
It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell library, sqlps, that can be used instead. In this article, Greg Moore shows how to use sqlps to treat a SQL Server instanc …
SQL SERVER – Relating Unrelated Tables – A Question from Reader
I often get emails from my blog readers asking various types of questions. Here is one of the interesting questions from a reader about Relating Unrelated Tables. Let us go over it in detail. Users have two tables Table_A and Table_B. I have shown …
How to Shrink All the Log Files for SQL Server? – Interview Question of the Week #203
Question: How to Shrink All the Log Files for SQL Server? Answer: This question was asked recently after reading my latest blog post here: SQL SERVER – Small Backup for Large Database. Before you continue reading this blog post, let me …
[Video] Office Hours 2018/12/5 (With Transcriptions)
This week, Tara and Richie discuss deletes on heaps, Docker, using containers in production environment, advice for new DBA, downgrading server hardware, agent jobs, setting SQL Memory Min and Max to the same value, how to prove CPU pressure to managem …
SQL SERVER – FIX: Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component ‘Ad Hoc Distributed Queries’
I wrote a blog earlier about reading data from excel via SQL Server. This was done using ‘OpenRowset. One of my blog readers sent an email to me that they were getting an error. In this blog, we would see how to fix Msg 15281 – SQL Server b …
“Surely this one will get a clustered index scan.”
I love building demos for our training classes because I’m constantly in a battle of the minds with SQL Server. I try to guess what he’s going to do next, and I love it when he surprises me. I started by building a new parameter sniffing de …
When a Service Pack or Cumulative Update Install Fails by Evaporating
Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.
Best practices for SQL Provision
In order to get the best out of SQL Provision, it’s a good idea to think about how it would best fit into your workflows and network architecture. We’ve put together a set of guidelines which can help you to optimize efficiency, performance …
How to Linux for SQL Server DBAs — Part 3
The series so far: How to Linux for SQL Server DBAs — Part 1 How to Linux for SQL Server DBAs — Part 2 How to Linux for SQL Server DBAs — Part 3 As you jump into Part 3, you’ll begin to realize how involved your education will b …
SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components
I was trying to install SQL Server 2017 on my latest formatted machine and was stuck at below screen which says – Offline Installation of Microsoft Machine Learning Server Components. In this blog, we would learn about how to move forward in the …
Azure SQL DB is Slow: Do I Need to Buy More DTUs?
You’ve got an Azure SQL DB, and your queries are going slow. You’re wondering, “Am I hitting the performance limits? Is Microsoft throttling my queries?” There’s an easy way to check: run sp_BlitzFirst. sp_BlitzFirst is ou …
Write more compact SQL Server code using new features
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP… IF EXISTS.