Pluralsight Course – Open Source Cloud: Executive Briefing
Earlier last month, I had written about Open Source Cloud technology and I got lots of positive response to the series. Lots of people thought the series explained the concept of the open-source cloud in very and simple words. I really appreciate the f …
Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware
Introduction We are now in the data era – data is growing at rapid space, being processed in different ways, and becoming more distributed across data centers and clouds. Thus databases are also growing and they are stored and protected in variou …
How to Get Rowcount of Every Table in SSMS? – Interview Question of the Week #288
Question: How to Get Rowcount of Every Table in SSMS?Answer: After watching my earlier video on the fastest way to get the rowcount for the table, I got lots of questions from the user, if there is a way to list rowcount for every single table in SQL S …
Alter Index Add Column – Workaround – SQL in Sixty Seconds #097
During the recent Comprehensive Database Performance Health Check, I identified at my client’s place that we needed to modify one of the indexes and add a couple of additional columns to improve its performance. However, while modifying it we fac …
SQL Server Cumulative Update Documentation Is Going Downhill, Fast
Microsoft appears to have given up on patch documentation, and that’s kinda scary for a product that costs thousands of dollars per core. Yesterday’s SQL Server 2019 Cumulative Update 6 launched with the worst documentation I’ve seen …
Fastest Way to Retrieve Rowcount for a Table – SQL in Sixty Seconds #096
Whenever I am helping my clients with their SQL Server Performance Comprehensive Database Performance Health Check, every single time I get this question. What is the fastest way to retrieve rowcount for a table? Performance issues most of the tim …
Gathering SQL Server Performance Counters for Multiple Servers
The post Gathering SQL Server Performance Counters for Multiple Servers appeared first on SQLServerCentral.
Getting Started with Azure DevOps
The post Getting Started with Azure DevOps appeared first on SQLServerCentral.
Where are Table Variables Stored? – SQL in Sixty Seconds #095
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted few videos on my YouTube Channel about SQL Server performance Tuning and I have received an email from my client of Comprehensive Database Perfor …
Basic Git for DBAs: What’s a Pull Request?
This is the sixth article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git Basic Git for DBAs: Sharing Files Through GitHub Basic Git for DBAs: the Basics of Branches Basic Git f …
SQL Server Problems We Don’t Have Anymore
We have completely new problems today. I was cleaning out a folder of presentations and I realized there are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today. Virtual Log Files (VLFs) – it …
Quantum Computing With an Example of Coin – SQL in Sixty Seconds #094
Quantum Computing is the next wave in computing and it is very different from traditional computing. Lots of people often ask me what is Quantum Computing. I decided to build a short video based on Quantum Computing with an example of a coin. I use the …
Unboxing SQL Toolbelt: What is SQL Multi Script for?
The post Unboxing SQL Toolbelt: What is SQL Multi Script for? appeared first on SQLServerCentral.
Clarifying Data Warehouse Design with Historical Dimensions
We owe a lot to Ralph Kimball and friends. His practical warehouse design and conformed-dimension bus architecture are the industry standard. Business users can understand and query these warehouses directly and gain valuable insights into the business …
Date Tables are Great for Users, but Not So Great for Performance
Date tables help users filter data based on day of week, holiday, this year vs last year, and other kinds of filters that business users usually wanna add to their reports. If you haven’t used a date table before, here are a couple of primers on …