Here's a few of the new posts today on the forums. To see more, visit the forums.
|
Best Compression Tool for Encrypted Databases - Hi there, I was tasked with TDE encryption of our Clients databases. I set up all the needed keys and certificates and encrypted couple pre production databases. But now I am facing a problem. Our Company is utilizing Dell LiteSpeed software for SQL Server as out Backup and Restore tool. Compression level of this tool […] |
Grant Bulk Insert Restrictions - Hi, Is it possible to restrict Bulk Insert permissions? Let's say you want to grant BULK INSERT for Temporary tables only. Can this be done? Thanks, TJ |
Can i create a table from my parameters? - If yes, any links to instructions would be great. I am often times asked to search for parts, and their associated data (price, seller, buyer, size, etc. in our database. note: I use SSMS, but then I load the reports into SSRS/SharePoint for the end user. I am given a list of, for example, 100 […] |
Report on the entire SQL Server environment for a newcomer - Is anyone aware of a script/SP somewhere that would produce in one big result-set or report the overall information on a given SQL Server? I mean all database sizes, users, security, server configurations, replication, etc. etc. , etc., and EVERYTHING that a newly hired DBA would be interested to see and learn about each particular […] |
Question on AWS DMS - Good morning Experts, Primary keys are mandatory for transactional replication. If table has no primary key, it will not be replicated. How is it in AWS DMS? Are primary keys mandatory and If table has no primary key, it will not be replicated? |
help to fix hash procedure - hi, i create a procedure to get hash code from entire table's contents. it works fine in 99% , but in some cases it returns the same number for different data. in this code the ord value is swapped for two records, bat the hash is the same. is there a way to fix the […] |
Code snippets removing line spaces - I just posted a topic in the SQL 2012 T-SQL forum group and the board removed all the line spaces between sections of code, making (to my eyes) what I posted completely unreadable. It's hard to tell one line from another, even though when I go to edit the post, the code box shows my […] |
Converting Substring to DateTime - extra eyes please - I'm experimenting with a backup / purge backup solution for our non-prod environment. Every 3 hours, a copy-only backup of a prod database gets taken and pushed down to a non-prod NAS share. I'm only supposed to keep 4 backups (12 hours worth), so I wrote a script to purge them. My original code looked […] |
Availability groups and dedicated NICs - Hi there, Looking for some advice here: I currently have 3 SQL servers in a single AG with a single network card on each server. During times of heavy network usage, we are sometimes seeing failovers to a secondary server. After some research, I see that the way round this is to have […] |
Delimited Identifiers in code interpreted as BBCode - It seems that if you delimit identifier a single value in brackets using inline code markup (surround it with backticks) the value is interpreted as bbcode markup instead. In all the below examples I use [ U S E R ]. For example, the value in a code sample And in inline code: . It […] |
Help in SQL server - Hello everyone, I am New in this Forum and in SQL Server, i will glad for your Help for a little quastion: I want to create a job, that execute Backup for five database, every day in certain time. How do i create the jobs? thanks! |
Connect to SQL Database in Visual studio 2017 via Active directory - Hello! I am authenticating my SQL database via active directory. Now when I am trying to connect to the database via Visual studio then the connection is failing because of login in windows authentication. The problem is I am using laptop given by my employer to work for client. So the windows authentication fails since […] |
A set has been encountered that cannot contain calculated members - Hi Guys, I have a cube and works for more then 4 years. I get a error when I trying to browse in the Cube: A set has been encountered that cannot contain calculated members The following MDX Im running: SELECT NON EMPTY { [Measures].[% hours] } ON COLUMNS FROM ( SELECT ( { [Bookperiod].[Bookperiod].[All […] |
Status Update 6 May 2019 - Mostly unchanged from previous days. The fixes logged today are mostly backend, infrastructure items that should improve some performance. We've had a few timeout issues that I hope will not re-occur. Two resources out this week, but another developer should be coming online. Perf and Infrastructure - 38 items backlogged, 1 in progress, 3 fixes […] |
OLE DB Destination Editor VS OLE DB connection VS ADO NET - I am having trouble displaying table as set out in the book "Microsoft SQL Server 2012 Integration Services: An Expert Cookbook" page:96. The Book states i must return to OLE DB Source Editor. In the OLE DB Source Editor, i am not able to view the table that has bee created. I can view the […] |