How to bulk enable or disable SQL Server agent jobs ?
It often happens that you need to disable or enable all jobs in SQL Server Agent in one shot. Script...
2015-06-22
2,502 reads
Copying a TDE database from one instance to another
I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know...
2015-06-22
921 reads
Reading Extended Event File Session Data
Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will frequently tell people to use is the file target....
2015-06-21
9 reads
Reading Extended Event File Session Data
Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will...
2015-06-21
1,743 reads
A myth about view TIP #102
I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer...
2015-06-20
538 reads
PASSMN Presentation Follow-Up: Strategies for SQL Server Index Analysis
This past Tuesday, I got a chance to speak at the Minnesota SQL Server User Group. It was a great...
2015-06-19
526 reads
008 – Wayne Sheffield – MCM - WaterOx Consulting
Reading Time: 2 minutesMeet the SQL Master! In WOxPod!, episode # 008 – “Wayne Sheffield...
The post 008 – Wayne Sheffield – MCM appeared first...
2015-06-19
570 reads
Bulk Copy Program (BCP)–A simple way to export data in a file TIP#101
Let’s consider a scenario where the end user require a CSV file of all the records in a table then...
2015-06-18
1,308 reads
Thursday Morning SQL Break – June 15, 2015
It’s Thursday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-06-18
695 reads
Notes from the June 17, 2015 MagicPASS Meeting
Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...
2015-06-18
371 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
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...
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....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers