SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: August 2018

Do you even PowerShell, bro? An ode to dbatools and dbachecks.

Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose hours of work. And I mean, SSMS doesn’t run from the command line. Sometimes I get those line-endings errors, Not to mention IntelliSense bombing out; And figuring out which tab… Read more

0 comments, 86 reads

Posted in Born SQL with Randolph West on 15 August 2018

What’s new in SQL Server 2017

SQL Server 2017 is considered a major release in the history of the SQL Server life cycle for various reasons. From my personal point of view, SQL Server 2017 is indeed an interesting release. After writing a lot about it … Continue reading

Read more

0 comments, 95 reads

Posted in PowerSQL By Prashanth Jayaram on 15 August 2018

Rant: There Is No NoSQL Data Storage Engine

Do I need relational or NoSQL? How does NoSQL help me scale? Will I get paid better with NoSQL or relational? Does NoSQL make my butt look big? OK, maybe I made up that last one. However, the others are all variations of questions I’ve been seeing a lot of… Read more

0 comments, 101 reads

Posted in The Scary DBA on 15 August 2018

Async Network IO SQL Wait

Over the last few days we have been tracking down the cause of some really high async network IO waits.  In order to fix this problem we have to understand the wait and what it is telling us, so that is where we begin.

Async Network IO in my experience… Read more

0 comments, 49 reads

Posted in vitamindba on 15 August 2018

AlwaysOn Data Synchronization in Synchronous and Asynchronous Mode

When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This blog will walk you through how a synchronous and Asynchronous commit process works in AlwaysOn.

Data Synchronization in Synchronous mode 

  • Primary replica is generating transaction log blocks. The secondary replica…

Read more

0 comments, 91 reads

Posted in SQL Geek on 15 August 2018

Learn PowerShell in Oklahoma, August 24!

SQL Saturday Oklahoma City is coming up RIGHT SOON, on August 25. The day before SQL Saturday OKC - August 24 - we're teaching our one day Beginning PowerShell class! Buy your tickets TODAY.

The post Learn PowerShell in Oklahoma, August 24! appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 79 reads

Posted in SQL Awesomesauce on 14 August 2018

Power BI Monthly Digest – August 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our August 2018 edition we highlighted the following features:

  • Bookmark groups
  • Export to PDF
  • Slicer restatement
  • Themes…

Read more

0 comments, 127 reads

Posted in Devin Knight on 14 August 2018

Power BI Custom Visuals Class (Module 115 – Circle KPI Gauge)

In this module you will learn how to use the Circle KPI Gauge. The Circle KPI Gauge displays a single measure value in a highly customizable circular gauge visual.

Module 115 – Circle KPI Gauge


Read more

0 comments, 108 reads

Posted in Devin Knight on 14 August 2018

Hitting the Wall – #TSQL2sDay

Photo by Farrel Nobel on Unsplash

Welcome to another edition of T-SQL Tuesday!

This T-SQL Tuesday is hosted by Wayne Sheffield ( blog | twitter ) and he has asked us to talk about

[…] a time when you ran up against your own brick wall, and how you worked…

Read more

0 comments, 74 reads

Posted in SQL DBA With A Beard on 14 August 2018

Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104

Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started by Adam Machanic (b/t). In this case Wayne is asking us to talk about a time when we hit a brick wall Read more

0 comments, 80 reads

Posted in SQLStudies on 14 August 2018

Azure SQL DW – Query Labels

Using a query label in Azure SQL DW (Data Warehouse) can be a really handy technique to track queries via DMVs. You might want to do this to see what problematic queries are doing under the covers. Let’s check out … Continue reading

Read more

1 comments, 134 reads

Posted in All About SQL on 14 August 2018

SQLpassion Online Trainings for Fall 2018

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I’m quite happy to announce my SQLpassion Online Trainings for the remaining year. Currently I have… Read more

0 comments, 93 reads

Posted in Klaus Aschenbrenner on 14 August 2018

6 Techniques For Troubleshooting Your Code

This post is a response to this month’s T-SQL Tuesday #105 prompt by Wayne Sheffield.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional topics every month.

This month’s topic asks to share a time you ran into a metaphorical… Read more

1 comments, 94 reads

Posted in Bert Wagner on 14 August 2018

Another Brick in the Wall–T-SQL Tuesday #105

It’s that time again, and this month we have a good topic from Wayne Sheffield. We’re asked about getting stuck, about being blocked, about encountering a brick wall.

I have to say that I don’t think I encounter these very often, usually because I try to be effective, even… Read more

4 comments, 171 reads

Posted in The Voice of the DBA on 14 August 2018

Cleaning up Query Store data after database restore

Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It will save you a lot of time and effort because it makes the performance troubleshooting easy for DBA’s. It helps you to quickly find performance differences caused by query plan… Read more

0 comments, 114 reads

Posted in DBA Mastery on 13 August 2018

Measuring Query Execution Time: What Is Most Accurate

Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you go about measuring query execution time. SQL Server provides a number of different mechanisms (really, maybe too many) to get this done. However, all measures are not created equally. In… Read more

1 comments, 152 reads

Posted in The Scary DBA on 13 August 2018

The New SQL Provision Dashboard

As much as I liked the ability to quickly and easily build development and test databases with SQL Provision, I thought the dashboard of cloned databases was hideous. It left a lot to be desired, and frankly, the dark theme is annoying to me. Here’s my old dashboard.

I… Read more

0 comments, 184 reads

Posted in The Voice of the DBA on 13 August 2018

Top 5 Reasons You Should Be Excited About Power BI Composite Models

In July there were many exciting new features that were released to Power BI, but perhaps the most eagerly awaited feature was the introduction of the Power BI Composite Models. While this feature is still in preview, it’s hard not to be enthusiastic about how this feature will solve problems… Read more

1 comments, 179 reads

Posted in Devin Knight on 13 August 2018

Fastest Way to Find Row Count of All Tables From All Databases in SQL Server

There are many times you as DBA or Developer needs to get all row count from all tables or row count of all tables from all Databases in a SQL Server. You may need a quick way to count the number of rows contained within the tables. The following SQL… Read more

0 comments, 205 reads

Posted in SQL Geek on 13 August 2018

Warning: Expect Delays

Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper, you creep and crawl along the highway for a couple of hours, wondering what on earth is going on here, until you finally reach the source of the… Read more

0 comments, 98 reads

Posted in The Monday Morning DBA on 12 August 2018

Older posts