Unlike mathematical relations, SQL tables have ordered columns, but please don’t depend on it. In other words, try to treat these tables as the same because it’s super-awkward to turn one into the ot...
SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not recommended for production use. There are many enhancements wh...
Most of times when you have dedicated SQL Server for an Application clients come up with a request to add a user to all databases in the SQL Server with certain permission, while its east to do it via...
While playing with my SQL Server startup parameter, I made some mistakes and came to a situation where SQL Server was not getting started. In this blog post, let us learn about error 17113. Whenever ...
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 ...
