If you have a number of SQL Server instances with versions ranging from 2005 upwards, with a whole host of databases, and you want to be alerted about a number of diverse events that are useful for first-line problem-diagnosis and auditing, then Feodor's homebrew solution, using SSIS and Robocopy is likely to be what you're looking for.
2014-02-17
5,089 reads
Cerebrata has added support for configuring the more detailed level Windows Azure Storage Analytics, as well as managing the Cross-Origin Resource Sharing (CORS) setting.
2014-02-14
1,736 reads
Under heavy load your SQL Server may not work as intended due to lack of resources. To handle this situation SQL Server 2014 gives us the possibility to use an SSD or Ram device to dynamically increase the Buffer Pool. Keep reading to see how you can take advantage of this new wonderful feature.
2014-02-14
2,811 reads
An examination into how the various transaction isolation levels affect locking (and blocking)
2014-02-13
9,026 reads
We’re changing how users get SQL Source Control updates, and we want to learn how users feel about the current update process. Take the survey for a chance to win one of five $25 Amazon vouchers.
2014-02-13
3,013 reads
If, before deployment, you need to push the limits of your disk subsystem in order to determine whether the hardware’s I/O capacity meets the needs of a database application, if you need performance baselines, or if you want to identify any performance-related issues, then why not use the sqlio utility?
2014-02-13
6,077 reads
With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance. Read on to learn more.
2014-02-12
3,945 reads
The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way that, wherever you can use a table, you can use a table expression. Such derived tables can provide powerful magic, to which is added CTEs and Lateral Tables.
2014-02-11
4,675 reads
SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on Friday March 7 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
2014-02-11
1,337 reads
We've made a change to the forums at SQLServerCentral. Learn how you can mark a post as an answer to your question and help others.
2014-02-10
687 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers