Alan Burstein (@xmlsqlblogger) header
Alan Burstein (@xmlsqlblogger) profile picture

Alan Burstein

@xmlsqlblogger

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

 Chicagoland Area
sqlservercentral.com/Authors/Articles/Alan_Burstein/1023253/
Joined August 2010
  • Tweets401
  • Following240
  • Followers88
8Media
Photo by Alan Burstein (@xmlsqlblogger)Photo by Alan Burstein (@xmlsqlblogger)Photo by Alan Burstein (@xmlsqlblogger)Photo by Alan Burstein (@xmlsqlblogger)Photo by Alan Burstein (@xmlsqlblogger)Photo by Alan Burstein (@xmlsqlblogger)
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 quoted post is unavailable.
Try viewing anyway · View on X
Good video about #functionalprogramming #Clojure youtu.be/QyJZzq0v7Z4
2
#spam
Image from Alan Burstein (@xmlsqlblogger)
1
Boom! Inline Scalar UDFs! blogs.msdn.microsoft.com/sql… #SQLServer #SQLPerformance #pureFunctions
1
1
Alan Burstein retweeted
Itzik Ben-Gan (@ItzikBenGan) profile picture
Itzik Ben-Gan@ItzikBenGan7 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
Complete list of trace flags by @mssqltiger aka.ms/traceflags
Trace Flags (Transact-SQL) - SQL Server

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
1
Alan Burstein retweeted
Colin Davy (@AdjBaseline) profile picture
Colin Davy@AdjBaseline3 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
41
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) profile picture
Kirk Borne
@KirkDBorne31 May 2016
A #DataScience Declaration + an inspiring quote for #DataScientists: rocketdatascience.org/?page_… #BigData is a vast sea
Image from Kirk Borne (@KirkDBorne)
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