(Douglas Correa) After setting up SQL Server Transactional Replication via scripts, replication didn’t work and showed the following error: “Target principal name is incorrect. Cannot generate SSPI context”. What causes this issue and how do I fix it?

(Robert Sheldon) You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create repor

(Parikshit Savjani) With the release of SQL Server 2016 SP1, a number of programmability features which were only available in Enterprise Edition are now enabled in Standard, Web, Express and LocalDB editions of SQL Server 2016. These features will allow developers and ISVs with consistent programmi

(Pinal Dave) This was one of the interesting issues I solved in many days. One of my clients contacted me and told that they have scheduled a maintenance plan to take t-log backup at 10 PM but it’s not running.

(Ben Snaidero) A lot of the performance issues in SQL Server often relate to slow running queries. In my last tip I showed you a method for finding long running queries using SQL Profiler. What if after you find this long running query you notice that sometimes the query runs quickly, but other tim

(Pinal Dave) Yesterday I started my day early to get to a gym. I know this was the first day and I had loads of work pending to be completed at work too. This got me busy and I started to drive my car, oblivious of the fact that I had to take a turn which I missed.

(Denny Cherry) Moving to the cloud isn’t for everyone. When the cloud providers first launched their cloud platforms their approach, and marketing message, was for the most part that everything should be running in the cloud. And they were pushing that message hard.

(Arun Sirpal) I like row versioning– see this link for more details:

(Pedro Lopes) Today we are starting a new blog post series entitled “Developers Choice”. In the first few posts we will be focusing on SQL Server 2016 SP1 enhancements that focus on the developer community, including all developer DBA’s.

(Kenneth Fisher) You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we care? Starting with simple definitions first: