Synonyms in SQL Server – Good and Bad
When SQL Server 2005 was released, a nifty little feature was included called synonyms. Despite being around since SQL Server...
2018-12-14
297 reads
Jason Brimhall
Synonyms in SQL Server – Good and Bad
How you use a synonym can be a huge asset or it can be a significant dampener to performance. There are benefits and uses for these nifty little things....
2018-12-14
13 reads
Maintenance Plan Owner – Back to Basics
Have you ever taken over a server that had several maintenance plans on it? Have you ever really checked who the owner of those plans is? Or, maybe you...
2018-12-13
13 reads
Maintenance Plan Owner – Back to Basics
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2018-12-13
220 reads
To Influence or Be Influenced?
How have you impacted somebody in the community?
Well, have I come up with a doozy of a topic for this...
2018-12-11
184 reads
To Influence or Be Influenced?
Getting feedback from others is that little check that is needed to help progress and move in the right direction. When allowing time and opportunity for feedback from others,...
2018-12-11
2 reads
Ghosts in your Database
Yes Virginia, there are ghosts in your database. More specifically, there are ghosts in your SQL Server database. They are...
2018-12-10 (first published: 2018-11-26)
2,540 reads
The Mystery of Missing Backup Files
Yoink – Backups Gone
Not only is this mystery of missing backup files worth discussing now, but has been a mystery worth...
2018-12-10
299 reads
The Mystery of Missing Backup Files
Managing database backups is a critical role of the successful DBA. Understanding what the backup plan is and ensuring backups occur on schedule is not always transparent to the...
2018-12-10
1 reads
Capture the Flag – The Trace Flag
Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to...
2018-12-06
79 reads
Blogs
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
Building Effective Data Governance Framework: Top Areas to Focus On
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
Forums
Creating paginated report where each page is a month in the range selected
With in the paginated report I am trying to display on each new page...
Upgrading SSIS and SSRS from SQL Server 2016
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016,...
Do You Want a Microsoft Solution?
Comments posted to this topic are about the item Do You Want a Microsoft...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers