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 […]
[et_pb_section bb_built=”1″][et_pb_row][et_pb_column type=”4_4″][et_pb_text] We are excited to announce that we are sponsoring InnoTech Austin IT & Innovation Conference for a second year in a row. Last year’s training event saw over 1000 attendees, if you didn’t make it, well here’s your chance to get in for FREE! Just go to www.innotechaustin.com and use our complimentary […]
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. […]
I am super excited that I was selected to present my AlwaysOn – Finally A Usable ‘Mirror’ session in Redmond, WA. The session is an hour long and is for SQLSaturday 212 on May 18th, 2013. The place will be loaded with SQL Server all-stars, oh and I’ll also be there. Some will be Microsoft […]
Intro Microsoft SQL Server has had Mirroring starting with version 2005, and now that SQL Server 2012 is released, there is an additional feature set called AlwaysOn (marketing info | technical info). AlwaysOn in currently an Enterprise only feature, so Standard Edition users will still need to use Mirroring. I would describe AlwaysOn this way: […]