(Viktor van den Berg) This article discusses how to configure a SQL Server database connection to be used by VMware vCenter Orchestrator. Although this task is not too difficult, there are a few pitfalls that might prevent the successful configuration of the database and connecting to it.
Tag: sql server
FSharp.Data.SqlClient: Seamlessly integrating T-SQL and F# in the same code
(Dmitry Sevastianov) In this post, we will explore the FSharp.Data.SqlClient library, and in particiular the SqlCommandProvider, which allows a new way of using both SQL syntax and F# syntax in data scripting.
Truncate all tables in a SQL Server database
(Dave Bennett) As a DBA I have found many occasions in testing of various SQL Server deployments and scripts where I need to load a database with data from a lower environment or where I need to alter a table that might already have data in it in such a way that I need to first eliminate the data be
Intelligent error alerting to reduce On-call hours
Intelligent error alerting to reduce On-call hours: The purpose of this article is to get you some much needed sleep! Yes, you heard me! So try to stay awake for this! I intend to introduce you to a few tried and true strategies to improve error and issue resolution and ultimately get you and your teammates a good night’s sleep....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Sql Server Error Message: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed
Ran into an interesting error message today. On one of our lab servers, I was making some changes to test a deployment and I was running FULL database backup and adding/removing some data files on the same database.
Check constraints not what you thought they were?
(Dave Green) I was recently adding a check constraint to a table in SQL Server, and noted some behaviour which surprised me, so I thought I’d share it with you. I’ve tried this on SQL Server 2012 and 2008 R2.
MS SQL Server iff function vs ‘case when’
In SQL server, people sometimes use iff function, which is also an Excel function, to assign different values based on a condition. For example, the following query returns 1 if the amt is less than 50, and 0 otherwise.
Increasing the SSMS Table Designer Timeout Value
(Michael Otey) Q: I’m getting an error changing the schema for a table using the Table Designer in SQL Server Management Studio (SSMS). I’m trying to change a column from nulls allowed to not null. The table has about 200,000 rows.
Troubleshooting Errors with SQL Server 2014 Encrypted Backups
(Vinod Kumar) The more I play around with Encrypted backups, the more I get to uncover things. It is highly recommended that you read the other posts (Troubleshooting SQL Server 2014 Encrypted Backups) before going ahead because these are all linked in one way or other.
SSIS Packages executed from Visual Studio Business Intelligence Development Studio – BIDS [Design time] on a 64bit development server goes to unresponsive state during package execution.
(Snehadeep) Through the use of this blog, I would like to address a common scenario that you would run into when executing a complex SSIS package from within the BIDS environment in a x64 bit development server, where the visual studio- BIDS environment goes to a hanged state during the package exec