Stack Exchange

hot2use

Oberbüren, Switzerland

Good knowledge in the following fields

  • Microsoft SQL Server (6.5, 7.0, 20xx)
  • Oracle RDBMS (9i, 10g, 11g, 12c)

Basic Knowledge in the following areas (from best to worst)

  • PostgreSQL
  • MySQL
  • IIS Administrator
  • Lyris Administrator
  • Stellent (now Oracle UCM)
  • EMC Networker
  • IBM Storage
  • Linux (Fedora, Ubuntu)
  • Citrix
  • ITIL
  • Joomla

My function

  • IT System Manager / Database Administrator
top accounts reputation activity favorites subscriptions
Top Questions
19 votes

Windows OS Quantum vs. SQL OS Quantum

sql-server asked May 9 '19 at 14:40
dba.stackexchange.com

14 votes

In Search of FILESTREAM Insider Information

sql-server sql-server-2008 sql-server-2012 database-internals filestream asked Jul 18 '17 at 15:20
dba.stackexchange.com

10 votes

Offline markdown editor

discussion markdown editor asked Nov 17 '16 at 9:24
meta.stackexchange.com

10 votes

SQL Server Reporting Services (SSRS) IP Handling on Multi-Instance Servers

sql-server firewall windows-server-2012-r2 ip ssrs asked Nov 30 '16 at 7:28
serverfault.com

9 votes

Is it possible to PIVOT on a LIKE statement

sql-server sql-server-2014 pivot asked Sep 10 '19 at 8:36
dba.stackexchange.com

7 votes

Is the function PARSENAME() the opposite of QUOTENAME()

sql-server functions string-manipulation asked Jan 23 '18 at 14:18
dba.stackexchange.com

6 votes

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

sql-server sql-server-2014 sql-server-2016 configuration ssas asked Oct 23 '18 at 13:18
dba.stackexchange.com

6 votes

When are non-parameterized, non-trivial, adhoc query plans reused

sql-server sql-server-2016 execution-plan asked Nov 5 '19 at 12:05
dba.stackexchange.com

5 votes

How to create sums/counts of grouped items over multiple tables

sql-server sql sql-server-2012 sql-server-2014 window-functions asked Feb 8 '17 at 13:18
dba.stackexchange.com

5 votes

What Other Information Is Stored in The Page Header

sql-server sql-server-2012 sql-server-2008-r2 sql-server-2014 sql-server-2017 asked Jul 10 '18 at 14:12
dba.stackexchange.com


Top Answers
93
How to delete domain user profile from a computer?
serverfault.com

22
Automatically execute query in MS SQL Studio every hour
dba.stackexchange.com

17
Understanding CleanupTime in Ola Hallengren's SQL Server scripts in relation to FULL backups and LOG backups
dba.stackexchange.com

16
Online page restore hitting 1000 limit
dba.stackexchange.com

14
Winter Bash 2018 Knitting
meta.stackexchange.com

13
Creating an Index on a varchar(1024) column succeeded. Does it work?
dba.stackexchange.com

12
Is Microsoft SQL Server 2016 fully ANSI SQL-92 compliant?
dba.stackexchange.com

12
Electronic opt-out, correcting miscommunication, and additional questions answered about the 2018 ToS update
meta.stackexchange.com

11
EU copyright laws (2018-2019). Any risk for Stack Exchange?
meta.stackexchange.com

11
Making sense of sys.objects, sys.system_objects, and sys.sysobjects?
dba.stackexchange.com

11
SSMS 2014 Gives an exception when opening the new query window
dba.stackexchange.com

11
SQL Server Management Studio slow opening new windows
dba.stackexchange.com

10
How to lock a sql login after N unsuccessful login attempts
dba.stackexchange.com

10
Changing sa password
dba.stackexchange.com

9
Backup SQL Server 2016 Instance Logins
dba.stackexchange.com

8
How to tell if a backup log chain is broken?
dba.stackexchange.com

8
What is an orphan incarnation?
dba.stackexchange.com

8
Need suggestion on Back up Strategy
dba.stackexchange.com

8
cannot execute as the database principal because the principal does not exist - DB Restoration
dba.stackexchange.com

7
Does SQL Server 2016 Standard Edition include replication?
dba.stackexchange.com

7
How to kick users from Windows Server 2012 R2
serverfault.com

7
Why is the First Transaction Log backup of the day huge
dba.stackexchange.com

7
Fix SQL Table with *BOTH* Heap AND Clustered Index
dba.stackexchange.com

7
Upgrading from SQL Server 2012 SP1 to SQL Server 2019
dba.stackexchange.com

7
How to force users to specify a filegroup when creating tables/indexes
dba.stackexchange.com

6
Internally, how does OpenRowset(TABLE …) work?
dba.stackexchange.com

6
Can anyone explain to me the concept “incarnation” in Oracle database in an easy-to-understand way?
dba.stackexchange.com

6
Does backing up a database shrink the transaction log size?
dba.stackexchange.com

6
Is the function PARSENAME() the opposite of QUOTENAME()
dba.stackexchange.com

6
A Tone-Deaf Prophet
puzzling.stackexchange.com

1 2 3