How to detect if the guest account is disabled
A common SQL Server Security check is to identify if the guest id is enabled. By default , the SQL Server guest
My Black Friday sale ends tomorrow.
The countdown timer is on: you’ve got less than 48 hours to grab one of my massively discounted bundles and get the SQL Server training
Entry level data analyst questions
I’m a senior in college looking for entry level data analyst positions. I have fair understanding of sql and excel and beginner level of python.
When is it better to use a temp table over a CTE or window function for performance or cost savings?
I’ve heard it said quite a few times that using a CTE or window function can be costly and not the best for performance, so
How to return only rows that indicate a change?
Hello everyone, I started to learn SQL recently and need to get this work done ASAP but I’m really stuck. Table I have is something
Creating a key-value view with multiple aggregations
Hi, I’ve been scratching my head about this, hoping someone could help. I have two tables: `Companies` and `Revenues.` I’d like to create a (materialized)
Duplicate Values across Linked Servers
I have 7 databases set up as linked servers where I am running a query using Union between them. The databases have the same tables.
What exactly am I supposed to do to fix this problem?
https://stackoverflow.com/questions/70152587/sql-primary-key-is-wrong-for-assignment-not-sure-what-i-did-wrong I posted question on stackoverflow and still can’t figure out what i’m meant to do to fix the problem. Hopefully you can help Thank
query help to extract text
I’ve been trying to create a sql query in BigQuery to extra responses i got from a typeform survey so i can analyze what %
How can I query the results of a query and count() results that fall within a designated range?
Hey everyone, thanks for taking the time! I have the following query: SELECT bike_id, COUNT(trip_id) AS “trip_count”, COUNT(trip_id)/365 AS “avg_rides_per_day” FROM 2017 GROUP BY bike_id;