Azure Portal – Bad Request
I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my...
2018-01-16
269 reads
All About SQL
T-SQL Tuesday #98 Round Up
Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...
2018-01-11
583 reads
Azure SQL Database – Optimizing For Ad-hoc Workloads
Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...
2018-01-16 (first published: 2018-01-08)
1,603 reads
Azure SQL Analytics
Azure SQL Analytics is currently in preview mode, still it is very impressive. The goal of this feature is to...
2018-01-04
995 reads
T-SQL Tuesday #98 – Your Technical Challenges Conquered
Welcome to the January 2018 edition of T-SQL Tuesday and I am your host BlobEater (Arun Sirpal).
If you do not...
2018-01-02
630 reads
A Basic Bot using Azure Bot Services
I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....
2017-12-19
576 reads
SQL Server DBCC CHECKDB – Going Parallel
DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...
2017-12-18
317 reads
SQL Server Failed to Open Loopback Connection – What?
I could not read my error log on one of my local SQL Servers, when I executed the following code:
EXEC...
2017-12-12
816 reads
Moving to an Azure SQL Database via Command Line
I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...
2017-12-19 (first published: 2017-12-07)
1,553 reads
Azure SQL Database – Using sp_BlitzIndex
I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...
2017-12-14 (first published: 2017-12-05)
1,692 reads
Blogs
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers