SQL SERVER – Improving Deployment Performance by SQL Server Monitoring
Why do organizations keep their entire team ready and available when any new deployment is about to happen? Well, the answer is pretty simple: there are many different variables that can go wrong when the new deployment happens. As a performance tuning …
Redgate’s journey to DevOps
The post Redgate’s journey to DevOps appeared first on SQLServerCentral.
SQL Server Function to Measure CPU Usage Per Database
The post SQL Server Function to Measure CPU Usage Per Database appeared first on SQLServerCentral.
New Pluralsight course: SQL Server: Using SentryOne Plan Explorer
Jonathan’s latest Pluralsight course has been published: SQL Server: Using SentryOne Plan Explorer. It’s almost 3 hours long, and from the course description: Query plan analysis is both a science and an art, and the best too …
Writing Diagnostic Queries is Hard Because SQL Server Still Has (Tiny) Bugs.
When I first got started working with SQL Server, I assumed it was flawless because it came in a sealed box from a ginormous corporation. I figured they’d tested every edge case, and that there was no way things were gonna go sideways. These days …
Guest Posts Invitation and Popular Award
I often get a request for the guest posts and I usually deny them as the purpose of this blog is to share what I am learning every day. However, whenever I travel to various conferences, lots of people share lots of ideas with me which they would love …
SQL Prompt 10: What’s New?
The post SQL Prompt 10: What’s New? appeared first on SQLServerCentral.
Understanding Outer Joins in SQL
Most of the time developers that need to get data will use a SELECT statement to retrieve the data. The query that a developer will use often will use a join between tables. In this article, we will look at how an outer join is different from an inner …
Associating Data Directly with SQL Server Database Objects.
The post Associating Data Directly with SQL Server Database Objects. appeared first on SQLServerCentral.
Announcing Weekend Versions of My Mastering Classes
Last week, I noticed that an awful lot of you were buying my Level 2 and Level 3 Bundles with your own personal money (not company cards), so I wondered – if your company wasn’t paying for it, were they giving you time off? So I polled to a …
SQL SERVER – Simple Example of Batch Mode in RowStore
One of the reasons, I love my job is that I get to work with the latest technology and also get to speed up the client’s computer. Recently one of my clients upgraded their SQL Server to the latest version SQL Server 2019. After the upgrade, they …
Using Custom Deployment Scripts with SQL Compare or SQL Change Automation
The post Using Custom Deployment Scripts with SQL Compare or SQL Change Automation appeared first on SQLServerCentral.
Collections
Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of in …
Merging tables in Power BI dataflows with PRO subscription
The post Merging tables in Power BI dataflows with PRO subscription appeared first on SQLServerCentral.
Glenn’s Tech Insights For November 17, 2019
(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …