• Schedule backups on regular intervals in Azure Backup

    I have SQL Server on premises, data is about 20GB. I want to scheduled backups on regular intervals in Azure Backup. Would like to how it works?

    mmreddykiran5 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • INSERT or CREATE record in SQL Server database

    I have this SQL Server table structure: MyTable(KEY, datafield1, datafield2...) And now I have to update an existing record / create a new one if it doesn't appear. What's the best way to do that?

    ITKE380,300 pointsBadges:
  • Ignores my new column-store index in SQL Server 2014

    I am using SQL Server 2014. I had an existing table with lots of indexes. I added a non clustered column-store index as a test. When I run test queries it ignores my new column-store index. I don’t know Why? Should I remove the old indexes, leaving just the column store?

    danieljones2,650 pointsBadges:
  • SQL Server – SSIS

    what is SSIs in Sql Server?

    90497265505 pointsBadges:
  • Difference between nvarchar(max) and NText

    Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

    ITKE380,300 pointsBadges:
  • How am I blocking connections to SQL Server 2008?

    This is a fairly specific issue, but I'm at a loss for reasons to what might be happening. We have SQL Server 2008 running on what we'll call ServerA. We can RDP in ServerA, we can ping ServerA. If we RDP into ServerA, we can open up SQL Server Management Studio and connect to all of the database...

    edwinjhoffer3,140 pointsBadges:
  • Recovering a truncated table on a SQL Server

    How can I recover a truncated table on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Grant permissions to user for backup/restore in SQL Server

    Can anyone tell me what permissions must I give to a user inside SQL Server 2005 so that this user can backup and restore a database without given him sysadmin server role?

    edwinjhoffer3,140 pointsBadges:
  • Problem with SQL Server Database File(.mdf)

    I am using SQL Server 2008 R2 and I want to check my master database file (.mdf) but failed to open it.

    edwinjhoffer3,140 pointsBadges:
  • How to disable SQL Server Management Studio for a user

    Is there a way to prevent users from getting into SQL Server Management Studio so that they can't just edit table rows manually? They still need to access the tables by running my application.

    edwinjhoffer3,140 pointsBadges:
  • Report having more than 240 columns in SSRS 2005

    Hi folks, I am using SSRS 2005 BI. As per MSDN standards SSRS 2005 will not support more than 240 columns in excel (while exporting, will get error). Now I am having more than 240 columns though I am using SSRS 2005, I am not getting any errors. However there is an error here: Reporting Services...

    BhakthaprahladaReddy2,030 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

    How would I go about migrating SQL Server 2005 back to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to copy complete database architecture, SP’s and function except data in SQL Server

    I am have a database called Database1 having 100 tables with 1lack records. Now I want the same architecture and sp's and functions present under this database, expect data into newly created database called Database2? How can I achieve this?

    BhakthaprahladaReddy2,030 pointsBadges:
  • Exporting to Excel – Sort doesn’t work due to merged cells

    How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

    Gma885 pointsBadges:
  • Exporting SSRS Report in Simple Excel sheet(not formatted)

    Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

    Avhilash5 pointsBadges:
  • SQL Server 2008: Job was invoked schedule 188

    After execution, it says job was invoked schedule 188. How can this be solved?

    ike66045 pointsBadges:
  • Rotate keys in SQL Server encryption for PCI compliance

    I understand that PCI compliance needs an annual rotation of keys. It's for decrypting your data, followed by re-encrypting it with a new key. So we have around 16 databases that are across 3 servers and multiple tables. It's only going to get bigger. Could I write something for this? Or should I...

    ITKE380,300 pointsBadges:
  • Reading COBOL indexed file in SQL procedure in iSeries

    How do I read a COBOL indexed file in SQL procedure in iSeries?

    Bhusha40 pointsBadges:
  • Encrypt SQL Server 2008 database for PCI compliance

    I'm pretty new to PCI compliance and from what I understand I need to secure a person's credit card info, expiration date and the card holder's name. There's not going to be storage of security codes ever. So in my SQL Server 2008 database, I would need to encrypt these 3 columns? Also, do I need...

    ITKE380,300 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following