Category Archives: Uncategorized

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   Advertisements

Posted in Uncategorized | Leave a comment

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

Using INSTEAD OF Triggers to enable updatable views

A common misconception with SQL Server views is that only indexed views can provide update capability. Actually, any view that is schema-bound can be enabled for update by simply using an “INSTEAD OF” trigger.  Although an indexed view may also … Continue reading

Posted in Uncategorized | Leave a comment