Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-01-23
1,581 reads
All About SQL
Azure SQL Database – Reduce the workload before initiating another service objective update
Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message...
2019-01-21
234 reads
Moving off SQL Server 2008 / R2 – What can Azure offer?
You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that...
2019-01-15
248 reads
Azure SQL DB VS SQL Server For the DBA
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
309 reads
SQL Server Backup To Azure Storage
Once again I would like to share with you an article I wrote about backing up (and restoring) a SQL...
2019-01-01 (first published: 2018-12-19)
2,738 reads
Azure SQL Database DTU Versus vCore
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
873 reads
SQL Server I/O
Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an...
2018-12-11
228 reads
Azure SQL Database “Step By Step” Tutorials
I would like to share a link to my Azure SQL Database Stairway series hosted over at SQLServerCentral. As stated...
2018-12-06
456 reads
Azure SQL Database – Firewall Rules
If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...
2018-12-04
232 reads
Microsoft Professional Program vs Microsoft Certification
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
261 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers