Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6
Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....
2015-05-30
871 reads
Finding gaps or missing dates in a date range using TSQL
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...
2015-05-29
16,349 reads
Query Progress Tracking in SQL Server for the DBA VC
This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.
The session covers...
2015-05-29
1,419 reads
005 – Antiques Roadshow - WaterOx Consulting
Reading Time: 4 minutesAre You Running An Antiques Roadshow? In WOxPod!, episode # 005 –...
The post 005 – Antiques Roadshow appeared first...
2015-05-29
1,100 reads
hey its time for 2016!!!
Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can...
2015-05-29
1,215 reads
Detach and Attach All User Databases
Sometimes you are in a scenario where you need to transfer a large number of databases from one server to...
2015-05-29
1,108 reads
Installing SQL Server 2016 CTP2 – UI Changes
SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No,...
2015-05-29
3,258 reads
Earning my MCSE: Business Intelligence Certification
I earned my MCSE: Business Intelligence Certification on May 27, 2015. It was a long road, but I did it....
2015-05-28
1,524 reads
SQL Server 2008 R2 SP3 Install Errors
Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would...
2015-05-28
2,101 reads
Notes on the May 27, 2015 PASS Town Hall
I attended the online Town Hall yesterday, the second one that PASS has held this year. The recording should be...
2015-05-28
857 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