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.
Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.
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.
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.
An examination into how the various transaction isolation levels affect locking (and blocking)
What is continuous integration for databases? Steve Jones gives a short explanation and information on why you might care about this.
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.
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?
Do you know how often to back up your SQL Server transaction log? Steve Jones has a few thoughts today and notes that you definitely need to know how to restore the log backups.
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.
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
WhatsApp:083179431313 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
WhatsApp:083179431313 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur 60225
WhatsApp:0817866887 Jl. Kalimantan No.14, Gubeng, Kec. Gubeng, Surabaya, Jawa Timur 60281
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers