Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up...
2017-12-20
364 reads
A quick post this week, since it’s that time of the year when people do gift exchanges and put up...
2017-12-20
364 reads
2017-12-13
316 reads
This post is a public service announcement for all users of macOS High Sierra (10.13). (Note: Apple has already released...
2017-12-06
538 reads
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
696 reads
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because...
2017-11-22
339 reads
For the last five months or so, I have been helping some really smart people put words on paper, both...
2017-11-15
560 reads
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two...
2017-11-14
320 reads
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
325 reads
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
485 reads
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
3,909 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...
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...
This is one I haven't seen before. I'm trying to drop a database user...
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