2017-09-29
1,038 reads
T-SQL
2017-09-26
1,186 reads
When sp_HelpText is not so helpful!
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,411 reads
2017-09-22
1,135 reads
2017-09-21
923 reads
2017-09-18
1,163 reads
2017-09-12
1,025 reads
SQL Data Aggregation Aggravation
When we have to deal with and store a lot of data, it makes sense to aggregate it so that we store only the information we actually need. If we get this right, this works well, but the design of the system takes care and thought because the problems can be subtle and various. Joe Celko describes some of the ways that things can go wrong and end up providing incorrect, inaccurate or misleading results.
2017-09-12
3,866 reads
2017-09-05
1,090 reads
Statistics in SQL: The Mann–Whitney U test
Phil Factor shows how to use the Mann-Whitney U test in SQL to to find out whether two samples come from the same distribution.
2017-09-04
4,456 reads
Blogs
A New Word: Mottleheaded
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Democratizing Core Contributions: A Guide to WordPress.org Badges
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Forums
New article
Comments posted to this topic are about the item New article
Monitoring Azure Blob Storage
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers