Becoming a PASS Chapter Leader – Challenge Accepted!
My first real introduction to PASS was back in 1998. I was an “Accidential DBA” and needed some training. I...
2015-04-14
538 reads
Planning a High Availability and Disaster Recovery Plan in Puerto Rico
I’ll be doing a precon for SQLSaturday #373 in Puerto Rico on May 8th, 2015 titled “Planning a High Availability and Disaster...
2015-04-14
675 reads
Modify SQL Agent Jobs using PowerShell and SMO
So here we are, week 2 of the #SQLNewBlogger Challenge. This is a follow on to last weeks post Monitoring...
2015-04-27 (first published: 2015-04-14)
8,963 reads
Remotely shutting down an instance
This month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t)...
2015-04-23 (first published: 2015-04-14)
5,336 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
842 reads
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,500 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,255 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
482 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
882 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,001 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers