The In-Memory Database and In-Memory Caching market is heating up and we (the users) are the real winners. Exciting!!!
SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio
Recently, while working on a demo about backup, I realized that in management studio, now there is a new option in the backup screen called a URL. This feature is called as “backup to URL”. I checked earlier version of SSMS and found that this was not there in the…
Read MoreDeveloper’s Life – Every Developer is a Sherlock Holmes
I have been thinking a lot about how developers are like super heroes, and I have written two blog posts now comparing them to Spiderman and Superman. I have a lot of love and respect for developers, and I hope that they are enjoying these articles, and others are learning…
Read MoreSQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio
I recently formatted my computer and reinstalled my machine and I end up on following error: Package ‘Microsoft SQL Management Studio Package’ failed to load I was able to fix the error quickly, but while I was searching online, I noticed quite a few of the people have similar error…
Read MoreMySQL – Dynamic SQL with EXECUTE and PREPARE Statements
MySQL supports Dynamic SQL with the help of EXECUTE and PREPARE statements. Suppose you have a scenario where you need to pass table name as parameter value and returns all column values, you can use Dynamic SQL. Let us create this table and data. CREATE TABLE TestTable (ID INT, Col…
Read More
SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033
[Notes from Pinal]: I am working with SQL Server for almost 10 years. I have seen the most ignored databases on any database server is system database. We hardly pay attention to them. Just for the sake of it – try to run queries in your master database and see…
Read MoreSQL SERVER – Change Fill Factor – SQL in Sixty Seconds #069
“I want to change fill factor to another value – how do I do that?” The other day I received this question in via Facebook. Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the…
Read More