Write Your Own CLI Plugins for Bluemix Cloud Foundry
Write Your Own CLI Plugins for Bluemix Cloud Foundry
Read the complete post at blog.4loeser.net/…/write-your-own-cli-plugins-for-bluemix.html...
Setting up SQL Server to SQL Database (Azure) Replication
Setting up SQL Server to SQL Database (Azure) Replication
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 ...
Monday Coffee 2017-02-20
Monday Coffee 2017-02-20
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...
SQL SERVER – Fix: Error 946, Severity: 14 – Cannot open database ‘DB’ version 782. Upgrade the database to the latest version
SQL SERVER – Fix: Error 946, Severity: 14 – Cannot open database ‘DB’ version 782. Upgrade the database to the latest version
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...
How to Keep Certain Records on Top While Ordering Data? – Interview Question of the Week #110
How to Keep Certain Records on Top While Ordering Data? – Interview Question of the Week #110
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 ...
SQL SERVER – Cannot open backup device. Operating system error 1326 (Logon failure: unknown user name or bad password.)
SQL SERVER – Cannot open backup device. Operating system error 1326 (Logon failure: unknown user name or bad password.)
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 ...
Gartner Magic Quadrant for BI 2017 Top 3 Rankings
Gartner Magic Quadrant for BI 2017 Top 3 Rankings
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...
Speaking at the Annual Hotsos Symposium
Speaking at the Annual Hotsos Symposium
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...
Carnival: Even DB2 Wears a Mask (Database Security)
Carnival: Even DB2 Wears a Mask (Database Security)
Read the complete post at blog.4loeser.net/…/carnival-even-db2-wears-mask-database.html...
The Future of Managing Databases in a Hybrid IT World
The Future of Managing Databases in a Hybrid IT World
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...
SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage
SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage
Few days back I wrote blog to help my blog reader and this is follow up on the same post How to Add Date to Database Backup Filename? – Interview Question of the Week #109. In this blog post we will s...
True story: Encryption in progress stuck
True story: Encryption in progress stuck
Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while. Using the following query I confirmed the follo...
- Go to the previous page
- 1
- …
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- …
- 149
- Go to the next page