Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also available with the latest Cumulative Update for ...
First reported back in 2002, the SQL Slammer virus caught fire in January of 2003, and spread worldwide. The post SQL Slammer Is Back. Here’s What You Need to Know appeared first on Thomas LaRock. If ...
Read the complete post at blog.4loeser.net/…/write-your-own-cli-plugins-for-bluemix.html...
I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed a selection of tables that I wanted to off-load to Azure. For this post I will be going ...
No rugby on last weekend so I didn’t have anything to distract me from working. On another note, my flat has never been cleaner! So last week Microsoft announced Availability Groups for SQL Server on...
I was consulting a client for migration from SQL 2014 to SQL 2016. They were using methodology discussed in books online here. https://msdn.microsoft.com/en-us/library/dn178483.aspx (Upgrading Always...
Question: How to Keep Certain Records on Top While Ordering Data? Let me elaborate this question as it is originally received. “Hi Pinal, I just returned from an interview and I faced a very strange ...
There might be various reasons for above error, but this case is very specific to a situation where SQL Server was installed on a machine which was in Workgroup whereas the backup destination was the ...
This is a different spin on the top three vendor rankings visualized in Power BI. According to the placement of the chart elements in the “Visionary/Leader” quadrant, Microsoft leads Tableau by a lit...
I’ll be speaking at the annual Hotsos Symposium in Dallas TX February 27th and 28th. To quote their website: Hotsos is the best conference in the Americas devoted to Oracle system performance. The co...
Read the complete post at blog.4loeser.net/…/carnival-even-db2-wears-mask-database.html...
When you work in information technology long enough, you get to see how people react when something new comes along. Some people embrace change, even to the point of being an early adopter. Others mig...
