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 bookmarks subscriptions
Top Questions
21 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

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

10 votes

Break the link between a Database User and SQL Server Login

sql-server sql-server-2016 permissions security asked May 15 '20 at 13:35
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

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

7 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

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

What are valid connection strings for SSMS login box?

sql-server ssms connectivity sqlcmd asked Apr 6 '16 at 8:40
dba.stackexchange.com

1 2

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

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

22
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
Creating an Index on a varchar(1024) column succeeded. Does it work?
dba.stackexchange.com

14
Winter Bash 2018 Knitting
meta.stackexchange.com

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

12
OLE DB provider “MSOLEDBSQL” with SQL Server not supported?
dba.stackexchange.com

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

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

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

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

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

11
Changing sa password
dba.stackexchange.com

10
How many cores are used for serial plans in SQL Server?
dba.stackexchange.com

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

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

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

9
How to backup an Oracle database from SQL Developer
dba.stackexchange.com

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

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

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

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

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

7
Break the link between a Database User and SQL Server Login
dba.stackexchange.com

7
Connect to SQL Server over Internet
dba.stackexchange.com

7
Incorrect syntax near the keyword 'Exec'
dba.stackexchange.com

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

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

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

1 2 3