2018-06-11 (first published: 2018-01-03)
2,593 reads
SQL
2017-12-29 (first published: 2017-12-27)
1,513 reads
Azure DWH part 20: Create External and Internal tables As Select
CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.
2019-07-12 (first published: 2017-12-12)
3,448 reads
SQL-On-Hadoop: Hive - Part II
Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.
2019-07-26 (first published: 2017-12-11)
4,760 reads
SQL Saturday statistics – Web Scraping with R and SQL Server
Tom wants to check a simple query: How many times has a particular topic been presented and from how many different presenters.
2017-11-27
3,827 reads
Missing Data
In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be plain wrong or it can be altogether missing. Sure, we have the NULL to signify unknown, but that doesn't play well with regular business reporting. There are a number of ways of dealing with missing information, and methods of estimating data from existing data has a long and respectable history. Joe Celko gets to grips with a data topic that is often treated with some trepidation.
2017-11-13
4,133 reads
SQL Code Smells
Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. There are now around 150 of these smells and SQL Code Guard is committed to cover as many as possible of them.
2017-11-06
8,928 reads
Six Scary SQL Surprises
The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially true if the DBA is not checking and monitoring the databases for obvious things such as database corruption, and disk space. However, the really scary surprises are less obvious and provide fewer warning signs. Brent Ozar gives six scary surprises that can be avoided by the shrewd DBA.
2017-10-31
7,099 reads
Azure DWH part 18: Working with SQL Server Analysis Services
In this new article, we will learn how to create a cube extracting data from ADWH.
2020-05-22 (first published: 2017-10-09)
2,273 reads
Azure DWH part 17: ADF:Import Data from SQL Server on-premises to ASDW
In this article we will learn to use Data Factory to import table from SQL Server to Azure SQL Data Warehouse.
2017-10-03
719 reads
Blogs
Goal Progress for Nov 2022
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?
Very excited to take part in my third #PGSQLPhriday blogging event, even more so...
Daily Coping 2 Dec 2022
By Steve Jones
Today’s coping tip is to enjoy new music today: play, sing, dance, or listen....
Forums
Selecting temp tables & CTEs using PowerBI
I have a pretty difficult assignment. This is the structure that I need to...
Making the World Better
Comments posted to this topic are about the item Making the World Better
Ask SSC