Azure SQL Data warehouse
For this blog post I want to show you the steps required to setup an Azure SQL Data warehouse and...
2016-09-21
519 reads
Arun Sirpal
SSMS Keeps Crashing
It is quite frustrating when SSMS (SQL Server Management Studio) randomly crashes, all too often for my liking. If you have...
2016-09-20
1,869 reads
Azure IaaS Premium Storage Test
I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will...
2016-09-19
564 reads
More PowerShell for the Azure World
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...
2016-09-15
493 reads
DBCC CHECKFILEGROUP
Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...
2016-09-14 (first published: 2016-09-13)
1,232 reads
PowerShell to create Azure SQL DBs
Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So...
2016-09-14
516 reads
Query Performance Insight
It is really easy getting insight into Query performance within your Azure SQL DB. I think Microsoft have done a...
2016-09-12
765 reads
DBCC HELP
I was going through some online courses and came across Erin Stellato’s Course on DBCC commands.http://www.sqlskills.com/blogs/paul/new-course-understanding-and-using-dbcc-commands/ I learnt something new!...
2016-09-09
554 reads
CHECKDB is slow!
Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower...
2016-09-01
406 reads
Talking of checkpoint
I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine...
2016-08-25
190 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers