What's your failover plan. In today's world downtime equates lost money for most companies. High availability & up time is so crucial, that most are willing to spend the money and mirror their primary environment. We are all familiar with the infamous banner: "The website is down for routine maintenance". It's as annoying as counterproductive. In a DevOps environment, software engineers create processes such as deployment plans (we'll discuss this further another time) that will complement the ......
We often need to create similar SSIS packages which contain some common components such as connection managers, data flow components, log providers, event handlers, etc... So do we really need to create a package from scratch each time and add all these commonly used components in each package again and again. Is it possible to create a SSIS package with a basic structure/workflow and common components which can be used as template to create subsequent packages?Below is a great article for this solution:http://www.mssqlti... ......
Here is a quick query to identify your db status when it comes to disk space:SELECT ds.name as filegroupname, df.name AS 'FileName' , physical_name AS 'PhysicalDBName', size/128 AS 'SizeInMB', size/128.0 - CAST(FILEPROPERTY(df.name, 'SpaceUsed') AS int)/128.0 AS 'RemainingSpaceInMB' , CAST(FILEPROPERTY(df.name, 'SpaceUsed') AS int)/128.0 AS 'SpaceUsedInMB', (CAST(FILEPROPERTY(df.name, 'SpaceUsed') AS int)/128.0)/(size/128)*100. as 'SpaceUsed'FROM sys.database_files df LEFT OUTER JOIN sys.data_spaces ......
For most companies, development and operation teams play a game of volleyball passing blame on each other when service/product has issues. Lack of communication and understanding between the two, causes costly and timely problems for every company. DevOps is not a title, nor is a position. DevOps is concept represented by a white flag waved from both directions. Cooperation and Communication are at the heart of DevOps. It tears down the wall and pride of these two very valuable entities inside a ......