Big Data and Hadoop Part 1
Big Data Definition
As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools...
2012-12-14
455 reads
Next Gen File System ReFS(Resilient File System) and SQLServer !
“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server...
2012-12-13
1,158 reads
On the First Day…
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has some connection with the Holiday season for Christians. Fewer...
2012-12-13
17 reads
On the First Day…
Many of us have heard the song “The Twelve Days of Christmas.” Some are familiar with how that song has...
2012-12-13
840 reads
Solution to VSTA editor error in SSIS 2012
The script task in SSIS 2012 is a great tool when you need to use C# or VB code to...
2012-12-13
3,682 reads
SQL Server Training–New York New York!
For those that read my blog regularly you will know that I over the last couple of years I have...
2012-12-13
1,031 reads
Using XQuery to remove duplicate values or duplicate nodes from an xml instance
Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...
2012-12-20 (first published: 2012-12-13)
19,552 reads
The Great DBA Getaway
Free, at last!
It’s holiday season which means it’s a time for you all to buy me gifts super busy time for Data...
2012-12-12
1,034 reads
PASSMN–Passing the Baton: A Board Transition Story
Each year the Minnesota SQL Server User Group elects new board members and resets its leadership team. I have been...
2012-12-12
775 reads
Working with Excel Destinations in SSIS - 0xC0202025, 0x80040E21
Working with Excel in SSIS is not fun and something I whole-heartedly discourage. With that said, I had a not...
2012-12-12
1,518 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers