Question : There is a reserved keyword DOUBLE in SQL Server, but I know that it’s not a data type […]
DbaFix
Deadlock on Merge replication
Question : I’m having a really confusing problem on the msmerge_contents table on some of my merge replication databases. It […]
Can anyone recommend an encryption method for ALL user dbs using SQL Server 2016 STANDARD edition?
Question : Our clients are insisting that we now encrypt ALL their SQL Server data at rest, which must include […]
MySql Switching Masters During Failover with log-slave-updates
Question : I am still pretty newbie to mysql. This question is regarding promoting slave with option –log-slave-updates to become […]
Prevent SQL Server Management Studio changing destination DB on restore
Question : Is there a way to prevent SQL Server Management Studio 2014 from automatically setting the destination database when […]
How can I get individual rowcounts like SSMS?
Question : I have a client c# program that is executing stored procedures via ExectueNonQuery, including catching the PRINT and […]
MySQL: carriage-return in query breaks my import
Question : I use simple echo “select * from tab” | mysql –batch –quick –skip-column-names …. > /tmp/file from mysql […]
Is it possible to backup and restore part of a database in sql-server?
Question : We have a sql-server 2005 database that we regularly transfer from our client site to ours. This takes […]
How to find out ALL the users that can connect to SSAS?
Question : I have an user called mycompanyaives that is not listed in the list of administrators in the SSAS, […]
Statistics. Are multicolumn histograms possible?
Question : I am thinking of a situation where I have two columns with high density but these columns are […]