(Kenneth Fisher) I’ll admit, I’m a lot more comfortable with tracing and the profiler than I am with EE (extended events) and the viewer. It’s something I really want to get past but haven’t yet.
Tag: sql server
(Alejandro Cobar) If your manager or a colleague asked you:
(Pinal Dave) A few days ago, I wrote a blog about the issue with the SQL Server upgrade where issue was due to Reporting Services installation in a bad state. Here is the link for that blog. SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service.
(Mohammed Moinudheen) I have a number of Azure SQL Server resources to manage. My manager has asked me if it is possible to categorize the Azure resources based on the various departments within the company and also to consolidate the resource billing information by department within the organizatio
(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?.
(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.
(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.
(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.
(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.
(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: