Blogs Phil Factor in Blogs Pivot Rotation and Matrix Transpose in SQL Server: A New Method? The question often comes up: how do you pivot data in SQL Server? In looking closer at the question, there... 12 December 2017 7 min read
BI Robert Sheldon in BI SQL Server Machine Learning Services: Python with sp_execute_external_script Run Python scripts in SQL Server using sp_execute_external_script in Machine Learning Services. Part 1 covers enabling MLS, naming input/output variables,... 30 November 2017 21 min read
Database Administration Robert Sheldon in Database Administration Still More SQL Server Features that Time Forgot As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been... 17 November 2017 15 min read
T-SQL Programming Alfonso Hernandez in T-SQL Programming Summarizing Data Using the GROUPING SETS Operator Writing aggregate queries is one of the most important tasks for anyone working with T-SQL. Determining the expressions required in... 14 November 2017 9 min read
BI Robert Sheldon in BI SQL Server R Services: Working with Multiple Data Sets Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by... 03 November 2017 19 min read
T-SQL Programming Phil Factor in T-SQL Programming Import and Validate JSON from Web Services into SQL Server: T-SQL Techniques Import and validate JSON from web services into SQL Server using T-SQL. Covers path expression parsing, metadata comparison, data type... 27 October 2017 35 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Handling Location Datatypes How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth... 19 October 2017 14 min read
Database Administration Robert Sheldon in Database Administration Even More SQL Server Features that Time Forgot SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in... 18 October 2017 13 min read
BI Robert Sheldon in BI SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs By being able to run R from SQL Server, you have available to you not just a convenient way of... 04 October 2017 15 min read
Database Administration Robert Sheldon in Database Administration More SQL Server Features that Time Forgot SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are... 20 September 2017 14 min read
Blogs Phil Factor in Blogs SQL Server OPENJSON: Parse Hierarchical JSON into Relational Tables Use SQL Server OPENJSON to parse hierarchical JSON documents into relational table structures. Covers recursive and iterative approaches, EAV patterns,... 12 September 2017 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Missing Data In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be... 08 September 2017 11 min read
BI Robert Sheldon in BI SQL Server R Services: Working with Data Frames Although you can get started with R in SQL Server without understanding data frames, they are a key structure of... 06 September 2017 29 min read
Editorials Phil Factor in Editorials When is the Data Deleted? Imagine that your business is providing a service to individuals, and you charge by the amount of usage. You are... 24 August 2017 3 min read
Opinion Pieces Robert Sheldon in Opinion Pieces The SQL Server Features that Time Forgot Every new release of SQL Server comes with new features that cause a ripple of excitement within the industry: well,... 23 August 2017 12 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Random Thoughts How does one get a truly random sample of data of a certain size from a SQL Server database table.... 11 August 2017 9 min read
T-SQL Programming Hitendra Patel in T-SQL Programming The Power of Python and SQL Server 2017 Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL... 04 August 2017 14 min read
Blogs Phil Factor in Blogs Statistics in SQL: Student’s t-test Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test... 03 August 2017 5 min read
.NET Dennes Torres in .NET SQL Server Query Hints in Entity Framework: DbCommandInterceptor Guide Add SQL Server query hints to Entity Framework using a DbCommandInterceptor. Covers OPTION RECOMPILE, table hints (UPDLOCK, HOLDLOCK), and why... 01 August 2017 29 min read
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style – Part 4: Performance There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse... 31 July 2017 17 min read
