SSRS is Still Around
The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI is the premier MS reporting and dashboarding tool. It seems like more organizations are finding fewer reasons to use SSRS due to the e …
How to Think Like the Engine: Index Column Order Matters a LOT.
We’ve been working with the clustered index of the Users table, which is on the Identity column – starts at 1 and goes up to a bajillion: And in a recent episode, we added a wider nonclustered index on LastAccessDate, Id, DisplayName, and A …
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 …