#TSQL2sDay – Data marts across a shaky WAN link
It sounded good in principle, especially given the requirements and the limitations:
We needed our various sites to be able to...
2014-02-11
701 reads
Blog Posts
[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server
Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an...
2014-02-11
643 reads
175 Analytic and Data Science Web Sites #bigdata #freedata #analytics #datascience
Following is a list (in alphabetical order) of top domains related to analytics, data science or big data, based on...
2014-02-11
445 reads
8 Proven Steps to Starting a Big Data Analytics Project #bigdata #analytics
AN EIGHT-STEP APPROACH TO A BIG DATA ANALYTICS PROJECT
We’ve created a high-level list that speaks to 8 different steps to...
2014-02-11
754 reads
Book Review: The Phoenix Project
Let’s get this straight right up front, the thought of reading a novel that’s about IT is so repellent, so...
2014-02-11 (first published: 2014-02-05)
1,931 reads
Calculating the length of a hash in SQL Server
Some time ago I added a script component to a few SSIS packages to compare rows with each other using...
2014-02-11
2,555 reads
Conditional Aggregates
The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a...
2014-02-11 (first published: 2014-02-04)
3,084 reads
Correlation Does Not Imply Causation
One of the biggest mistakes we can make when troubleshooting is to confuse the necessary responsibility of observing activity that...
2014-02-11
1,501 reads
DELETE operations on tables
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-11
890 reads
Enterprise-class real-time stream analytics for Big Data
Since the beginning of the information age, enterprises have relied on processing data to gain insights and make business decisions....
2014-02-11
1,294 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers