Who Cares About Your Data?
The observation that people hear what they want to hear is not a new one, and yet the extent to which people will go out of their way to ignore or misinterpret evidence can still surprise.
Converting Comma Separated Value to Rows and Vice Versa in SQL Server
Often while reporting you will encounter a situation where you will have comma separated values in a single column but you want to report them in rows. In other cases you might have values in multiple rows and want them to be a single value separated by comma or some other character. Arshad Ali demonstrates how to write queries in SQL Server to handle these scenarios quickly.
Big Data for SQL folks: The Technologies (Part II)
SQL Server Big Data.
Is the end Near for ETL as we know is?
Will RDBMs be obsolete?
What is NoSQL? What is Hadoop? Big Data-the whole story.
Statistical Analysis
This week Steve Jones asks the questions about advanced data analysis and statistics you might be using in your applications.
A Plethora of PowerShell Pitfalls: Part 2
There are some pitfalls in PowerShell for the unwary. Many people who are learning PowerShell come across quirks that can cause frustration. Michael Sorens continues his series, warning abut four of the most common PowerShell pitfalls and explains how to avoid them.
Retrieving a Binary File from Your Database
In this second article I provide the means to restore a binary file to its original state.
The Hidden Patterns in Data
Looking at statistics and data to draw conclusions can be hard. Steve Jones comments on an interesting way of analyzing data from TED.
Converting and Using Text Dates as SQL Server Dates
This tip describes some T-SQL techniques for converting a mmddyyyy string to a SQL Server date, handling rows with missing date strings, and comparing converted date strings.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor resmi BCA KCU A. YANI Telp: 0817.82.5533
WhatsApp: 0817825533, Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282
BCA KCP SENEN TLP/W 083800119009
Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec. Senen, Kota Jakarta...
BCA KCP KEBON SIRIH TLP/WA 083800119009
Jl. Kebon Sirih No.6A Lantai 1 B, Gambir, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers