When inserting bulk data, the SQL Server destination may often prove to be a better option as compared to the OLE DB destination. Read the complete post at feedproxy.google.com/…/...
One of my clients contacted me and informed that after patching of SQL Server, they noticed that their maintenance plan were failing. I asked them to share the complete error message about the Mainten...
Recently, a DB2 for z/OS professional I’ve known for some years sent to me a question about the relationship between the PGSTEAL and PGFIX options of the DB2 command -ALTER BUFFERPOOL. It took a few i...
The notifications emails of a “planned” downtime is one of the annoying things of monitoring systems. You forget creating blackout and you start a maintenance work, and you get lots of notifications m...
While trying to start SQL Service for a named instance, I got an error message related to event id 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance...
Read the complete post at blog.4loeser.net/…/securing-workloads-on-ibm-cloud-some.html...
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...
Read the complete post at blog.4loeser.net/…/location-and-intent-matter-data-privacy.html...
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...
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...
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...
