Technical communities are thriving and the knowledge they provide to professionals is immense. In the SQL Server community especially, countless blog sites, forum posts, tweets, webinars and white papers exist that help DBAs solve tough problems every day and we are all fortunate to have such information available to us with a simple Web search. Sometimes, […]
We are very excited to announce that SQLWatchmen is now a Redgate Certified Partner. For those unfamiliar with Redgate, they are a leading provider of software for professionals working on the Microsoft data platform. Our favorite product from Redgate is their SQL Toolbelt. This suite of tools helps users implement DevOps best practice for their databases, […]
You know the old joke that goes, “A DBA walks into a bar, sees some friends at a couple of tables and asks if he can join them.”? Well, as DBAs we are used to dealing with tables. Whether the data comes from a log file, trace file, or XML, we want to turn it […]
Microsoft announced the much anticipated SQL Server 2017 release is available for download today. This version is packed with so many features, here are just a few of what we’re looking forward to here at SQLWatchmen: Always On Availibility Group – supporting the ability to cross database transactions among all databases, as well as, clusterless […]
We are excited to announce that SQLWatchmen’s CEO, Jim Murphy, will be speaking at this year’s Houston TechFest. Jim will be presenting “SQL Server Tips from the Field – 3 Things IT Leaders Must Know About SQL Server”. You can catch his session in the SQL Server track at 10:40 am. Houston TechFest will be […]
The Problem with Overprovisioning in the Cloud When it is time to purchase new resources for one or more applications, the non-scientific approach of “guesstimating” the requirements can be expensive whether for on-premises capital expenditures or Cloud-based services. For stakeholders deciding on how to provision the data services, is it better to start small and grow […]
Row-Level Security (RLS) is one of the most often asked for features that I hear from customers. Done correctly, Row-Level Security ensures data segregation for users in a single database. This ensures each user can only view or manipulate data that they can access. Now you can share a database in a multi-tenant environment without the […]
I’m excited to say that my AlwaysOn session was selected for the South Florida SQL Saturday (in the Ft. Lauderdale/Miami area). I have never been to this part of FL before so I am quite excited. They scheduled me to speak at the same time as another AlwaysOn session in the next room. Synchronous redundancy. […]