-
Recent Posts
Recent Comments
Bob L on Moving Databases from One Inst… Bob L on History may not repeat, b… Michael Abrams on History may not repeat, b… Mark Polczynski on Moving Databases from One Inst… emilie parker on Now at 5.11 GB/s SQL backup to… Archives
- August 2016
- June 2016
- October 2015
- September 2015
- August 2015
- July 2015
- February 2015
- December 2014
- July 2014
- May 2014
- March 2014
- February 2014
- November 2013
- September 2013
- August 2013
- July 2013
- March 2013
- October 2012
- April 2012
- March 2012
- February 2012
- October 2011
- September 2011
- November 2010
- July 2010
- June 2010
- May 2010
- November 2009
- October 2009
- August 2009
- July 2009
- June 2009
- May 2009
- January 2009
- June 2008
Categories
- 2FA
- Artificial Intelligence
- Azure
- Cloud
- data security
- Fusion-io
- Hyper-v
- Machine learning
- Mulifactor Authentication
- Problem Solving
- Security
- SQL Server
- SQL Tips and Techniques
- Stock Market
- Technical Analysis
- Uncategorized
- Virtualization
- Windows Server
- Windows Server 2008 R2
- Windows Server 2012
- Windows Server 2012 R2
Meta
Author Archives: Bob L
SQL Server 2016 RTM
Some major enhancements and a convergence on features from Azure to on-premise. The ‘R’ capabilities and seamless integration with big data are game-changers. https://www.microsoft.com/en-us/cloud-platform/sql-server
Posted in Uncategorized
Leave a comment
When two-factor authentication really isn’t
My hope is that by now all companies are using multifactor (MFA for short) authentication to protect all critical assets. MFA authentication simply means that a user must validate their identity through at least two independent mechanisms. Two-factor authentication or … Continue reading
Posted in 2FA, data security, Mulifactor Authentication, Security
Tagged 2FA;MFA;Data Security
Leave a comment
Multiple divergences for S&P analyzed (Corrected)
Note: My first version of this had an error in the query which has been corrected and the difference between up and down days is not significant. However, the larger the VIX change, the more likely to be a VIX … Continue reading
Posted in SQL Tips and Techniques, Stock Market
Tagged Predictive analysis, SQL Queries, Stock Market
Leave a comment
History may not repeat, but…
Somebody from a private forum I belong to known as “T-Theory” posted a graph that shows the rationale for being long the S&P when the 10 week exponential moving average is trending above the 50 week exponential moving average and … Continue reading
A couple of factoids on data security to think about
Here’s factoid that most people, even many at the IT management level don’t realize: A 128 GB Thumb drive which can be had for under $40.00 can store enough information to accomplish identity theft for the population of the entire … Continue reading
Posted in Uncategorized
Leave a comment
High-performance Statistical Queries using Self-joins
In my pursuit of understanding asset markets, I’ve maintained a SQL Server database with a lot of information about the stock market and other indexes. Using some data services along with SSIS, this database has been kept current to the … Continue reading
Posted in Uncategorized
Leave a comment
Increased data security focus for Authintel
We’ve all seen the news about the latest data security breaches. While bureaucrats blame these on sophisticated hacks from China, the reality is that these are mainly due to negligence and are so simple that a child with basic computer … Continue reading
Posted in Uncategorized
Leave a comment
Power BI Experiences
I’ve spent quite a bit of time the last few days trying to get Power BI preview to work for accessing a tabular model so am sharing my experience. Based on that experience, I am making some assertions that are … Continue reading
Posted in Uncategorized
Leave a comment
Data Security and the Lack thereof
Americans are increasingly becoming aware of the vulnerability of their private data with breaches now up in the millions that have not only disclosed credit card information, but even more potentially dangerous information such as social security numbers linked to … Continue reading
Posted in Uncategorized
Leave a comment
Home-grown PCIE SSD VM vs. Azure (Update 12/7)
More testing today with larger database, multiplied the number of rows by 10x up to 1 billion rows in the test dataset. The latest results indicate I/O about 3 times slower on an Azure D13 server using similar CPU/Ram specs … Continue reading