Why NULL Placement Matters
Not those Benjamin’s
Benjamin Franklin once said, “A place for everything and everything in it’s place“. While I assume that he...
2015-06-10 (first published: 2015-06-04)
3,164 reads
SQLSaturday #408 Houston
I have been selected again to speak in Houston (Saturday, June 13th) for a SQLSaturday event and look forward to...
2015-06-04
535 reads
Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7
Hi friends, in last previous blogs we created database mail profile and database mail account. In this blog we will...
2015-06-04
493 reads
FORMATing Dates
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-06-11 (first published: 2015-06-03)
3,310 reads
What is Microsoft Azure Stream Analytics?
Microsoft Azure Stream Analytics (ASA) is a fully managed cloud service for real-time processing of streaming data. ASA makes it easy...
2015-06-03
1,093 reads
Blacklist a Set of IPs - WaterOx Consulting
Reading Time: 3 minutesWe talked about whitelisting IPs before, but what about the opposite, blacklisting...
The post Blacklist a Set of...
2015-06-03
445 reads
Notes From The May 2015 oPASS Meeting
Really late posting these, forgot to put on my task list!
About 20 attendeesLots of good questions, and I saw quite...
2015-06-03
391 reads
Clean up all (most) of the orphans on an instance
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone...
2015-06-03
1,682 reads
The Key to Successful Analysis
The key to successful analysis is to ask enough good questions.
How do you know that you’ve asked enough questions? When...
2015-06-12 (first published: 2015-06-03)
2,112 reads
SQL Server 2016 features to look for -1
At this year’s inaugural Ignite Conference in held in Chicago Microsoft announced that the next release of SQL Server, previously...
2015-06-03
1,154 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