1,465 reputation
43148
bio website
location
age
visits member for 3 years, 5 months
seen Nov 18 at 10:30

Jan
23
asked Is it good practice to assign a system account for database owner?
Jan
20
accepted What “tool” to use for monitoring instances and where to store this data?
Jan
20
comment What “tool” to use for monitoring instances and where to store this data?
Yes, exactly, free space, backup checks etc.
Jan
19
revised What “tool” to use for monitoring instances and where to store this data?
added 6 characters in body
Jan
19
comment What “tool” to use for monitoring instances and where to store this data?
Thanks, but I cannot afford third party tools like RedGate. My intention was to question what is the most "logical" place to store monitoring data from three instances and what tools to use (SSIS, PowerShell, or stored procedures).
Jan
19
asked What “tool” to use for monitoring instances and where to store this data?
Jan
17
answered Recommended tools for SQL Server Developers & DBA
Jan
4
accepted How to select a subset of data from a large ER model?
Jan
4
comment How to select a subset of data from a large ER model?
Yes I do, mostly.
Jan
3
comment How to select a subset of data from a large ER model?
About 300 tables...
Jan
3
asked How to select a subset of data from a large ER model?
Dec
12
accepted Column sort order in CREATE INDEX statement?
Dec
11
asked Column sort order in CREATE INDEX statement?
Dec
11
accepted Small sample database for practicing database administration?
Dec
10
comment Small sample database for practicing database administration?
Smaller ER model, more easily adopted.
Dec
10
asked Small sample database for practicing database administration?
Dec
8
accepted Should dbo schema be avoided?
Dec
7
comment Should dbo schema be avoided?
Well, yeah, that was also the reason I asked this question here.
Dec
7
comment Should dbo schema be avoided?
I found this statement also from Alexander Kuznetsov in the comments of this blog post:
Dec
7
comment Should dbo schema be avoided?
Some consultant said that it is good practice to avoid dbo schema and always create user defined schemas and assign objets into these schemas.