Choosing Snowflake vs SQL Server for a Data Warehouse
In this article we take a high level view of choosing to use Snowflake in the cloud versus SQL Server on-premises and some things to consider.
2022-03-28
Additional Articles
DevOps 101: Getting buy-in across your organization
Implementing DevOps isn’t just a matter of being great at writing code. The key to successful DevOps implementation is gaining buy in across your organization. Join Grant Fritchey live for his tips on how to achieve this.
2022-03-28
The problem with averages
Everyone learns to calculate an average in school, but, as Joe Celko shows, there are better ways to summarize data.
2022-03-25
Why you don’t just buy tools to make DevOps happen
Matt Gordan is next in the hot seat. We discuss how Matt keeps the lights on while overseeing many data related projects and how his team know the more they are plugged into projects, the better support the can offer.
2022-03-25
How to get DevOps buy-in across your organization
In our latest DevOps 101 Series live webinar Grant Fritchey discusses why the key to successful DevOps implementation is gaining buy-in, and how you can achieve this in your organization.
2022-03-23
What is Change Management?
Change manage is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change management.
2022-03-23
Think you know SQL Monitor? Think again.
You spoke 📣 we listened 👂
We are dedicated to listening to what our customers want and need and implementing feedback accordingly. Learn about how SQL Monitor has evolved, and the key features we've added, since 2018.
2022-03-21
Working with MySQL tables
After getting a new database in place, the next step is to create tables. In this article, Robert Sheldon walks you through creating tables with SQL Workbench and with scripts.
2022-03-21
Bulk Formatting of the SQL Server SQL Files
In this article, Phil Factor explains how to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch.
2022-03-18
The effects of NULL with NOT IN on Oracle transformations
IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN and NOT IN.
2022-03-18
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers