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,669 reads
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,669 reads
I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will...
2016-09-19
552 reads
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,214 reads
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
480 reads
Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So...
2016-09-14
508 reads
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,217 reads
It is really easy getting insight into Query performance within your Azure SQL DB. I think Microsoft have done a...
2016-09-12
753 reads
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
540 reads
Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower...
2016-09-01
399 reads
I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine...
2016-08-25
183 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers