Speaking engagements for August and September

August and September are going to be some busy weeks!

In those two months I will be speaking on three SQLSaturday...

How to drop a Temporal Table

No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or...

Making Changes to Many Forms In Access

Although generally I prefer to create custom interfaces for my databases using fully developed programming languages like Python or C#....

I’m Speaking! Omaha SQL Server/BI User Group

Well, it has finally happened. In the 7+ years that I helped to run the Omaha SQL/BI User Group, I...

Defining Foreign Keys at Table Create Time

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

SQL Server transactional replication performance tuning and optimization

If you`re using transactional replication on SQL Server platform on rather large and data intensive environment you may have faced...

Moving SQLAndy to Project Nami

I’ve been hosting this blog on Azure for a while, running WordPress on top of MySQL. Works fine, gives me...

Doing a Full Outer Join in Power Query

A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities...

Microsoft MVP–A dream came true

 
Dear All,
“Microsoft  Most Valuable Professional “ – MVP  is one of the prestigious tag. It is one of the dreams which came...

Backup Compression - Native vs Redgate

Many of the companies are using third party backup software for SQL server in order to help to reduce their...