(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
Inventory SQL Server Agent Jobs for all Instances with PowerShell
(Alejandro Cobar) If your manager or a colleague asked you:
SQL SERVER – Upgrade Rule Failure Error: No Custom Security Extensions
(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.
Simplify Your Azure Bill by Resource Group
(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
SQL SERVER – Group By Orders Data by Columns Ascending
(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?.
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: