Adding File to Database in AlwaysOn Availability Group
When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...
2018-07-27
6,249 reads
Keep up with SQL Server Patches!
Keep up with SQL Server Patches with us with our feed from Microsoft. Check it out! http://vitamindba.com/sql-server-releases/
The post Keep up with...
2018-07-26
315 reads
SQL Server – Stairway to Database Backup-and -Restore, (and Recovery)- Complete Guide
It’s a time to turn the corner from “DBA” to “DBA specialist”. This in-depth guide explores the importance of database...
2018-07-26
406 reads
Save the Connection String Parameters in SSMS – AlwaysOn
In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...
2018-08-10 (first published: 2018-07-26)
2,598 reads
Are your backup files where they say they are?
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...
2018-08-08 (first published: 2018-07-25)
2,043 reads
Power BI Custom Visuals Class (Module 112 – Acterys Matrix Light)
In this module you will learn how to use the Acterys Matrix Light. Acterys Matrix Light is designed primarily for...
2018-08-14 (first published: 2018-07-25)
2,166 reads
Know more about SQL Server MSDB log store for database backups, restores, and recovery: Q& A – Part 3
In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database. How do...
2018-07-25
347 reads
Know more about SQL Server database backups, restores, and recovery: Q& A – Part 2
In this article, you’ll see the Q&A about the database restore and recovery internals. To learn a lot about SQL...
2018-07-25
340 reads
Know more about SQL Server database backups, restores, and recovery: Q& A – Part 1
Let’s deep dive and review each of the database backup command topics to get a better understanding of what it...
2018-07-25
330 reads
A PowerShell Pester Check for parsing SQL scripts
I like to write Pester checks to make sure that all is as expected! This is just a quick post...
2018-07-25
1,301 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers