Print .SQL certificate files (.MK, .CER and .PK) on PAPER for long term storage in vault - Hi Guys, Did anyone find a way to print .SQL certificate files (.MK, .CER and .PK) on PAPER for long term...
Always on and SSISDB - Hopefully someone more knowledgeable than me can help with this one. I am building out a SQL 2017 Always on availability...
Restrictions Regarding High Availability Groups - We have two databases, one is 10TB in size and one is very highly transactional. Both have been dismissed as...
Upgrade to 2014 or 2016 - Dear DBAs I hope you guys are doing great My company is planning on upgrading all 2008 R2 database servers...
Help me in designing table and its indexes -
Always encrpted and user defined datatypes ????? throwing error. - Hi All, We are doing a POC on SQL Server 2016 new security feature Always encrypted. Basic need is encryption over wire....
Verify backup files. How much does it help? - Since I start my DBA career, as the best practice, I always verify backup to make sure it is complete...
SSD server with 1 logical drive - We are looking to upgrade to a solid state drives only server. It will be raided. Does it make any...
Fill in gaps between 2 dates - Hi All, Need some help in filling up gaps between 2 dates. Scenario : I have Product Location balance snapshot for specific dates ...
Shutting down a Virtual Machine running SQL Server - We had an impending power outage the other night, and I was in a rush to shutdown all of the...
Same query different actual execution plan - I guess I could summarise my question by asking if a query plan is created based on available resources. Here is...
Datatype Change - Changed one of the existing column datatype from varchar(250) to nvarchar(250) but the column still showing arabic characters as ?? How...
How does SQL Server handle concurrent operations? - Hello, We are having an issue which I suspect is database related. We have a web application on which we can...
Trying to get an SFTP process for SSIS - Hi, I have been looking all over the web for this. I realize that SSIS does not, on its own handle...
Parse a string help - I have a string that I need to parse. The text will vary but the format always the same. Example Text: ...
Manipulate a field that contains a specific format - Hi, Please can anyone assist with my SQL problem? Here's an example of the contents of a single field: abcdef 01/01/2018 08:15:13 This is...
SQL Agent Job - Carry on Failure - Hi I have script that I run to fix orphaned user accounts on a instance - If I run the script in...
Script Out Database Mail Settings? - Anyone bother to have created a script to Reverse Engineer / Script out your EXISTING database mail settings? I set up a...
dbWarden questions - Hello -- I am trying out the dbWarden application by running it within the 2008 Standard R2 SQL Studio application. It...
Implementing FULL-TEXT Search in a Google fashion! - OK, my first post on a subject I startd learning a couple days ago! SQL2K5 Full Text Search! Right....creating the FTS...
