Not SQL: Taking a stand against scammers
If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...
2017-05-03
533 reads
If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...
2017-05-03
533 reads
Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a...
2017-04-26 (first published: 2017-04-17)
3,335 reads
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,045 reads
FYI: This one is way off topic so don’t expect to find any fancy SQL tips here.
I did it. I...
2017-04-14
491 reads
This is my first time blogging with a T-SQL Tuesday topic. If you follow my blog you’ve probably noticed that...
2017-04-11
493 reads
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
501 reads
It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory...
2017-03-22
628 reads
Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to...
2017-03-21 (first published: 2017-03-03)
3,561 reads
Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that...
2017-03-03
468 reads
If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I...
2017-02-15 (first published: 2017-02-08)
3,377 reads
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers