Increasingly, as we’re working with people to help out with infrastructure and with setup and considerations for their servers and solutions (wow, that’s a long breath), the trend is about handing off to cloud providers… That’s all well and good, but there’s a bit a devil in the details, so to speak. One of the things that seems to be […]
SQL Server
Troubleshooting problems with Master Data Services in SQL Server 2016
Troubleshooting problems with Master Data Services in SQL Server 2016 If you have problems with SQL Server 2016 Master Data Services (MDS), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 MDS bugs were fixed in SQL Server service packs, you should install the latest SQL Server...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
SSWUG Virtual Conference Starts Tomorrow (Tuesday)
If you haven’t had a chance to register yet – here’s the direct link: http://www.sswugvc.com It’ll get you to the site, you can check out the sessions, see what’s up. This is all about the learning. All about the sessions. We have some excellent information and learning for you – and it’s two full days of two tracks. We’ll also […]
Version Control For Your Schemas, Jobs?
There are many different options for managing source code of course. Perhaps one of the most referenced is GitHub and the integration tools and such are very strong for managing your source and application bits and pieces. For some reason, many don’t think about including scripts, table structures, basically all of the things to do with the database, in their […]
How to make accurate estimates in an Agile environment – Part 3
This is the last installment of a 3-Part article regarding a question from a busy SQA Huddle Lead professional: How can we create more accurate estimates in an Agile space? With all our analysts as beginner, in an Agile space, I don’t believe they have been exposed to any concept of “resource estimation” or “test execution rate”, and therefore providing...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Scale-Out vs. Scale-Up as a Cloud Success Indicator
Sometimes, the things that drive the market just sort of creep up on you. Surprising things. We’re all here talking about big data-this, big data-that. Storage management. Performance. All of those things. They’ve traditionally often been all about scaling UP your application (bigger servers, more power, etc.). I know I’ve had the discussion with people many, many times about considerations […]
Do You Disclose Immediately… Or…?
One of the big news items of the day is that Microsoft’s internal database of vulnerabilities was hacked in 2013. That’s a while ago! As I was reading all of the posts talking about how these types of things should immediately be disclosed, and that it applies not only to a hack of systems, but also disclosing vulnerabilities, I found […]
Troubleshooting SQL Server 2016 Columnstore Indexes
Troubleshooting SQL Server 2016 Columnstore Indexes If you have problems with SQL Server 2016 columnstore indexes, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 columnstore indexes bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Data Flow and Capacity… and Knowing All The Variables
Data sources are certainly something that should be on nearly everyone’s radar. With more devices, more analysis and more utility coming from information than ever before, it’s pretty obvious that our pendulum associated with being a data professional will have yet more swings in the direction of managing performance as things expand. This post from was interesting as they tried […]
A Holistic View of Database Management System (DBMS) – Part 4
Entity or Real World Object The entity can be an actual world item, either moving or motionless, which can be effortlessly distinguishable. For an instance, in a college database, Students, Faculty, Classes, as well as Courses which are offered can be taken as the entities. Each of these entities has a number of column or attributes or properties which give...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here