Securing Workloads on IBM Cloud – Some Resources
Securing Workloads on IBM Cloud – Some Resources
Read the complete post at blog.4loeser.net/…/securing-workloads-on-ibm-cloud-some.html...
SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.
SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.
A very old client of mine yesterday pinged me with this question about error related to QUOTED_IDENTIFIER. “Pinal, When I run my query it works just fine in SSMS but when I run it via SQL Server Agen...
Location and Intent Matter: Data Privacy vs. US Government
Location and Intent Matter: Data Privacy vs. US Government
Read the complete post at blog.4loeser.net/…/location-and-intent-matter-data-privacy.html...
SQL SERVER – Improve Application Performance on Cloud While Reducing Bandwidth Cost
SQL SERVER – Improve Application Performance on Cloud While Reducing Bandwidth Cost
It is very common for people to move databases now a days to the cloud. The very first question I often hear from them is – How to Improve Application Performance on Cloud While Reducing Bandwidth Cos...
How to create reports in Toad for Oracle with multiple non-related datasets
How to create reports in Toad for Oracle with multiple non-related datasets
Toad's Report's Manager has been around for a while, and it's great at making pretty reports of either a single dataset, a simple master-detail dataset, or complex master-detail datasets with multiple...
A Program to Find INSERT Statements That Don’t Specify Columns
A Program to Find INSERT Statements That Don’t Specify Columns
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...
SSMS Presenter Mode
SSMS Presenter Mode
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...
Quick Tips: Add SQL User/Rolemember to all Databases in SQL Server
Quick Tips: Add SQL User/Rolemember to all Databases in SQL Server
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...
SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup
SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup
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 ...
SQL Server vNext: sys.dm_db_stats_histogram
SQL Server vNext: sys.dm_db_stats_histogram
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 ...
SQL Slammer Is Back. Here’s What You Need to Know
SQL Slammer Is Back. Here’s What You Need to Know
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 ...
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...