(Joe Gavin) You need to create an automated process to transfer files using Secure File Transfer Protocol (SFTP) with SQL Server Agent. Check out this article to learn how.
Tag: sql server
SQL SERVER – SSMS Install Error 0x80070652 – Setup is Blocked Due to Another Install Currently running. Please Let the Other Install Complete and then Restart the Computer if Necessary
(Pinal Dave) While preparing for a demo for my client Comprehensive Database Performance Health Check, I was installing necessary applications on my laptop. In this blog, I would share my experience with SQL Server Management Studio SSMS install error – Setup is blocked due to another install curren
(Jack Vamvas) Question: In the application error logs there is a message – The DELETE statement conflicted with the REFERENCE constraint FK_xxxxxxxxx
(Nai Biao Zhou) Many organizations have known the fact that data have been evolved from the by-product of corporate applications into a strategic asset . Like other corporate assets, the asset requires specialized skills to maintain and analyze.
(Hadi Fadlallah) There are many operations that we may run while working with OLAP cubes such as cube and partitions processing, executing administrative tasks, performing analysis and more…
(Kenneth Fisher) The other day I saw a weird option for the UPDATE command in a stack overflow answer. Basically it looked like this:
(Pinal Dave) Earlier this week, I wrote a blog post about SQL SERVER – Top Reasons for Slow Performance. The blog post got extremely popular as it contained many real-world problems and suggestions. After the blog post was released, I received quite many emails and questions.
(Maria Colgan) I got a lot of follow-up questions on what Query Block names are and how to find them, after my recent post about using SQL Patches to influence execution plans.
(Ron L’Esteve) The need to process Big Data Real-Time streams is becoming an increasing need for many businesses. Customers in numerous industries are seeking to harness the power of real-time big data to unlock valuable insights.
(Thomas LaRock) I’ve written before about using sqlmap to perform sql injection testing against a website. It is also possible to use sqlmap to connect directly against a database.