2017-03-21 (first published: 2017-03-15)
458 reads
SQL
2017-03-07 (first published: 2017-03-01)
1,200 reads
2017-02-28
11,121 reads
Azure DWH part 1:Common questions about Azure SQL Data Warehouse
This article compiles some common questions and answers about Azure SQL Data Warehouse.
2016-12-28
9,204 reads
Data Mining Part 37: The Data Mining query transformation task
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
2,466 reads
Extracting string after and before a Character/Pattern
Finding characters/string before and after some character or pattern
2017-01-06 (first published: 2015-11-09)
245,306 reads
SQL Explained
A short explanation and infographic of what SQL is. For the non-SQL people in your life.
2015-07-24
8,743 reads
10 SQL Snippets For Faster, More Effective Code
How many hours per week do you spend writing the same SQL again and again?
2015-07-16
9,402 reads
2015-06-23
2,046 reads
Converting to data-driven code
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
2015-03-16
6,659 reads
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