Exam Prep 70-463: Installing Master Data Services
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-04-21 (first published: 2015-04-13)
5,509 reads
Azure SQL Database Firewall Settings
The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one...
2015-04-24 (first published: 2015-04-13)
5,266 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
491 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
889 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
5,018 reads
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
18 reads
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,145 reads
Handling Mixed Format Data Files in SSIS
Some time back I wrote about how to use the script component to parse out ragged data files in SSIS....
2015-04-22 (first published: 2015-04-13)
6,021 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
24 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
937 reads
Blogs
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers