Create Azure Data Lake Linked Service Using Azure Data Factory
In this article we walk through a step-by-step example on how to create an Azure Data Lake Linked Service in Azure Data Factory v2.
Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours? – SQL Server Performance Tuning
This is the third of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it a …
How to Determine Activity on Each Processor in SQL Server
The contents of the SELECT, WHERE and ORDER BY clauses are all a matter of determining the story you need to tell.
Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS
SQL Server Integration Services (SSIS) provide a broad set of tools for working with data, mostly for ETL scenarios, but you can use it for other tasks, as data movement or monitoring solutions. Packages are stored as .dtsx files, and you use SQL Serve …
What Are You Going to Do About SQL Server 2008?
Last week, you used SQL ConstantCare® to analyze 2,396 SQL Servers across a variety of versions: Alas, poor SQL Server 2008 15% (362 instances) of SQL Server 2008 and 2008 R2 18% (438) SQL Server 2012 27% (650) SQL Server 2014 32% (777) SQL Server …
Creating CRUD Stored Procedures in SQL
Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.
Experiments with full text search
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?
Consulting 102 – Why Do I Give 100% Guarantee of My Service? – SQL Server Performance Tuning
This is the second of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts that are the essence of my consulting business. You can also call it my busi …
What happens when you cancel or kill a resumable index creation?
SQL Server 2019 adds resumable online index creation, and it’s pretty spiffy:CREATE INDEX IX_DisplayName ON dbo.Users(DisplayName) WITH (ONLINE = ON, RESUMABLE = ON, MAX_DURATION = 1); Those parameters mean: ONLINE = ON means you’ve got the …
Getting Comfortable Writing Code in Azure Data Studio
Learn some of the ins and outs of working with Azure Data Studio to develop SQL code.
Consulting 101 – Why Do I Never Take Control of Computers Remotely? – SQL Server Performance Tuning
This is the first of a 5 part series on my 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts that are the essence of my consulting business. You can also call it as my business …
24 Hours of PASS (April 2019): 20 Years of PASS!
The next 24 Hours of PASS will have the opportunity to celebrate the first 20 years of the international association of professionals and data management experts. PASS is the acronym of Professional Association of SQL Server, PASS was established on 19 …
How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217
Question: How Does QUOTED_IDENTIFIER Works in SQL Server? Answer: If you search on the internet, you may find quite lots of notes about it. So in this blog post, I will explain in very simple words. First, let us see the following example where I have …
SQL SERVER – Read Only Routing Error: Client Unable to Establish Connection Because an Error was Encountered During Handshakes Before Login
I have helped many clients in deploying Always On Availability Group. Based on their requirement they keep using additional features provided by availability groups. This time they wanted to use always-on availability group read-only routing feature. T …
SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions
I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.