#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
707 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
645 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
454 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
755 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,933 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,576 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,085 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,503 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
897 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,299 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers