Saving your requests
The other day a friend of mine mentioned that they were questioned on one of the scripts they ran recently ... Continue reading
2022-03-03
6 reads
Blog Posts
Using curl to Automate Multipage Logins
Watch this week's video on YouTube
I like solving the daily New York Times crossword on paper. However, logging in to download the PDF every day and printing it is...
2022-03-03
4 reads
Using curl to Automate Multipage Logins
Watch this week's video on YouTube
I like solving the daily New York Times crossword on paper. However, logging in to download the PDF every day and printing it is...
2022-03-03
Architecture – Commonality is an accelerator
In IT, commonality is an accelerator. When I say commonality, I mean commonality of: Components, like libraries Object models Interface definitions Tools Let me give you an example. Imagine...
2022-03-02
148 reads
Azure Synapse and Delta Lake
Many companies are seeing the value in collecting data to help them make better business decisions. When building a solution in Azure to collect the data, nearly everyone is...
2022-03-02
432 reads
Daily Coping 2 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-02
9 reads
Data Analysis Techniques
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-02
99 reads
Don’t change your default SQL Server port for security reasons
Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security...
2022-03-02
215 reads
Extended Events Session Properties
I like Extended Events and I regularly use the Session Properties window to create and explore sessions. I’m in the window all the time, noting it’s quirks & odd...
2022-03-02 (first published: 2022-02-15)
216 reads
Recipe 8: Analyzing a Workload
Welcome to a new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-03-02
138 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...