@xmlsqlblogger profile picture
Alan Burstein @xmlsqlblogger

Business Intelligence Consultant, T-SQL Evangelist, blogger, aspiring data scientist with an unparalleled passion all things data #SQLPASS

Joined August 2010
  • Tweets 401
  • Following 241
  • Followers 88
8 Photos and videos
In case you've never seen a SQL Server higher order function: CREATE FUNCTION dbo.Factorial_recur3(@N BIGINT) RETURNS BIGINT AS BEGIN RETURN (IIF(@N<=1,1,@N*dbo.Factorial_recur3(@N-1))); END; GO #fp #function #functional #higherorderfunction
1
Just finished this. Good Read. #pvsnp #complexity #nastyfast
This tweet is unavailable
Good video about #functionalprogramming #Clojure youtu.be/QyJZzq0v7Z4
2
#spam
1
Boom! Inline Scalar UDFs! blogs.msdn.microsoft.com/sql… #SQLServer #SQLPerformance #pureFunctions
1
1
Alan Burstein retweeted
Itzik Ben-Gan@ItzikBenGan
7 Jun 2017
Article: What You Need to Know about Distinct Windowed Aggregate Calculations sqlmag.com/sql-server/what-y…

1
17
31
Very tweet worthy SSC article SQL Login Password Audit - sqlservercentral.com/article… #SQLServer #passwordsecurity #SecureYourself
Me: anyone feel like their being watched CIA: *they're
1
5
#Uber is down all you #Lift & #via drivers best get busy. #punkprogrammers
Alan Burstein retweeted
Gianluca Sartori@spaghettidba
11 Nov 2016
Complete list of trace flags by @mssqltiger aka.ms/traceflags

Trace Flags (Transact-SQL) - SQL Server

Learn how to set specific server characteristics or to alter a particular behavior in SQL Server, using DBCC TRACEON.

learn.microsoft.com
2
Alan Burstein retweeted
Colin Davy@AdjBaseline
3 Nov 2016
Congrats to Cubs owner @cameronesposito and her commitment to analytics, really a blueprint for how to build a team in the modern era.
4
43
Nasty Fast N-Grams (Part 1): Character-Level Unigrams - sqlservercentral.com/article… #sql #SQLServer #datamining text #analytics #MachineLearning
2
14
Just read: Introduction to U-SQL and Azure Data Lakes - SQLServerCentral sqlservercentral.com/article… #sql #Azure #datalake #CloudComputing
1
2
Azure Machine Learning - Your first experiment - SQLServerCentral sqlservercentral.com/article… #MachineLearning #Azure #PredictiveAnalytics
1
My First SQLServerCentral artcile: Nasty Fast PERCENT_RANK - sqlservercentral.com/article… #analytics in #SQLServer, #data #SQL2016 #database
Alan Burstein retweeted
Kirk Borne
@KirkDBorne
31 May 2016
A #DataScience Declaration an inspiring quote for #DataScientists: rocketdatascience.org/?page_… #BigData is a vast sea
19
7
Another amazing Itzik Ben Gan article: m.sqlmag.com/sql-server/what… via @SQLServerMag #SQLServer #aggregates #SQLServer2016 #sql #nastyfast
New T-SQL Fixed Width "Splitter" - SQLServerCentral sqlservercentral.com/scripts… #SQLServer #SQL #TextMining #strings #sqlperformance
1
Finally! A T-SQL Translate function for SQL Server @SQLServerCentrl sqlservercentral.com/scripts… #TextMining #SQLServer #tallytable #sql
1
Load more