(Adam Kreul) SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature. Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route).
Tag: sql server
Updating All Jobs To Check For AG Primary Replica
(Denny Cherry) One of the really annoying things about moving existing SQL Server databases into an Availability Group is setting up the jobs to work within the confines of the AlwaysOn Availability Group.
SQL Server – New Database Backup Encryption with SQL Server 2014
(Hareesh Gottipati) With the release of Microsoft SQL Server 2014, we have the first version of SQL Server that supports encrypting database backups directly from the database engine without any third party software being installed on the SQL Server.
Creating a SSRS report to show SSIS package run time statistics
(Junaith Haja) In most companies developers are restricted from accessing the MSDB database and they rarely know the performance of their packages in a production environment unless they have access to third party software tools or a friendly DBA.
Proactive SQL Server Health Checks, Part 4 : ERRORLOG
(Erin Stellato) There is so much you can say about history and importance. History of a country, of civilization, of each of us. I love quotes and like this one from Teddy Roosevelt (cool guy):
Using Set Theory to Integrate Development and Deployment
(Uri Margalit) In today’s agile world, development teams must respond quickly to ever changing business needs. The traditional practice is to use a task management system, such as JiRA, TeamForge, TFS, RTC, or others. These systems manage the business requirements and break them into tasks for the d
SQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level
(Pinal Dave) It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations.
What is Polyglot Persistence?
(James Serra) Polyglot Persistence is a fancy term to mean that when storing data, it is best to use multiple data storage technologies, chosen based upon the way data is being used by individual applications or components of a single application.
Proactive SQL Server Health Checks, Part 4 : ERRORLOG
(Erin Stellato) There is so much you can say about history and importance. History of a country, of civilization, of each of us. I love quotes and like this one from Teddy Roosevelt (cool guy):
Using Set Theory to Integrate Development and Deployment
(Uri Margalit) In today’s agile world, development teams must respond quickly to ever changing business needs. The traditional practice is to use a task management system, such as JiRA, TeamForge, TFS, RTC, or others. These systems manage the business requirements and break them into tasks for the d