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)
Replying to @LeahR77
Yep
Replying to @RealJamesWoods
I found Michelle Obama's pre-recorded speech that was written for her and was played at the DNC convention, to be more sincere and moving. Kidding of course.
Replying to @RealJamesWoods
She gives dumb people a bad name.
Replying to @MrAndyNgo
I live in Chicago. I have a pile of parking tickets and four businesses shut down to one degree or another (between two people.) funds for food only. Kids gotta eat. Schools closed. Got booted too. For now I'll just follow you and do what I can to support your site!
3
14
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
Replying to @GoatTalkOnly @Benaskren @NateDiaz209 @nickdiaz209
He thinks he's Jesus because his crusifix is tight
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
Load more