HA/DR for Azure SQL Database
Azure SQL Database is a relational database-as-a-service in the cloud. It uses a special version of Microsoft SQL Server as...
2016-01-20
964 reads
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-20
411 reads
Start SQL Server without tempdb
tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter.
While at the...
2016-01-20
10,658 reads
Using SQL Server Change Tracking for Incremental Loads
Earlier this week I wrote about the basics of change tracking in SQL Server, and showed how to get started...
2016-01-28 (first published: 2016-01-20)
3,010 reads
SQL Server Community Activities under Surat User Group
I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on...
2016-01-20
344 reads
T-SQL Tuesday #74: Be the Change Round-up
Thanks to everybody that participated in this month’s T-SQL Tuesday. A big thanks to everyone who wrote a participating blog...
2016-01-20
667 reads
Change Availability Group Endpoint Port
Let’s say you have a port conflict and need to change the port on your Availability Group endpoint. How can...
2016-01-19
1,739 reads
New SQL Blogging Challenge
I recently came across Tim Ford’s (B|T) challenge to the technical blogging community. The challenge is to write one introductory...
2016-01-19
410 reads
Stop using Task Manager to check SQL’s memory usage!
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why...
2016-01-19
2,022 reads
Shrinking Database Data Files
Normal DBAs will sum up shrinking a database data file in one word: NO! I’ll talk to you about this subject because I’m not normal. Still, my goal is that...
2016-01-19
49 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