The world of Automatic Tuning – SQL Server 2017
Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...
2018-01-31 (first published: 2018-01-22)
2,407 reads
Arun Sirpal
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
263 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,598 reads
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
574 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
985 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
626 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
566 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,520 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
313 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,689 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
Forums
display bytea image
I moved a table from MsSql to Postgresql that had a field defined as...
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Resolving Access Denied Errors During SQL Server Database Attachment
Comments posted to this topic are about the item Resolving Access Denied Errors During...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers