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.
Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008
Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance.
Hack Us
A challenge from United intrigues Steve Jones. How many other companies would make a challenge like this?
Storing a Binary File in a Database
In this article you will see how to convert a file to a binary stream and insert it into SQL Server with SQLCLR.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers