Boring or Scripting
There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
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.
Should That Be One Update Statement or Multiple?
Let’s say we have a couple of update statements we need to run every 15 minutes in the Stack Overflow database, and we’ve built indexes to support them:
The SQLskills Black Friday Super Sale!
Starting at 4pm PST on Thursday, November 28th, SQLskills will be offering our lowest prices ever for our signature Blackbelt bundle with more than 158 hours of top-quality training.
How Do You Patch 100 Database Servers?
The challenges of managing lots of system are significant and there aren't easy solutions, but Steve has a few thoughts on what you can do.
How to Develop Custom T-SQL Code Snippets in Azure Data Studio
Learn about code snippets and Azure Data Studio.
Microsoft SQL announcements at PASS Data Community Summit 2024
Read a summary of the data platform announcements from Microsoft at the PASS Data Community Summit 2024 last week.
Explore Pandas in Python to Analyze and Manipulate Tabular Data
Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.
It's The People
Last week the 2024 PASS Data Community Summit conference was held in Seattle. 1,700 of my closest friends got together for a week of learning (well, technically it's a three day conference, but there are two days of pre-conference seminars) and sharing. I'm still exhausted a week later (although, old age and an aggressive travel […]
Do You Want a Microsoft Solution?
Today Steve wonders if official solutions from a vendor are that important.
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers