(Pinal Dave) SQL Server fundamentals can never get old. Just the other day, while working with a client on Comprehensive Database Performance Health Check, the DBA asked me an interesting question referring to my older blog post How to Know If Index is Forced on Query?.
Tag: sql server
SQL Server Loop through Table Rows without Cursor
(Daniel Farina) You have always heard that you should avoid cursors in your T-SQL code as a SQL Server best practice, because cursors are detrimental to performance and sometimes cause issues.
SQL SERVER – Modifying Table Used In SCHEMABINDING View
(Pinal Dave) While I enjoy working on the Comprehensive Database Performance Health Check, I often love answering the question about blog posts as well. Just earlier I posted about What is SCHEMABINDING in SQL Server Views? and I received a very interesting question from the user.
Implementing SQL Server Integration Services with Azure Data Factory
(Marcin Policht) In a recent article I introduced a cloud-based approach to Extraction, Transformation, and Loading (ETL) that relies on SQL Server Integration Services (SSIS) runtime of Azure Data Factory.
Azure Storage Accounts – Open to the Internet?
(blobeater) Let’s get straight to the point. From official documentation it states that “To secure your storage account, you should first configure a rule to deny access to traffic from all networks (including internet traffic) by default.
Sort Alphanumeric Values in SQL Server
(Jeffrey Yao) In my work I sometimes need to import csv files and one column of the csv file is an alphanumeric string, with values like the following:
How To Create A Login In SQL Server
( Satya Ramesh) In this video, you will learn how to create a SQL Server login.
What is skip-2? What is means to you? And what is compromised to make this happen?
(Denny Cherry) Skip-2 is the name of a software package that lets what appears to be state sponsored hackers attack your SQL Server data and download, change or delete data without the auditing that you have configured being triggered.
SQL SERVER – Identifying and Fixing PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type
(Pinal Dave) While we say that every day is the learning opportunity is truly correct if you get to work with the new clients every single day Comprehensive Database Performance Health Check. Recently, I walked into a client engagement where I really got stuck with a very interesting scenario with a
How to Create a Pareto Chart in Power BI Desktop
(Koen Verbeeck) I’m trying to create a chart in Power BI Desktop that shows me the employees that contribute the most to the overall sick days of the company. I’m struggling with the DAX formulas needed to create the measures. How can I solve this?