Designing for offloaded log backups in AlwaysOn Availability Groups – Part 2 – Monitoring
AlwaysOn Availability Groups have made a big splash in the SQL world and are quickly becoming the HA and DR...
2015-04-13
1,123 reads
Blog Posts
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 2 – Monitoring
AlwaysOn Availability Groups have made a big splash in the SQL world and are quickly becoming the HA and DR technology of choice for many SQL Server environments. Crucial...
2015-04-13
4 reads
How to restore Master database – SQL Server System Database?
Steps to restore SQL Server Master Database :- 1) Stop SQL Server Services 2) Add [-m] startup parameter in SQL Services from configuration manager Parameter [-m] Starts SQL Server...
2015-04-13
4 reads
How to Test Existing T-SQL Code Before Changing the Compatibility Level
You can easily determine whether existing stored procedures, UDFs and views can work in a higher (or lower, if you wish) compatibility...
2015-04-13
4,973 reads
In-Memory OLTP: Part 2 – Indexes
Following on from In-Memory OLTP: Part 1 – Introduction where we created a database capable of hosting memory optimised tables, I’d...
2015-04-13
471 reads
In-Memory OLTP: Part 2 – Indexes
Following on from In-Memory OLTP: Part 1 – Introduction where we created a database capable of hosting memory optimised tables, I’d...
2015-04-13
878 reads
Introduction to Wait Statistics in SQL Server
In today’s blog posting I want to talk more about the Wait Statistics in SQL Server and how they can...
2015-04-13
914 reads
Patching Master Data Services
I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS...
2015-04-13
829 reads
Database Compatibility Level 101
Each SQL Server database has a setting called Compatibility Level that determines how T-SQL commands are interpreted and what features...
2015-04-12
1,711 reads
SQL Server 2014 Upgrade Sessions on the Microsoft Virtual Academy
It was a great honor to be asked to join my associates from SolidQ at the Microsoft Virtual Academy Studios...
2015-04-12
173 reads
Blogs
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers