In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.
For as long as I have worked with SQL Server, and on almost every system I've ever managed, tempdb has been a bottleneck in one way or another.
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
In this article Filip Holub looks at how to configure and enable transparent data encryption for a SQL Server database using PowerShell.
Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
Today, Grant Fritchey compares a disaster caused by a toilet to technical debt in IT.
Stephanie Herr describes the new features in the Deployment Suite for Oracle that will help you automate your database releases safely, on Linux or Windows.
One of the most critical things that a game must do is to save data like the preferences and score. In this article, Lance Talbert demonstrates two ways to save data when you create your game in Unity.
By Steve Jones
According to this post, I rate 2019 as a Failure. Of the books I...
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Hi I have SQL Server FCI running in my DC site following are cluster...
Hello experts, A client is reporting the following error when his application tries to...
I installed Oracle 12 on Windows 10 in all possible ways/configurations, including the defaults....
Ask SSC