The day before SQL Saturday Silicon Valley, SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on March 14 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
2014-02-25
1,782 reads
A common method to detect if a row has changed is to compare hashes. Integration Services itself doesn’t have a hash implementation, so in this tip I’ll show how you can implement a hash detection mechanism using a script component, as an alternative to the pure T-SQL solution.
2014-02-25
3,416 reads
sp_ExecuteSQL can be used to dynamically execute T-SQL code. Learn how to use it and how to add parameters to control what code is executed.
2014-02-24
10,557 reads
All DBAs need to engage in a little project management to help make sure everything runs smoothly. In this extract from the book Tribal SQL, David Tate explains his system for managing workload, colleagues, and projects, and how not to be just "the guy who says no".
2014-02-24
3,072 reads
March 15, SQLServerCentral's Steve Jones and many others (including Kalen Delaney, Kevin Boles, and Karen Lopez) will be presenting at SQL Saturday Silicon Valley. This is a free, one-day learning event about SQL Server, Microsoft Business Intelligence, and Big Data. Register soon while spots are available.
2014-02-24
1,672 reads
A Hyper-V replica will provide a rapid disaster-recovery by simply replicating to a standby site a VM running at the primary site. Is it, therefore, ideal for running SQL Server in high-availability? Well, it depends on the type of HA you require, and whether you need the features that aren't supported.
2014-02-21
3,378 reads
SQL Saturday is coming to Vienna on March 6 with a full-day of technical training and networking, featuring international speakers. With over 20 sessions on SQL Server, the event is aimed at all those interested in SQL Server - from pros to beginners.
In 2014 the event is held for the first time in Austria, Vienna, organized by PASS Austria.
2014-02-21
1,646 reads
Learn how to create a SQL Server execution plan. This article explains the basics used in performance tuning, an important skill for DBA's and SQL developers alike.
2014-02-20
10,656 reads
SQL Server security related tasks can be divided into four main categories: physical security, operating system level security, SQL Server configuration and user management. Here is your SQL Server security checklist.
2014-02-20
4,963 reads
The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is a great relief to database professionals as it solves some problems what are awkward to solve with the IDENTITY property. Joe Celko explains the basics of using a SEQUENCE.
2014-02-19
5,839 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