SQLSaturday (Silicon Valley) Detect Worst Performing SQL Queries During Peak Hour
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them...
2016-04-05
505 reads
Power BI Embedded is here
The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone...
2016-04-05
576 reads
Scaling Azure VM’s
There are so many benefits to the cloud, but one of the major features is the ease of use in...
2016-04-05
668 reads
MongoDB -Calculating Collection Size
Calculating Collection Size
We can get the size of a collections by using the shell’s functions
db.collection.dataSize(): Returns data size in bytes...
2016-04-05
679 reads
Views and Simplification
I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...
2016-04-05
560 reads
SQL Server Service Broker – Conversation Architecture
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-04-05
685 reads
Weekly Roundup–SQL Server and Related News
Welcome to this weeks weekly round up of links, SQL Server and other news. Its been a busy week on...
2016-04-05
408 reads
SQL Server PerfMon Counters Not Listed in dm_os_performance_counters
Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older...
2016-04-05
1,493 reads
Locking sa
When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the...
2016-04-04
1,044 reads
Don't Use Delimiters In Your Object Names!
It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file...
2016-04-04
2,285 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