Archives: December 2016
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
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% of… Read more
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…
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.
1 comments, 1,253 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 30 December 2016
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
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
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
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
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
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
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…
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
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
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
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 LOGIN SQLTest WITH PASSWORD = 'SQLTest'; GO -- Create a database principal…
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
In this day and age, it’s absolutely vital to move at the same pace as the database systems.
But how do DBAs reduce time spent on the daily chores to allow them to progress and be more productive?
Here are 5 important tips I’ve mentioned to work smarter and beat… Read more
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