Need to know how to use the “Filter” item in the SSMS Object Explorer Details window to show a specific list of tables that contain a specific string of characters? If so, then read on!
2019-07-02
John Morehouse describes how a quest to help solve his organization's "deployment bottleneck" led them to a place where they could both deliver application and database changes into the wild at a pace to satisfy customer demand, and achieve a better work-life balance for the team, both of which are well worth having.
2019-07-01
In this article, Kellyn Pot’Vin-Gorman continues teaching SQL Server DBAs how to navigate Linux. She demonstrates usings aliases, setting up environment variables, and examining processes.
2019-07-01
Brent Ozar gives some advice to those of you who give presentations to user groups and conferences.
2019-06-28
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.
2019-06-27
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.
2019-06-27
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
2019-06-26
Ever since the GDPR was introduced, the subject of data breach notifications has worried a lot of people. How do you write one? What do you need to include? What will the ramifications be? Will it make your customers run for the hills? Will it get you fired?
2019-06-26
You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on...
2019-06-25
Phil Factor provides a PowerShell script to disconnect your laptop without risking error 21, if you're working with SQL Clone and need to go offline. The same script will then bring the clone database back online smoothly, once you're reconnected.
2019-06-25
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
I am using ssrs in visual studio 2022, I work on a report, there...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers