Poll Results: Yep, Developers are Using Unmasked Production Data.
Earlier this week, I asked where your developers are getting their development databases from. The poll results are in: 9% of development happens on the production database server 57% are copying the production data to another server, and using it as-i …
SQL SERVER – DBCC CLONEDATABASE Error – Msg 2601: Cannot Insert Duplicate Key Row in Object ‘sys.sysowners’ With Unique Index ‘nc1’.
A few days ago, I wrote a blog about an error while creating a clone of a database using DBCC CLONEDATABASE command. Here is the link to read that blog. SQL SERVER – DBCC CLONEDATABASE Error: Cannot Insert Duplicate Key Row In Object ‘sys.s …
How to read the SQL Server Database Transaction Log
The post How to read the SQL Server Database Transaction Log appeared first on SQLServerCentral.
How to Pitch a Software Development Initiative and Ignite Culture Change
The post How to Pitch a Software Development Initiative and Ignite Culture Change appeared first on SQLServerCentral.
SQL SERVER – DBCC CLONEDATABASE Error: Cannot Insert Duplicate Key Row In Object ‘sys.sysschobjs’ With Unique Index ‘clst’.
This is one of the features which I wanted to demonstrate to my clients while delivering my service Comprehensive Database Performance Health Check. So, while preparing for a demo I encountered a strange error. In this blog we would learn about fixing …
Introduction to DevOps: The Evolving World of Application Delivery
The post Introduction to DevOps: The Evolving World of Application Delivery appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for July 2019
Nothing too dramatic, mostly bug fixes this month. Been pretty quiet on the development front the last couple of months. Some stability is nice around here, eh? To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users …
Impact of CHECKPOINT On Memory – SQL in Sixty Seconds #084
Some concepts are so good in SQL Server, they keep on coming back to me one way or another way. After reading my recent blog posts about CHECKPOINTS lots of people wanted to see the demonstration of the same. In this SQL in Sixty Seconds video, I will …
How to Provision a Set of Databases to Multiple Azure-based Servers
The post How to Provision a Set of Databases to Multiple Azure-based Servers appeared first on SQLServerCentral.
Yet Another Way Missing Index Requests are Misleading
Graduates of my Mastering Index Tuning class will already be familiar with the handful of ways the missing index DMVs and plan suggestions are just utterly insane. Let’s add another oddity to the mix: the usage counts aren’t necessarily cor …
SQL Server Performance Tuning Practical Workshop – Discovery Phase – Online Training
Performance tuning is not as difficult as it once used to be but the challenge is the methodology of the performance tuning has changed quite a lot but many of the traditional training has so many limitations that I had went on my own journey to find t …
Database Delivery with Docker and SQL Change Automation
The post Database Delivery with Docker and SQL Change Automation appeared first on SQLServerCentral.
Filtering Object Explorer Detailed Information in SSMS
The post Filtering Object Explorer Detailed Information in SSMS appeared first on SQLServerCentral.
A Step by Step Guide to the Availability Group (AG) Listener
Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases i …
Poll: what’s in your development database?
When the developers at your company are working on building an app, where do they work? Production, a development database restored from production, or a development database with made-up contents? One-question poll, and you can watch the live results. …