Monday Morning SQL Break – February 22, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-03-11
469 reads
Extraordinary #1
I’ve seen tables that are referenced by many other tables in MSSQL databases and that number was usually being around...
2016-03-10
122 reads
Different ways to find Data, log and DB Size
Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files
SELECT instance_name AS DatabaseName,
[Data...
2016-03-10
1,112 reads
PASS Cloud Virtual Chapter – Call for Presenters
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2016-03-10
372 reads
January MVP – Mike Fal
In case you missed it, back in November I blogged about the importance of nominating individuals within the SQL Server...
2016-03-10
391 reads
You don’t need to be a sysadmin
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,324 reads
Availability Group DMVs Reporting Incorrect Values
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism for AlwaysOn Availability Groups. Check out the many new...
2016-03-10
19 reads
Availability Group DMVs Reporting Incorrect Values
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism...
2016-03-16 (first published: 2016-03-10)
1,815 reads
Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
17 reads
Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
6 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