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

Latest Blog Posts

Moneyball And The DBA

“Moneyball” has been a thing for a while now. It’s shorthand for the application of quantitative data analysis to the various aspects of a sport, from individual player stats to how the team’s members are arrayed on the field. Many – including many current and former players – lament that… Read more

0 comments, 105 reads

Posted in The Monday Morning DBA on 17 August 2018

Format a Partial Script with #SQLPrompt

SQL Prompt is amazing and it’s my favorite tool. It’s actually what many people want first from Redgate because it makes coding much easier. One of the most used features is the reformat feature (CTRL+K,Y), since formatting really matters to developers.

One of the neat features of SQL Prompt is… Read more

0 comments, 132 reads

Posted in The Voice of the DBA on 17 August 2018

Performance Basics: Indexed views

Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has a drawback, the views just store our query definition, but the performance is not improved by using them.

Since SQL Server 2008, the option to create an index over a…

Read more

0 comments, 59 reads

Posted in SQL Guatemala on 17 August 2018

Generic error: ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'

Error: Generic error:  ExpressionChangedAfterItHasBeenCheckedError: Expression has changed after it was checked. Previous value: 'isLoading: [object Object]'. Current value: 'isLoading: true'

Resolution:

setTimeout the code that is setting the value. In my case, it was ngRX store dispatch action so I have changed action like below.

It was like below =>

Read more

0 comments, 68 reads

Posted in Querying Microsoft SQL Server on 17 August 2018

Announcing new Guatemala SQL Server user group



I am very happy to announce that after a long time struggling and filling all the requirements, we were able to create the SQL Server local user group for Guatemala.

The purpose of creating this group was to empower the local database administrators and developers by creating a community where…

Read more

0 comments, 107 reads

Posted in SQL Guatemala on 16 August 2018

What are my permissions?

Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z permissions. And all too often the conversation goes like this:

Dev: I need write permission to this database.
Me: Ok.
Me: Checks their current permissions.
Me: You already have that… Read more

0 comments, 102 reads

Posted in SQLStudies on 16 August 2018

Using the PowerShell AST to find a ForEach Method

In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including the ‘type’ of check. This refers to the configuration item or parameter that is required to have a value for this check to run.

For example – Any check… Read more

0 comments, 113 reads

Posted in SQL DBA With A Beard on 16 August 2018

SQL Reserved vCores

Have you ever heard of SQL Reserved vCores? Well I never until recently.  With this concept you have the ability to save money by PRE-PAYING for your compute resources for Azure SQL DB where you might be currently using a … Continue reading

Read more

0 comments, 129 reads

Posted in All About SQL on 16 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, 138 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, 144 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

6 comments, 134 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, 99 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, 116 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, 95 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, 193 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

Downloads

Read more

0 comments, 170 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, 88 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, 98 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, 152 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, 115 reads

Posted in Klaus Aschenbrenner on 14 August 2018

Older posts