Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

In Memory OLTP – 1

In-Memory OLTP  (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL Server.

Microsoft designed In-Memory OLTP to handle the most demanding OLTP workloads. To accomplish this, In-Memory OLTP introduces two fundamentally new concepts: memory-optimized tables and natively compiled stored procedures.

Data… Read more

0 comments, 26 reads

Posted in SQLSERVERS’dba on 6 December 2016

sp_WhatsupQueryStore version 1.1 released

Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are stored inside the SQL Server Query Store through an easy to use stored procedure.

In version 1.1 many new optional parameters are added that influence the output of the stored… Read more

0 comments, 27 reads

Posted in DotNine SQL Server and more on 6 December 2016

Checking your Wait Stats via Power BI

Wait stats is my go to thing, however I do get bored just querying it via a  table so I decided to broaden my horizons and see how “analytical” I could get with it via Power BI. What I usually … Continue reading

Read more

1 comments, 177 reads

Posted in All About SQL on 6 December 2016

December: A two-line play.

“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life balance,” she replied, glancing furtively at her sparsely populated blog. Fin   (P.S. The latest blog on MinionWare.net, at least, is What Really Causes Performance Problems?)  

The post December:… Read more

0 comments, 169 reads

Posted in SQL Awesomesauce on 5 December 2016

Presentations for SQL Server Beginners

Tired from all those blog posts

For my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a set of presentations from the PASS Virtual Chapters. This content is available online. It’s free. Most importantly for the person just getting started as a SQL Server data pro,… Read more

1 comments, 90 reads

Posted in The Scary DBA on 5 December 2016

Optimize For Unknown

Hello Dear Reader!  It's been a while.  I was working with a friend and we came across an interesting problem.  They had a large amount of skewness/data skew.  This led to some performance issues for them.  The way this manifested itself was in a set of queries that ran quickly,…

Read more

0 comments, 79 reads

Posted in SQLBalls on 5 December 2016

On Being Disruptive

Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just in business offices but in the homes of regular joes, and built businesses around a need that had not fully manifested itself. Twitter disrupted the social media space by bringing… Read more

0 comments, 82 reads

Posted in Tim Mitchell on 5 December 2016

Multivariate Variable Analysis using R

So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a sort of a summary – about various techniques we can use for such datasets, depending on the type of variable in question. The techniques include – how to get summary… Read more

0 comments, 72 reads

Posted in Mala's Data Blog on 5 December 2016

Monday Coffee 2016-12-05

You are the DBA your company makes you. Aren’t you?

SQL Server has such a wide range of features that no DBA role will implement all of them. So, you use a certain subset in each role that you occupy throughout your career. What those features are depends on the… Read more

0 comments, 74 reads

Posted in The DBA Who Came In From The Cold on 5 December 2016

Migrating reports between SSRS report servers simplified with new PowerShell commands

I recently needed to replicate all of the reports on one report server to a different server.  I started downloading each report one at a time to a file system folder, moving them to the other machine and then uploading each RDL file.  Needless to say, that’s a slow and…

Read more

0 comments, 90 reads

Posted in SQL Server BI Blog on 4 December 2016

Find my git remote

I work on a few projects and have a bunch of demos setup, but I don’t work on them all every week. Being only semi-creative like many of you, I end up with some similar projects with similar names. When I wanted to determine which project was linked to which… Read more

0 comments, 137 reads

Posted in The Voice of the DBA on 4 December 2016

Data Channel - Interview 01 - Andreas Wolter on Columnstore

Dear all,

Welcome to the first ever interview of DataChannel. I am honored to have Mr.Andreas Wolter, a German MVP, MCM, MCSM for the first interview. Detailed profile of Andreas provided below.

Andreas Wolter has over 16 years of experience with SQL Server and earned the Master-Certification both on SQL Server…

Read more

0 comments, 116 reads

Posted in SQL and SQL Only on 3 December 2016


Error:  The server principal "IncidentManagement" is not able to access the database "DatabaseName" under the current security context.
for conection string: "Data Source=SBCAPPDEV1.curvature.com;Initial Catalog=DatabaseName ;User Id=IncidentManagement ;Password=wuwaye6U5+uz;" providerName="System.Data.SqlClient"


Fix: This error you receive when the service account using from .net application doesn’t have sufficient permissions to access the…

Read more

0 comments, 0 reads

Posted in SQL Articles by Nani on 2 December 2016

Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)



Issue: I see this issue when I try to expand the databases and any other things in object explorer of secondary replica of AlwaysOn SQL instance. I have seen few blogs which suggests to see sp_who2 results and kill blocking. Unfortunately this is  read only database and no user connections…

Read more

0 comments, 222 reads

Posted in SQL Articles by Nani on 2 December 2016

Adding database back to Always On High Availability Group

            
Summary: If databases in secondary replica are out of sync with primary then below is the workaround which helps to fix.

1)      At very first take the database out of Always on availability group on primary replica by right click on the…

Read more

0 comments, 105 reads

Posted in SQL Articles by Nani on 2 December 2016

VIEW SERVER STATE permission was denied on object 'server', database 'master'. (Microsoft SQL Server, Error: 300)

Issue: I had to create few users for the first time and give access to execute views from user database. I have created logins for them and gated access to select from views and tables at object level but see below error when they select from views.

Error:

TITLE: Microsoft…

Read more

1 comments, 215 reads

Posted in SQL Articles by Nani on 2 December 2016

Moving Tasks with Copy-SqlJob

More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this post, I want to look at Copy-SqlJob, which will allow me to easily move jobs from one instance to another.

The Job Subsystem

Jobs in SQL Server are part… Read more

0 comments, 156 reads

Posted in The Voice of the DBA on 2 December 2016

SSIS Naming Conventions 2.0

People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and… Read more

3 comments, 125 reads

Posted in Koen Verbeeck on 2 December 2016

Friday Reading 2016-12-02

Another week almost over so here’s a random selection of articles that I’ve been reading…

Changing the SQL Server port on Linux
Denis Gobo goes through the process of changing the port that an instance of SQL Server running on Linux is listening on

Reload a table quickly
Kenneth Fisher… Read more

0 comments, 98 reads

Posted in The DBA Who Came In From The Cold on 2 December 2016

I use Elastic database pools – for now

When you have many SQL databases that are required to run your environments and  they show signs of specific usage patterns and some of the databases requires different performance levels then how can you ensure that the all the databases … Continue reading

Read more

1 comments, 275 reads

Posted in All About SQL on 2 December 2016

Older posts