ALTER INDEX….ABORT!
I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes...
2016-10-06
480 reads
Arun Sirpal
Detaching corrupt databases
Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...
2016-10-04
597 reads
Query Store – Quick Tour
The query store, Borko Novakovic Senior Program Manager from Microsoft calls this feature “Similar to an airplane’s flight data recorder”....
2016-10-03
452 reads
My application to Microsoft
I have been eager to write this blog post for a while now. I want to share my experience of...
2016-09-29
878 reads
Restoring Azure SQL Database
A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering...
2016-09-23 (first published: 2016-09-16)
1,223 reads
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
518 reads
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,859 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
557 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
483 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,227 reads
Blogs
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...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers