SQL Server Configurations – Back to Basics
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would...
2018-01-11
534 reads
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would...
2018-01-11
534 reads
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a...
2018-01-11
10 reads
Conquering Challenges
I really like the topic of the TSQLTuesday party today. Today we have been instructed in no uncertain terms...
2018-01-19 (first published: 2018-01-10)
1,076 reads
The challenge at hand - conquering that technical problem and getting that high associated with the metaphorical high of summiting a tough task.
Related Posts:
Summiting that Technical Challenge Part II...
2018-01-10
3 reads
Once in a while I come across something that sounds fun or interesting and decide to dive a little deeper...
2018-01-06
558 reads
In this article I introduce you to some basics in regards to default behaviors and settings in tempdb along with some best practices. It is advisable to investigate from...
2018-01-06
17 reads
Every now and then I find a topic that seems to fit perfectly into the mold of the theme of...
2018-01-17 (first published: 2018-01-05)
1,504 reads
In this article I will explore altering the default logs directory location. Some may say this is no big deal and you can just use the default location used...
2018-01-05
39 reads
One of the all-time greatest and most beloved applications among DBAs happens to be Sharepoint. Most of us would be...
2018-01-04
1,640 reads
In this article I have introduced you to a quick session setup that comes from using the SPDiag tool that could plausibly be useful in the troubleshooting of various...
2018-01-04
55 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
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