A Dominoes game of Texas 42 inspires Joe Celko to explore unusual uses for check constraints and views. Sometimes, the best way of discovering useful SQL techniques is to tackle the more unusual problems.
2013-09-19
2,976 reads
SQL Server Central Webinar #25: Best Practices in Database Deployment (Part 1)
2013-09-18
1,029 reads
Grant Fritchey (SQL Server MVP) and David Simner (Red Gate developer) give you a step-by-step guide of how you can automate your database deployment Process using Red Gate Deployment Manager.
2013-09-18
276 reads
If you are interested in learning firsthand what new features are available, then you should download and install the new SQL Server bits. In this article Greg Larsen will walk you through preparing, downloading and the steps to install the SQL Server 2014 CTP1 release.
2013-09-18
2,741 reads
Join SQL Server MVP Brad McGehee to learn why it is so important to monitor your SQL Server instances and what you should consider when starting out. This webinar will also show you how you can use Red Gate's SQL Monitor for SQL Server monitoring and will include an overview of the new features released in v3.0, including the ability to create your own custom metric definition and to support different access permissions.
2013-09-18 (first published: 2012-04-05)
3,412 reads
Scott Murray has used the Top and Bottom T-SQL functions in SQL Server and wonders, do the same functions exist in the SQL Server Analysis Services (SSAS) or MDX? If so, how do they work? Can you provide some examples? Check out this tip to learn more.
2013-09-17
3,320 reads
Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery.
2013-09-16
2,399 reads
SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact.
2013-09-13
3,371 reads
In real-world applications, it often makes sense to show denormalized data, such as delimited lists, within the application's user interface. Dwain Camps shows why, and how, the distribution business stores information about 'islands' in sequences in order to track the status of the shipping of a consignment. It makes a great SQL puzzle.
2013-09-12
3,371 reads
Kun Lee had a database where the log file kept growing and used 99.99% of the available space. He noticed miscellaneous change data capture objects still in the database as well as open transactions. This was causing his transaction log to continue to grow, but he couldn't disable CDC, because SQL Server thought it was not enabled. Read the full article to see his solution.
2013-09-11
3,682 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Call Center Batik Air Yogyakarta dapat di lakukan menghubungi CS resmi Batik Air di...
Call Center Batik Air medan dapat di lakukan menghubungi Layanan resmi Batik Air di...
Call Center Batik Air Tangerang dapat di lakukan menghubungi Layanan resmi Batik Air di...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers