Aaron Bertrand recently answered a question from a user who wanted to convert all of their SQL Server computed columns to be persisted. This allows you to shift the SQL Server cost of performing the computation from query time to the time of the insert/update, at the cost of storage. In this tip, Aaron shows you how.
Join Red Gate’s Alex Yates and TeamCity for a free webinar this Thursday, October 2nd. In this practical demo, Alex will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. Places are limited – register now.
It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.
Rodney Landrum on finding the inspiration you need, somehow and from somewhere, to get yourself out of a tight corner.
Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.
Hosting a scalable application in Azure seems ideal, but what happens when things go wrong? Azure Cloud Services provide extensive diagnostics, and this feature has now been extended to Azure web sites and Azure Virtual Machines. You need to set up diagnostics on the VM, but once this is done, all your logs, traces and performance counters can be collected from many VMs in one place for easy management.
An interview with James Rowland-Jones in advance of the PASS election.
Big Data implementations are more than just lots of data. Of equal importance is the analytics software used to query the data. Analyzing business data using advanced analytics is common, especially in companies that already have an enterprise data warehouse. It is therefore only natural that your big data application must be integrated with the existing warehouse.
This is Orlando's 8th SQLSaturday and this year will be better than ever with more than 50 different speakers giving over 50 presentations - all for FREE. Sept 27, 2014.
Step by Step guide to setup SQL Server Agent Alert for the proactive monitoring of Monitoring of Longest Running Transactions.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Jl. Tebet Raya No.25 B Blok CI, Tebet Tim., Kec. Tebet, Kota Jakarta Selatan,...
Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
BCA Finance Telpon/WA:08218168291.Komplek Ruko Senapati Land, Jl. By Pass Blok A No.23, Bende, Kec....
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers