Building CI/CD process for Azure Data Factory is not quite straightforward. Furthermore, there are a few different methods of doing that. Before we begin doing that, we must set...
2020-03-14
14 reads
Building CI/CD process for Azure Data Factory is not quite straightforward. Furthermore, there are a few different methods of doing that. Before we begin doing that, we must set...
2020-03-14
3 reads
In this article, our focus will be to test, the performance benefits of columnstore indexes, on a transactional (OLTP) workload, for real-time analytics.
We'll cover examples from each of...
2020-03-14
15 reads
After my post last month about configuring your tools I’ve been on a make my life easier kick and one ... Continue reading
2020-03-13 (first published: 2020-03-04)
2,686 reads
Note: This post is based on an editorial I originally published over at SQL Server Central Years ago, I worked on a fabulous team of eight database administrators We...
2020-03-13
13 reads
Yesterday I wrote about three upcoming webinars I’m giving, which you don’t need to be in attendance for. Unfortunately, the one scheduled for next week with Idera and BankDirector...
2020-03-13
17 reads
This month is Women’s History Month, and it’s a chance to stop and think about the impact that women have had in history. After reading Monica Rathbun’s post on...
2020-03-13 (first published: 2020-03-03)
155 reads
The default collation for SQL Server is a pretty bad idea. Sure, it works but so does SQL Server 7. When you have the opportunity to update to more...
2020-03-12
167 reads
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do...
2020-03-12 (first published: 2020-03-04)
732 reads
In a previous blog post, I showed you how to use WorkloadTools to replay a workload in two different scenarios. However, there is a third scenario that is worth...
2020-03-12 (first published: 2020-03-03)
327 reads
I’m excited to announce the release of a new open-source project that fully automates...
I’m excited to announce the release of a new open-source project that fully automates...
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
Hi everyone I have a SP which compares two tables and outputs mismatching entries:...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers