Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the dacpac and database has been deployed. The process looks...
2015-07-20
9 reads
SQL Server Management Studio – Footloose and Fancy Free
That’s right. There’s been a divorce. SQL Server Management Studio (SSMS) has been divorced from the server product. In fact,...
2015-07-20
733 reads
I’m Speaking! Edmonton SQL Server User Group
I am honored to be speaking at the Edmonton SQL Server User Group. I always find it humbling to be...
2015-07-20
486 reads
Orlando SQL Saturday Precon – Transform and Visualize Data with Power BI
I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturdayfor the first time...
2015-07-24 (first published: 2015-07-20)
2,113 reads
The Database Corruption Challenge
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes...
2015-07-20
373 reads
The Database Corruption Challenge
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes...
2015-07-20
1,013 reads
How to close all active database connections in one shot?
While trying to restore SQL Server database or do any other actions which require exclusive database access you may face...
2015-07-20
8,272 reads
Filtered Index restrictions and Kendra Little’s Index Quiz
A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had...
2015-07-24 (first published: 2015-07-20)
2,185 reads
SQLSaturday Orlando 2015–Classes on Thursday and Friday for Even More Learning
We have a solid tradition here in Orlando of offering some all day classes the Thursday and Friday before SQLSaturday....
2015-07-20
633 reads
SQL Server Polybase (2016)
What is SQL Server Polybase?
Coming in SQL Server 2016 is the ability to query relational tables as well as data...
2015-07-20
1,321 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
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers