Customer Satisfaction Survey Results
In the last couple of months, we sent our first customer satisfaction survey to all our customers. We collected the...
2017-11-18
500 reads
Superman
What is the Role of the UPDATE Lock in SQL Server?
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The...
2017-11-18
1,328 reads
Can I pause or resume an index rebuild operation?
One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database)...
2017-11-16
972 reads
Something Cool We Learned Today!
We have many customers, and we work on lots of projects. Each project is different in so many ways: the...
2017-11-16
415 reads
Why I Believe in the Data Architecture Review
We have a solution called Data Architecture Review. With this solution, we conduct a complete review of the customer’s data...
2017-10-31 (first published: 2017-10-23)
2,190 reads
Customer Satisfaction Survey
We decided to create a customer satisfaction survey and send it to all our customers. The goal of this post...
2017-09-01
665 reads
Working with Very Large Tables
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”....
2017-08-14 (first published: 2017-07-26)
4,540 reads
What Do You Do When Performance Sucks?
So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time....
2017-05-16
549 reads
My Session about SQL Server Parameterization
Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the...
2017-05-10
552 reads
Availability Group on SQL Server 2016
The Challenge
One of our clients in the gaming industry wanted to set up a high availability solution in their data...
2017-02-01
2,085 reads
Blogs
A New Word: Feresy
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
Mastering the ORDER BY Clause in SQL Window Functions
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business...
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem, which...
Iterative query to sum a colum relating to dates.
Hi, I have a simple table with 5 columns as follows with about 80,000...
how to force SS to run certain SP in parallel?
hi everyone I have a SP that is run in SSIS. That particular SP...