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

Archives: December 2016

2016 – A Year to remember

2016 has undoubtedly been a landmark year in my life. To me it marked my first conscious entry into mid age. It was the first year that I really pondered some of the questions that people need to think of as they get older in life – with clarity that… Read more

0 comments, 776 reads

Posted in Mala's Data Blog on 31 December 2016

VLDB very large database DBCC checkDB


Database corruption – DBCC checkDB for Very large database

We know SQL server data is stored in a filesystem storage. There has been always an (I/O) input and output interaction between SQL server and storage subsystem both in the memory and disk. IO subsystem plays a major role, 99%… Read more

2 comments, 2,930 reads

Posted in SQL Server Blog Forum on 31 December 2016

Data Channel - Interview 02 - Hamid Fard on SQL Server Memory Capacity Planning

Dear All,

Welcome to the second interview of Data Channel. Very happy and proud to have Mr Hamid Fard, MVP and MCM from Malaysia for Data Channel. Hamid discusses SQL Server Memory Capacity Planning on Data Channel. Discussion covers topics like SQL Server Memory sizing, AWE, Plan Cache, In Memory…

Read more

5 comments, 1,681 reads

Posted in SQL and SQL Only on 31 December 2016

Performance-Oriented SQL Server Development – The Scripts

Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.

It was a great experience, and I’d like to thank everyone who attended.

The scripts from the seminar can be downloaded from here.



The post Performance-Oriented SQL Server Development –… Read more

0 comments, 863 reads

Posted in Matan Yungman on 30 December 2016

Finding Automatic Soft-NUMA

If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL 2016 – It Just Runs Faster: Automatic Soft NUMA by Robert Dorr, who makes up one half of “the Bobs” that run the BobSQL blog. The other Bob, Bob Ward…

Read more

Query tuning 101: Non-trusted Foreign Keys

Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating joins, and sometimes slow down DML operations (inserts, updates, and deletes).

For this post I want to focus on what a non-trusted FK or constraint is. By it’s definition, SQL… Read more

4 comments, 3,313 reads

Posted in Confessions of a Microsoft Addict on 30 December 2016

Off topic: The two cycle engine and your career path

I’ve been in technology for twenty years now. I’ve seen hundreds of environments, nearly 300 while employed at Microsoft alone.

One thing that I’ll always remember is my first day at Microsoft and not because I found out that health care was 100% free; though, that was a pleasant shocker.… Read more

0 comments, 750 reads

Posted in Confessions of a Microsoft Addict on 30 December 2016

Comparing plan consistency and query performance using the Query Store Replay script

The 1.2 version of the Query Store Replay script a number of new features are added that return information of the query behavior on the target server. More specifically, in version 1.2 you are able to compare execution plans and query runtime statistics between replay executions on the source and… Read more

2 comments, 1,931 reads

Posted in DotNine SQL Server and more on 30 December 2016

Checking Permissions for Keys–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I got a call from someone wanted to check how permissions were stored for encryption objects. I ran a quick double check for them and decided to… Read more

0 comments, 1,799 reads

Posted in The Voice of the DBA on 29 December 2016

Power BI Custom Visuals Class (Module 31 – Horizontal Funnel)

In this module you will learn how to use the Horizontal Funnel Power BI Custom Visual.  The Horizontal Funnel functions somewhat similar to the traditional funnel but it allows you to display a secondary measure and has a few more customizations than you would normally get. You’ll find that the… Read more

0 comments, 2,128 reads

Posted in Devin Knight on 29 December 2016

Looking Back At 2016

When this blog started back in 2011 I had no idea that it would continue to grow to where it has gotten to today. There have been many learning curves along the way – some fun and some not so fun, but that is part of the journey.

Each year… Read more

0 comments, 645 reads

Posted in The SQL Professor on 29 December 2016

Power BI Custom Visuals Class (Module 32 – Percentile Chart)

In this module you will learn how to use the Percentile Chart Power BI Custom Visual.  The Percentile Chart is used to show a distribution of values over a range. This helps you answer questions like “What percentage of my customers bought 4 or more items”.

Module 32 – Percentile…

Read more

0 comments, 2,024 reads

Posted in Devin Knight on 29 December 2016

How we can determine table column dependencies within a SQL database?

I came a situation during some analysis where i had to figure out all dependency of a column across database. This also required when we do some changes on table columns and wanted to know the impact of such changes. One way is that  we can use SYSCOMMENTS table.  It is…

Read more

0 comments, 1,058 reads

Posted in TSQL Circle Live on 29 December 2016

Windows Virtual Accounts and SQL Server

How SQL Server uses Windows Virtual Accounts and local groups

Managed Service Accounts (MSAs) and Virtual Accounts were introduced in Windows 7 / Windows 2008R2 (link). Installations of SQL Server 2012 and newer will utilize the Virtual Accounts. SQL Server 2008 / 2008R2 installations use a combination of… Read more

1 comments, 1,187 reads

Posted in A Discussion of SQL Server-Related Topics on 28 December 2016

Post TDE–Getting Unencrypted Backups

I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup. This doesn’t seem like that should be an issue, but it can be. A little testing shows how.

Let’s assume I have an encrypted TDE database. If I run a… Read more

2 comments, 2,078 reads

Posted in The Voice of the DBA on 28 December 2016

Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”)

Continuation from the previous 92 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

Given that currently the Batch Execution Mode is an exclusive feature of the Columnstore Indexes, and that the new developments in the query optimisation area are mainly targeting In-Memory & Columnstore Features, in SQL Server… Read more

0 comments, 928 reads

Posted in Niko's blog on 28 December 2016

sp_refreshsqlmodule_internal – The user does not have permission to perform this action.

Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found it somewhat unclear. Here is a quick walk through to produce the error:

-- Create server principal.
-- Create a database principal…

Read more

0 comments, 1,330 reads

Posted in SQLStudies on 28 December 2016

ETL Error Handling

In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should this process do?” Defining the data start and end points, transformations, filtering, and other steps must be done before any other work can proceed. The second question that must be… Read more

3 comments, 728 reads

Posted in Tim Mitchell on 28 December 2016

DBA Resolutions

It’s said that “promises are made to be broken”. Surely database administrators don’t fall in that category? It’s that time of the year to keep up with the tradition and pledge to make some improvements.

In this day and age, it’s absolutely vital to move at the same pace… Read more

0 comments, 635 reads

Posted in SQLYSE with Pankaj Manek on 28 December 2016

Using Memory Optimized tables for reporting

I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin Bacon” style. This means that each unique account may tie to another account on ssn, email, home phone, business phone, or any other PII type metric.

The goal is… Read more

0 comments, 1,227 reads

Posted in Confessions of a Microsoft Addict on 27 December 2016

Older posts