Snowflake has its own CLI tool: SnowSQL. In this level of the Stairway Series learn how to work with this dialect in Snowflake and Visual Studio Code.
2024-11-20
701 reads
This next level of the Stairway to Snowflake looks at the Snowsight UI and what you can accomplish with it.
2024-11-12 (first published: 2024-10-23)
1,171 reads
In the next level of the Stairway to Database Containers, let's learn to use a compose file to specify a number of options for our container.
2024-08-28
885 reads
In this second level of the Stairway to Synapse, we learn how to create external tables and query data that is stored in our data storage using the serverless pool.
2024-10-24 (first published: 2024-08-14)
661 reads
This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.
2024-07-17
415 reads
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
2024-10-24 (first published: 2024-07-03)
617 reads
Business Intelligence Architect, “Analysis Services Maestro, and author Bill Pearson introduces two somewhat similar DAX Time Intelligence functions related to “parallel” Date periods: PARALLELPERIOD() and SAMEPERIODLASTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2024-01-24
1,467 reads
In this level you will learn about the SQLServer PowerShell module that ships with modern versions of SSMS.
2024-01-20 (first published: 2024-01-17)
1,353 reads
In the fourth level of this series, we will examine how you can use the scripting classes to create the code to manage your SQL Server instances and databases.
2024-01-20 (first published: 2023-12-13)
1,552 reads
The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […]
2023-12-06
1,967 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
4. Use the Right Talismans for Stamina and Weight Synergy Talismans can help mitigate...
2. Highlight How Accountability Leads to Success Recruits are looking for programs where they...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers