Database default locations
One of the options you had when installing your instance was setting some default file locations.
Defaut data file locationDefault log...
2014-10-01 (first published: 2014-09-29)
8,099 reads
One of the options you had when installing your instance was setting some default file locations.
Defaut data file locationDefault log...
2014-10-01 (first published: 2014-09-29)
8,099 reads
I had an article published yesterday on http://www.SQLShack.com.
Intro to Auditing in SQL Server.
It’s worth reading if I do say...
2014-10-01
1,213 reads
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...
2014-09-24 (first published: 2014-09-22)
7,616 reads
For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how...
2014-09-24
619 reads
Trace flags are one of those things that I’ve heard about more and more over the last five or six...
2014-09-18 (first published: 2014-09-11)
7,919 reads
For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL...
2014-09-17
1,437 reads
Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this...
2014-09-15
1,182 reads
It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host...
2014-09-12 (first published: 2014-09-09)
6,714 reads
I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years...
2014-09-04 (first published: 2014-08-27)
7,695 reads
I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop...
2014-09-04
3,816 reads
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Comments posted to this topic are about the item Do You Really Need HA?
Comments posted to this topic are about the item The New Database CheckDB
Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers