SQL Saturday is coming to New Haven, Connecticut on March 01, 2014. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This is a free event, so register early to secure your place.
2014-02-18
1,325 reads
Recently we presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance. Today we will accomplish the same objective by employing a more traditional approach to data extraction, transformation, and loading (ETL) that relies on SQL Server Integration Services (SSIS).
2014-02-18
3,765 reads
Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.
2014-02-17 (first published: 2011-01-26)
14,590 reads
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,033 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
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Whatsapp.083831617937 Jl. Pluit Samudra No. 9 Blok N Kav. 5 Jakarta Utara, DKI Jakarta,...
Whatsapp. 083831617937 Jl. Pluit Timur Blok L Barat Kav. 41-42 No.12A-14 Jakarta Utara, DKI...
Whatsapp.083831617937 Ruko Prima Sunter, Jl. Danau Sunter Utara No.A2-A3 Jakarta Utara, DKI Jakarta, Indonesia...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers