(Pinal Dave) Just another day, I received an email from a user who has over 350 thousand tables in a single database. He was my earlier customer of Comprehensive Database Performance Health Check. He was facing indeed a very strange issue where his metadata table was locking up and we fixed that by
Tag: sql server
(Craig Stedman) Microsoft embeds its SSRS reporting software and more-advanced data preparation tools in Power BI, part of a plan to blend self-service and enterprise BI for users.
(Kenneth Fisher) Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a broad range of knowledge in an area that may not be overly deep and one or more spikes of deeper knowledge.
(CliveW) This week there was a good discussion on how to show an SLA view in Log Analytics, which was similar to a feature in System Center Operations Manager, the output and query I’m sure will be useful for others.
(Thomas LaRock) I don’t want to alarm you, but your cloud is infested with vampires.
(Jason Brimhall) As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be visibly represented as the wrinkles on your face. Other times, as with SQL Server, it may mean that a stored procedure or view stops working.
(Laerte Junior) I was and still am a big fan of SQLPSX (SQL PowerShell Extensions).
SQL SERVER – XML Document Could Not be Created Because Server Memory is Low. Use sp_xml_removedocument to release XML documents
(Pinal Dave) Most of my earnings come from my role as SQL Server Performance Tuning and Optimization consultant. Every single day I work with few customers so that I can maintain the quality of my work with each of them.
#0413 – SQL Server – Interview Question – Why are some columns displayed with a negative sign in sp_help?
(Nakul Vachhrajani) One of the first things I do when I start work on a new database is to use “sp_help” to go through each table and study their structure.
(FonsecaSergio) If you try to create more than 4 geo-replicas in the Portal it will fail with the error message “Replication limit reached. The database ‘XXXXX’ cannot have more than 4 replication relationships.”