SQL Homework – April 2020 – Continuity planning.
Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world ... Continue reading
2020-04-01
5 reads
Blog Posts
SQLpassion Online Training in April
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-04-01
SQLpassion Online Training in April
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-04-01
20 reads
Transforming JSON to CSV with the help of Flatten task in Azure Data Factory - Part 2 (Wrangling data flows)
(2020-Mar-26) There are two ways to create data flows in Azure Data Factory (ADF): regular data flows also known as "Mapping Data Flows" and Power Query based data flows also...
2020-04-01 (first published: 2020-03-26)
1,286 reads
Be Safe, Be Strong and Be Kind…. surviving COVID Lockdown in New Zealand
Currently we have have the COVID-19 pandemic sweeping the world. Here in New Zealand we are currently in lockdown – what this means is that we Kiwis are required...
2020-03-31
93 reads
Daily Coping 31 Mar 2010
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-31
8 reads
DB Automation with Azure DevOps
I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do...
2020-03-31 (first published: 2020-03-25)
448 reads
Goal Progress Report for March 2020
I made goals at the end of February, when I returned from sabbatical. Since then, the world has been turned upside down with a pandemic, and I’ve been struggling...
2020-03-31
6 reads
Moving Your SQL Workload to the Cloud
Every day, more IT organizations decide to move their SQL Server databases to Azure. In fact, over a million on-premises SQL Server databases have been moved to Azure. There’s...
2020-03-31 (first published: 2020-03-25)
377 reads
Speaker at PASS Marathon – 2020
I’m very happy to share that I will be speaking at the next PASS Marathon event. Here are the details of the session I will be presenting on April...
2020-03-31
7 reads
Blogs
Prepping for Certification, Part 1 of ?
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
How to Avoid Knowledge Stagnation
You want the short answer? Well, the only antidote to knowledge stagnation is probably...
Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe
By Chris Yates
It always starts the same way. You open your laptop on a Monday morning,...
Forums
just finished a deep dive into snowflake
Sorry, but you do not have permission to view this content.
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers